Support us .Net Basics C# SQL ASP.NET Aarvi MVC Slides C# Programs Subscribe Download

Free sql server video tutorials for beginners

This set of video tutorials are suitable for beginners and  experienced .NET and sql server developers.

The videos start from the very basics of sql server, and covers advanced topics as you progress. If you are confident with the concepts discussed here, I am sure, you will be in a much better position to answer most of the interview questions. 

All these videos are hosted on youtube. I have created a playlist, which makes it easy to find all the videos in a logical sequence. Click here, if you prefer to watch them directly on youtube, using the playlist.
SQL Server Tutorial Playlist

I record and post videos, on a daily basis. If you would like to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel using the link below.

I have spent several months, preparing the text and videos for this video series, in the hope of helping students and software trainees. If you like this video series, and if you think it can help your friends just like you, please feel free to share the link with your friends on Facebook, Twitter and Google Plus.

I have managed to cover most of the sql server concepts. If you are in need of a specific concept, and if you don't find it here, please leave a comment and I shall have it added as soon as I can.

Free SQL Server video tutorial

  1. Connecting to SQL Server
  2. Working with databases
  3. Creating and working with tables
  4. Default Constraint
  5. Cascading referential integrity
  6. Check Constraint
  7. Identity Column
  8. Retrieving identity column value
  9. Unique key constraint
  10. All about select statement
  11. Group By
  12. Basic Joins
  13. Advanced Joins
  14. Self join
  15. Different ways to replace NULL
  16. Coalesce function
  17. Union and Union All
  18. Stored Procedures
  19. Stored Procedures with output parameters
  20. Difference between output parameters and return values
  21. Advantages of stored procedures
  22. Built in string functions
  23. Left, Reight, Charindex and Substring functions
  24. Replicate, Space, Patindex, Replace and Stuff functions
  25. DateTime functions
  26. IsDate, Day, Month, Year and DateName functions
  27. DatePart, DateAdd and DateDiff functions
  28. Convert and Cast functions
  29. Mathematical functions
  30. Scalar User Defined functions
  31. Inline Table Valued functions
  32. Multi-Statement Table Valued functions
  33. Important concepts related to functions in sql server
  34. Temporary tables
  35. Indexes
  36. Clustered and NonClustered Indexes
  37. Unique and Non-Unique Indexes
  38. Advantages and disadvantages of indexes
  40. Updateable Views
  41. Indexed Views
  42. View Limitations
  43. DML Triggers
  44. DML After Update Trigger
  45. Instead of insert trigger
  46. Instead of update trigger
  47. Instead of delete trigger
  48. Derived table and CTE's
  49. Common Table Expressions
  50. Updatable CTE
  51. Recursive CTE
  52. Normalization & First Normal Form
  53. 2NF and 3NF
  54. Pivot Operator
  55. Error handling in SQL Server 2000
  56. Error handling in SQL Server 2005 and later versions
  57. Transactions in SQL Server
  58. Transaction ACID Tests
  59. Subqueries in sql
  60. Correlated subquery
  61. Creating a large table with random data for performance testing
  62. What to choose for performance - SubQuery or Joins
  63. Cursors in sql server
  64. Replacing cursors using joins
  65. List all tables in a sql server database using a query
  66. Writing re-runnable sql server scripts
  67. Alter database table columns without dropping table
  68. Optional parameters in sql server stored procedures
  69. Merge in SQL Server
  70. SQL Server concurrent transactions
  71. SQL Server dirty read example
  72. SQL Server lost update problem
  73. Non repeatable read example in sql server
  74. Phantom reads example in sql server
  75. Snapshot isolation level in sql server
  76. Read committed snapshot isolation level in sql server
  77. Difference between snapshot isolation and read committed snapshot
  78. SQL Server deadlock example
  79. SQL Server deadlock victim selection
  80. Logging deadlocks in sql server
  81. SQL Server deadlock analysis and prevention
  82. Capturing deadlocks in sql profiler
  83. SQL Server deadlock error handling
  84. Handling deadlocks in
  85. Retry logic for deadlock exceptions
  86. How to find blocking queries in sql server
  87. SQL Server except operator
  88. Difference between except and not in sql server
  89. Intersect operator in sql server
  90. Difference between union intersect and except in sql server
  91. Cross apply and outer apply in sql server
  92. DDL Triggers in sql server
  93. Server-scoped ddl triggers
  94. SQL Server trigger execution order
  95. Audit table changes in sql server
  96. Logon triggers in sql server
  97. Select into in sql server
  98. Difference between where and having in sql server
  99. Table valued parameters in SQL Server
  100. Send datatable as parameter to stored procedure
  101. Grouping Sets in SQL Server
  102. Rollup in SQL Server
  103. Cube in SQL Server
  104. Difference between cube and rollup in SQL Server
  105. Grouping function in SQL Server
  106. GROUPING_ID function in SQL Server
  107. Debugging sql server stored procedures
  108. Over clause in SQL Server
  109. Row_Number function in SQL Server
  110. Rank and Dense_Rank in SQL Server
  111. Difference between rank dense_rank and row_number in SQL
  112. Calculate running total in SQL Server 2012
  113. NTILE function in SQL Server
  114. Lead and Lag functions in SQL Server 2012
  115. FIRST_VALUE function in SQL Server
  116. Window functions in SQL Server
  117. Difference between rows and range
  118. LAST_VALUE function in SQL Server
  119. UNPIVOT in SQL Server
  120. Reverse PIVOT table in SQL Server
  121. Choose function in SQL Server
  122. IIF function in SQL Server
  123. TRY_PARSE function in SQL Server 2012
  124. TRY_CONVERT function in SQL Server 2012
  125. EOMONTH function in SQL Server 2012
  126. DATEFROMPARTS function
  127. Difference between DateTime and SmallDateTime in SQL Server
  128. DateTime2FromParts function in SQL Server 2012
  129. Difference between DateTime and DateTime2 in SQL Server
  130. Offset fetch next in SQL Server 2012
  131. Identifying object dependencies in SQL Server
  132. sys.dm_sql_referencing_entities in SQL Server
  133. sp_depends in SQL Server
  134. Sequence object in SQL Server 2012
  135. Difference between sequence and identity in SQL Server
  136. Guid in SQL Server
  137. How to check GUID is null or empty in SQL Server
  138. Dynamic SQL in SQL Server
  139. Implement search web page using ASP.NET and Stored Procedure
  140. Implement search web page using ASP.NET and Dynamic SQL
  141. Prevent sql injection with dynamic sql
  142. Dynamic SQL in Stored Procedure
  143. Sql server query plan cache
  144. exec vs sp_executesql in sql server
  145. Dynamic sql table name variable
  146. Quotename function in SQL Server
  147. Dynamic SQL vs Stored Procedure
  148. Dynamic sql output parameter
  149. Temp tables in dynamic sql


  1. It's very usefull for those who belogs to IT and those who are intrested in IT caree thanks alot for these video tutorial specialy for sql and csharp

  2. plz upload what is difference between Const and Readonly

    1. Hi

      Basic difference between const and readonly is
      1.Const are compile time execution as well readonly excute as runtime
      2. you can change readonly values once but you could not in const.


    2. Constant:
      the behaviour of constant variable will be same as the behaviour of the static variable i.e both are does't require objct of the class for initialisation.
      the only difference between these two is "static" can be modified where as
      "constatnt" can't be modified once after initialization

    3. I dont think that const doesnt need object?? ru talking with respect to dot net c#...
      if so static members value can be initialized at declaration,constructors and static vs non static methods but the value remains same for all objects ie it is a class variable rather than instance variable whereas readonly can be initialized at declaration or in constructor rather then onwards its value can never be changed and in case of constant only at declaration time u must and should initialize...insance members are manipulated by objects in their own way
      ex rno of student is instance
      collegename of student is readonly
      collegenoticeboard data is static
      college loc is constant
      i hope this information would be needful...
      Phani kumar

  3. Hi Venkat,

    Can u put a video on Isolation levels in SQL Server 2008. It would be very helpful

  4. Thanks Venkat, For your videos but i am in confusion actually what is the main difference between view, temp Table, Derived Table, and Common Table. When these tables are used in real-time Environment.
    M waiting for your reply

  5. Hi sir, your service is helpful to beginners and middle level programmers thanks to you uploading videos with text data and please upload Cursors in sqlserver i think u covered all topics in sqlserver except Cursors.please upload as soon as possible i think most of viewers are waiting for these topics because we watched all videos.
    Once again special thanks.


  6. Hi Venkat Please take The vedio on Remaining types of indexes like spatial ,xml etc please.....

  7. Hi Ananth, currently I am, working on video series. Once I am done with that, I will record the videos on the rest of sql server indexes as requested by you.

  8. Thank You Very Much Venkat.Thank you for your assistance

  9. Hello! Venkat! I'm Kainar! By using this moment I want to say to you thank! You did very good job for us! Thank you! Also it would be very kind from you if you upload video about DDL triggers! ) Because now I'm working on that! In the internet there is ablolutely no information about that! I mean by video! ) So can you try your best on this? )) I'm begging you ) Mister Venkat! )

  10. thank you so much sir, i really learned many thing about c# and dot net and sql server. waiting for other video tutorials from u. and wpf and linq. honestly u helped me alot by making this video,thank u so much. god bless u sir

  11. Please add instructions for analyzing query performance and trace usage.

    I love your videos! Excelent job!

  12. Kudos Sir!! you are doing great work which is helping the community a lot

  13. Hi Venkat. I SALUTE YOU FROM BOTTOM OF MY HEART.You are doing really a great Job. God Bless You..!!

  14. Mr. Venkat,
    Would you please present us the Video Tutorials on
    Decryption of Stored Procedure, Fill Factor and UnPivot ?


  15. Hi Venkat Sir, thank you for all the tutorials, much appreciated..your explanation is easy to understand. i guess you would be the best person to ask this, could you please explain the famous Fizzbuzz query for me? thanks again

  16. Respected Sir G
    please upload the tutorial about reporting and crystal reporting.
    i shall be very very thankful to you sir g
    Liaqat ali

  17. Hi Venkat,

    You have already heard million thank you, but then again here is another one. Thank you so much for these videos. You are a great teacher and a very good human being. A teacher influences an eternity

  18. Hi venkat,

    Thank you for doing awesome job by posting the videos on your youtube channel step by step . It could be better if you cover the videos
    on cursors, locks and remaining triggers if you have a time.


  19. My intellisense feature doesn't work. can you pls help. I have installed it on a stand alone Windows machine. When I right click on the function the intellisense is not enabled. But in options-Transact-SQL it is checked. Can you please help?



  20. hi Venkat....

    it would be really helpfull, iif you upload some videos regarding
    designing windows application in c# using visual studio......

    thanks in advance....

  21. sir you are doing awesome job ... i have paid 7000 bucks for c# but my teacher neer explained so well as you dis sir!!!!!!!!!! god bless you sir!!!!

    1. hi venkat
      could u load videos on how to send mails before 3 working days

  22. hi venkat
    can u upload videos regarding if ...exists in storedprocedure pls

  23. Sir you are doing very good work... I appreciate your work and way how you teach , its god gift to you please continue with your work. I love to watch your videos and ll definetly share with all who can benefit this....

  24. This is soooooooo helpful. I'm a complete newbie to SQL I'm intersted in learning it and you explain it so well. By chance is there a link anywhere for the Power Point Presentation you are using?

  25. You are a gift!...thanks for the info..I have learnt so much..can't believe this is free..please, how can we donate to your project..Paypal?

  26. hello sir.... i very big thanks to you... awesome work.. great are going to inspiration for many... thank you.. :)

  27. hello part 30 of sql server my function is not working for dob- 13/11/1991(dd/mm/yyyy)
    it throws an error stating-Msg 241, Level 16, State 1, Line 1
    Conversion failed when converting date and/or time from character string.

    plz reply me what is the problem because it is even working for 12/11/1991

  28. Hi Venkat,
    Where can we download the sql PPT which you have shown in the video ,also in one of the video you referred to visit the blog for the scripts but there is no such link .
    Kindly help us to do so.


    1. Hi Vikas, all the information that is present in the PPT is also present in this blog. On this page, you can find the links to text version of the videos. Hope this helps.

  29. Sir,
    Would you please present us some videos on SQL Server Reporting Service?


  30. Kudos Venkat. You are doing awesome job here. I like your teaching style with all ppt's. Can you share your ideas or upload a video on APPLY operators? I want to see how we can use APPLY operator for on-fly functions.

    I know the way it benefits while dealing with table Valued functions, but I see some scripts using Apply in place of derived table for aggregating stuff.

    thanks in advance

  31. Great tutorials, very easy to follow and listen to you sir.

    Can you please show us how to import Excel files using the import wizard to automate updates and data changes to such files?

    Thanks in advance,

  32. GREAT tutorials, I watched every single tutorial on SQL server. It is very easy to follow and you explained the concepts so clear with the make-sense examples. Thank you, Venkat!

  33. Great job dear, you really did a great job which saved lot of times of students as well professionals to search and explore the required information over the internet, its all in one and in a very managed manner moreover in a very understandable and easy way to learn.

  34. Hi,

    Thanks for the informative videos. I would like to create a sequence in SQL Server and get the NEXT VALUE of it from C#. Can you please let me know how do you implement that


  35. Hello Venkat,

    I can not tell how much help I am getting from these videos. I believe you will get all the blessing in the world. I just want to know if you will start posting on SSIS,SSRS and SSAS. I know it is a lot of work, but I am just curious.

  36. Hi Venkat,your videos are very good and useful for starters who want to learn in easy and fast way.I have learned a lot from your SQL videos.
    By the way can u upload SSIS, SSAS and SSRS videos also it would be very helpful for learners as well.
    thank you

  37. Can you please upload your SQL Server Powerpoint files ?

    I want to print them all and then i'll "SQL SERVER in a Nutshell "

    mini book :)

    ( I bet people will want this also as well as the other subjects )

  38. Thank you for staying true to the computer community! its up to those that learn to continue with the tradition of free knowledge for all! your videos are great. thank you

  39. THANKS FROM THE BOTTOM MY HEART... GOD BLESS YOU... you are making life of many interested individuals who can not afford to take fancy training. Guess what you are getting what money can never buy... think of us, who's live you changed. We owe you!!!


  40. Hi Venkat,

    These are great videos! You are an amazing teacher!
    Would you make the slides available as well? The slides are concise, to the point, and super helpful.

    Thanks again!

    1. Thank you very much for taking time to give feedback. The slides are available on this blog at the following link.
      SQL Server Slides

  41. hi venkat,

    kindly provide http module and http handler topic from A-Z in great detail. and also what is the application life cycle. becoz i have facing problem in many interviews, and cant be able to explain them.

    i have nearby 5 years of experience. so would you kindly, tell me the topic that can be asked mostly with 5 years of experience guys.

    thanks for your kind support in advance.
    shiv shanker

  42. Hi Venkat,

    I am currently working in an organization where i am facing problems regarding TFS,SVN,VSS,Clear Case etc can you please provide videos to demonstrate the use of atleast these four Version Controlling software in detail. This is badly needed because along with development knowledge we should know version controlling to work in an organization.

  43. Sir,
    Please provide a video series on Sql Server Reporting Service and how to host that and how to access that from Windows and Web Application.

  44. Hi Venkat,

    First of all Thanks a lot for your videos ,they are very easy to understand.You had done a great job.
    Can you please upload videos on MVVM.

  45. what is the difference between attachment and conversion if i attach any db from sql 2000 to 2008 then conversion happens automatically i dont know. please give me this answer

  46. Hello Venkat Sir,
    What an excellent way of teaching! I wish I had a teacher like you in my school and college days. You are extremely good in explaining and you are truly an amazing teacher! Thank you very much for the tutorial. I am enjoying learning SQL server.

  47. Hello , a request from a belgian SQL server 2008r2 beginner.

    Let me first say that all video's i saw on YouTube are very practical and understandable, best of what i saw until now. Here is my problem
    In order to check KPI, How do i calculate
    1 workdays (function exist in excel but not in sql) between 2 dates considering that i must take notice as well of the
    2 bank holidays in that country where the shipment is going to.
    Let's say that there is a table called 'Bank Holidays' with colums Country, date, name bank Holiday
    Greetings Dominique (mailto :

  48. sir please tell me some book which contains difficult queries related to sql so that i can practice more.

  49. hello venkat, great work, i am stuck here on video 14 self join in sql, do i have to make another two tables and link those column via foreign key ? because i was following all the tutorials 1-13 i think i will have to change the structure of tblEmployee table am i right ? because i am having error on executing the query using the same tblEmployee as in previous video No. 13

  50. Hi Venkat, I have been watching many of your videos and I think you are a great teacher. I appreciate you taking the time to post videos and the passion you have for tech really shows. Thanks again from South Africa.

  51. Hi Vencat. Thank you for posting videos on youtube, they have been a great help to me. Please could you do sql interview question: select only identical values from two tables that have 1 or identical columns

  52. Hi,

    Your video tutorials are very good and learning so much from you.

    could you please share some tutorial on working with XML in SQL Server.

    It would be Great-full for us!

    thanks in advance

  53. Sir I want to insert data through a stored procedure into a database table.The procedure takes 2 parameters first the name of table which contains the table name in which data is to be inserted and second is User defined table type in which i pass datatable which contains data to be inserted.please tell me how can i do this.all my tables in database has same structure

  54. Hi, I have gone through your videos and you are doing a excellent job. Your tutorials have helped understand so many concepts.
    I just had request if you can explain Reflectors and Obfuscation by any chance.I tried many other sites but concept is not clear. It would be really helpful if you do.
    Thanks in advance :)

  55. Hello,
    Short question about deadlocks in SQL Server 2012.
    How long it takes SQL Server to kill a victim process in a DeadLock, or when SQL Server decides to kill one of the proceses??

    Thanks a lot,

  56. Hello,

    Still a university student but landed a SQL analyst job. These videos have helped me tremendously! Thank you Venkat!

    I have shared this video series with my professor who will offer it as a source of information for future students.

  57. can you upload a video on SQL PROFILER plz..

  58. Hi Venkat,

    How about some videos on designing/modeling a database based on business requirements implementing Normal Forms etc.. ??

  59. Hi venkat,

    can you please explain me how to compare two tables in sql especially which are there in different enviroments(like test and prod)

  60. Venkat Sir can you make one or two video's on how we can apply paging on sql server table.........

  61. Hi Venkat
    as i serched so many times for video based on three tier architecture which use Utility Class but there is no such video on youtube.and other videos which is not available on youtube is Crystel Report and you upload the video on those above mention topic it would help to so many people

  62. Thank you very much for the tutorial, i have gone through the entire tutorial and now what i can do with sql is amazing, just a simple request, how can we get Dynamic sql tutorial. Thank you.

  63. Hello Venkat plz will you give me the video link about what is SQL injection and how it prevent in video lacture no 21 the link you have given did'nt work plz give me the proper link i will be waiting for you reply

  64. Thanks a lot Venkat Sir for the great video tutorial that you have covered almost all the required things in the given videos . I have seen every video tutorials and made several notes by taking printout. You are requested to kindly upload tutorial for Android, IOs, Windows apps using platform like Xamarin.

  65. Hi venkat,

    this is Naresh, working as .Net developer
    I am following your training videos, Those are so much helpful for me , i am struggling with converting XMLclob data to ACORD AL3 format, please let me know.

  66. Hi Venkat, Your videos have been very helpful and simple to follow. Thanks for the great job.
    I am running into an sqlexception when trying to insert data into sql database and it shows as follows:
    SqlException (0x80131904): Invalid object name 'crequest'

    Please help figure out the cause of this error and how to fix it.

  67. Hi Venkat, Your videos have been very helpful and simple to follow. Thanks for the great job.
    I am running into an sqlexception when trying to insert data into sql database and it shows as follows:
    SqlException (0x80131904): Invalid object name 'crequest'

    Please help figure out the cause of this error and how to fix it.

    1. First check in which database u created the crequest table .. Lets say my database name is Sample.. so execute the below query..

      use Sample

      Now create the table with name crequest like below:

      create table crequest(Id int, Name varchar(20))

      now insert the record into the table.. it will get inserted ..

      I hope u got the answer....

  68. Can you please explain Performance tunning and execution plan in details and how to use sql server profiler

  69. Excellent blog!. I was looking for html tutorials and I landed your website through google search. I found your blog very interesting.

  70. Can you please explain user -sa in SQL server and how to use it?

  71. Hi Venkat,

    Thanks for your videos. Very good information is available in the videos for better and quick understanding.

    Could you please make a video on SQL Query Optimization techniques. When ever I go for an interview, interviewer is asking how to optimize the SQL Query and they are asking to explain with the real time example.

    Please give your thoughts on this question.

    Thank You for your good work.


    Sandani Basha Shaik

  72. Hi Venkat and all,

    I am PL/SQL developer and learnt SQL server from your videos.
    In PL/SQL I mainly used packages and procedures, but SQL server procedures work little different.
    They will be compiled on the first time run and I was reading some articles where they have suggested Procedures are not that good!!

    I want to know is that correct suggestion?
    And what is the ideal way of implementing a stored procedures?, Compiling, executing?
    What do SQL server developer mainly use in there day to day activities?
    What are the differences of PL/SQL developer and SQL developer?

    Thanks a Ton,

  73. Hi Venkat,

    Firstly,I really want to thank you from the bottom of my heart for the efforts you are putting in sharing your knowledge in simple and easy-to-understand language with appropriate examples and explanation.

    I would like to know if we can expect some advanced level topics like differential and full backup and restore, dead locks and DBA processes like log shipping, replication, mirroring and other daily DBA activities.

    You are doing an excellent job and keep up the great work.

    Although I know that you are very busy in creating .NET,MVC and other tech videos, it is a request to look into the above request as that would really help all the viewers to understand the complex topics in simple language.


  74. plz upload video about xml data processing in sql server

  75. Hi Venkat,

    Thanks for your videos. Very good information is available in the videos for better and quick understanding.

    Could you please make a video on SQL Query Optimization techniques. When ever I go for an interview, interviewer is asking how to optimize the SQL Query and they are asking to explain with the real time example.

    Please give your thoughts on this question.

    Thank You for your good work.


    Sandani Basha Shaik

  76. Please explain me this :

    view schema binding,
    view with check option


    1. View schema Binding: Lets a view is created on employee table with schema bind option enable.

      Now if you try deleting the Employee table, system will not allow you to do so.

  77. First I want to say heartfull thanks to you sir. Here my one request.

    Sir, Pls share some videos on below topics.

    1) what are Files and File groups and purpose of files and filegroups. Why these are? where we have to use? How to Use>

    2) breafly about .mdf ,.ndf and .ldf files.

    3)) Schemas

    Note: I try to learn these topics through online. but could not get understand.

    Thank you sir, in advance.


  78. hello sir , this one is sql interview question , i am unable to solve any help or any idea ....
    (Query the two cities in STATION table with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.)

    1. Hi sudhakar .. Check the Below code,, it almost satisfies ur requirement i hope so..

      first create table

      create table tblStation
      Id int,
      Name varchar(20),
      CityName varchar(20)

      //Now insert the six records into the table

      insert into tblStation values(1,'Howrah Station','Kolkata')
      insert into tblStation values(2,'Kempegowda Station','Bangalore')
      insert into tblStation values(3,'Gandhi Station','Ahmedabhad')
      insert into tblStation values(4,'Subash Station','Pune')
      insert into tblStation values(5,'Bhandra Staion','Kone')
      insert into tblStation values(6,'Kulum Station','PondiChery')

      Now write the below code which displays shortest city name,longest city name and there lengths..

      Declare @Small int
      Declare @Large int
      select @Small = Min(Len(CityName)) from tblStation
      select @Large = Max(Len(CityName)) from tblStation
      select Top 1 CityName as SmallestCityName,Len(CityName) as Minimumlength from tblStation where Len(CityName) = @Small Order by CityName Asc
      select Top 1 CityName as LargestCityName,Len(CityName) as MaximumLength from tblStation where Len(CityName) = @Large Order by CityName Asc

      Thank u for asking the question....


    I need the sql server query TO DELETE DUPLICATE RECORDS FROM A TABLE without using CTE

  80. can you also add a tutorial for partitioning very large tables?

  81. Hiya Venkat,

    Thanks a ton for such precise information..... My only hope was your videos to clear my IJP... and am through it.

  82. Hi Venkat,

    I have faced an interview questions which i could not answer. Please do a video covering following quesions.
    1) How to calculate standard deviation and variance using SQL.
    2)What are linear regression functions.
    3)Tell me something about Statistical functions in SQL.

    Please venkat please do a video on above topics which would be helpful for people who are looking for a role as data analyst.

  83. Hi,
    could you please do a video about XML in sql?

    Yours films are the best source of information about sql in all internet. Thank You So MUCH:)

  84. Can you please Explain Nesting Stored Procedures?

  85. please do video of MEMORY_OPTIMIZED and Native compiled store procedure

  86. i cannot view employee table by

    Select * from tblEmployee

    do i have to import these tables?

    please help i am noob :(

  87. Hi Venkat,

    i am new to this,, i unable to download microsoft sql server 2008,, could you please provide this...exact link...exe...

  88. Hi Venkat.. Please post MSBI tutorials.. No others can explain SQL server and MSBI like you. its humble request you to please do consider my request.

  89. Hi Venkat,

    Yesterday I faced one sql question can you help me to answer that.

    The question was
    If I have 3 insert statement
    1st having id that is primary key
    2nd and 3rd are foreign keys.
    First and 2 got successful but 3rd not successful so it will be rolled back

    So interviewer asked he want to stop 1st statement should not get rolled back

  90. I have very much thanks to you Mr Venkat. You have done great, very appreciation to your job. From the way you explain I am getting good and strong SQL base to help me to purse SQL IT career in Databases specifically MCSA and then MCSE

  91. What is Candidate key? Faced this question in a interview?

  92. Hello Venkat,
    Hope you are doing great. Your you-tube videos are great, am sure it benefited million people.
    Could you please upload on XML in SQL Server?
    thank you.

  93. First of all, I want to thank you for the videos you have created. It helped me a lot. Can you please provide tutorials for SSRS, SSAS and SSIS as well. I want to learn these as well.

  94. This comment has been removed by the author.


  95. Output column is calculated with adding Amt1 and Amt2 values to the Output Column value of previous record.
    Example: Output Column of
    first record is as it is of Amount column,
    second record will get from first record value of output column and amt1 , amt2 of first record i.e 100+0+10=110,
    third record is from 110+10+0=120
    fourth record is from 120+0+0=120
    fifth record is from 120+300+10=430 ...

  96. Hi venkat sir i have problem with visual studio 2013 .it is giving error in all project while running.when i want to run project and to view in chrome...

  97. You are the best teacher that I have seen so far. Your explanations are so clear and direct to the key points. You are far better than those who collect money for same knowledge. Keep it up.


  98. Can someone please send me the sample database link which venkat has mentioned

  99. Sir How can we use bell curve for grading

  100. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "tblPerson_GenderID_FK". The conflict occurred in database "Alan", table "dbo.tblGender", column 'ID'.

  101. Hi Venkat could you please post the video difference between IN and EXISTS IN SQL Server

  102. Hi Venkut, First I would like Thanks for sharing your videos on SQL. These are really great and simple to understand.
    Can you please make a video on PAGINATION on SQL SERVER
    Can you also provide a Sample of Complete Database schema with All queries, procedures etc for a Online Shopping WEbsite

  103. Thanks a lot from bottom of my heart for complete reference at one place. Thank you for your hard work.

  104. Create function fnComputeAge (@DOB Datetime)
    returns nvarchar(50)

    declare @tempdate datetime, @years int, @month int, @days int

    select @tempdate = @DOB

    select @years = DATEDIFF(YEAR, @tempdate, GETDATE())-
    when (MONTH(@DOB)>MONTH(GETDATE())) or
    then 1 else 0
    select @tempdate = DATEADD(YEAR, @years, @tempdate)
    select @month = DATEDIFF(MONTH, @tempdate, GETDATE())-
    when DAY(@DOB)>DAY(GETDATE())
    then 1 else 0
    select @tempdate = DATEADD(MONTH, @month, @tempdate)
    select @days = DATEDIFF(DAY, @tempdate, GETDATE())
    declare @Age nvarchar(50)
    set @Age =CAST( @years as nvarchar(5)) + 'Years' + Cast(@month as nvarchar(5)) + 'Months'+ cast(@days as nvarchar(4)) + 'Days old'
    return @Age

    i have a little question about the query above. I don't catch the case statement . Can you help me .. thanks in advance

  105. Hi ,

    Please share PL/SQL videos with logics for banking related.


It would be great if you can help share these free resources