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.
http://www.youtube.com/kudvenkat

 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
  39. Views
  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 ado.net
  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
    150.

118 comments:

  1. UnknownOctober 7, 2012 at 1:52 PM

    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

    ReplyDelete
  2. AnonymousOctober 10, 2012 at 7:53 AM

    plz upload what is difference between Const and Readonly

    ReplyDelete
    Replies
    1. oovkesersJuly 17, 2013 at 9:00 PM

      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.

      Thanks
      Chaitanya.

      Delete
    2. AnonymousFebruary 11, 2014 at 3:09 AM

      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

      Delete
    3. GreatIndianFebruary 23, 2014 at 7:11 PM

      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

      Delete
  3. AnonymousOctober 13, 2012 at 8:57 AM

    Hi Venkat,

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

    ReplyDelete
  4. UnknownOctober 18, 2012 at 7:22 PM

    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

    ReplyDelete
  5. Raghavendra.MadugundiOctober 19, 2012 at 12:06 AM

    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.

    Thanks&Regards,
    Raghu.

    ReplyDelete
  6. ANANTHOctober 21, 2012 at 6:38 AM

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

    ReplyDelete
  7. VenkatOctober 21, 2012 at 6:50 AM

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

    ReplyDelete
  8. ANANTHOctober 21, 2012 at 8:30 AM

    Thank You Very Much Venkat.Thank you for your assistance

    ReplyDelete
  9. UnknownOctober 21, 2012 at 12:44 PM

    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! )

    ReplyDelete
  10. ANANTHOctober 23, 2012 at 11:33 PM

    Happy VijayaDasami to all

    ReplyDelete
  11. AnonymousOctober 29, 2012 at 7:13 AM

    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. asp.net and wpf and linq. honestly u helped me alot by making this video,thank u so much. god bless u sir

    ReplyDelete
  12. AnonymousNovember 8, 2012 at 8:28 PM

    Please add instructions for analyzing query performance and trace usage.

    I love your videos! Excelent job!

    ReplyDelete
  13. Durga PrasadNovember 16, 2012 at 10:23 AM

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

    ReplyDelete
  14. UnknownDecember 10, 2012 at 3:43 AM

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

    ReplyDelete
  15. SimonDecember 18, 2012 at 10:21 PM

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

    Thanks

    ReplyDelete
  16. TJanuary 5, 2013 at 4:25 AM

    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

    ReplyDelete
  17. Shaiz AwanJanuary 8, 2013 at 12:49 AM

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

    ReplyDelete
  18. AnonymousJanuary 8, 2013 at 6:36 AM

    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

    ReplyDelete
  19. AnonymousJanuary 12, 2013 at 3:57 AM

    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.

    Thanks

    ReplyDelete
  20. AnonymousJanuary 20, 2013 at 11:56 AM

    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?

    Thanks

    Nisha


    ReplyDelete
  21. HemantFebruary 22, 2013 at 1:12 AM

    hi Venkat....

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

    thanks in advance....

    ReplyDelete
  22. AnonymousMarch 7, 2013 at 5:56 PM

    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!!!!

    ReplyDelete
    Replies
    1. AnonymousMarch 11, 2013 at 9:36 AM

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

      Delete
  23. AnonymousMarch 11, 2013 at 8:53 AM

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

    ReplyDelete
  24. Spidersilk06April 3, 2013 at 8:08 AM

    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....

    ReplyDelete
  25. AnonymousApril 27, 2013 at 12:02 AM

    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?

    ReplyDelete
  26. Ifanyi O.April 29, 2013 at 2:25 PM

    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?

    ReplyDelete
  27. sheenuMay 2, 2013 at 9:20 PM

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

    ReplyDelete
  28. UnknownMay 8, 2013 at 2:34 PM

    hello sir....in 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

    ReplyDelete
  29. vikasmehtaMay 10, 2013 at 4:19 AM

    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.

    THanks,
    Vicky

    ReplyDelete
    Replies
    1. VenkatMay 11, 2013 at 12:52 AM

      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.

      Delete
  30. AnteraMay 11, 2013 at 9:11 PM

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

    Thanks

    ReplyDelete
  31. UnknownMay 31, 2013 at 2:38 PM

    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

    ReplyDelete
  32. UnknownJune 16, 2013 at 9:48 AM

    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,

    Shayma.ahmad@gmail.com

    ReplyDelete
  33. AnonymousJune 26, 2013 at 5:31 PM

    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!

    ReplyDelete
  34. Khalid AfridiJune 30, 2013 at 4:20 PM

    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.
    Thanks!!!

    ReplyDelete
  35. AnonymousJuly 1, 2013 at 8:00 AM

    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

    Thanks

    ReplyDelete
  36. UnknownJuly 13, 2013 at 11:44 AM

    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.

    ReplyDelete
  37. rJuly 24, 2013 at 12:09 PM

    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

    ReplyDelete
  38. AnonymousJuly 24, 2013 at 2:55 PM

    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 )

    ReplyDelete
  39. AnonymousJuly 25, 2013 at 9:19 PM

    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

    ReplyDelete
  40. AnonymousAugust 1, 2013 at 12:02 PM

    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!!!

    RESPECT... YOU EARNED IT

    ReplyDelete
  41. BlazingMonkeySeptember 14, 2013 at 8:18 PM

    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!

    ReplyDelete
    Replies
    1. VenkatSeptember 15, 2013 at 8:46 AM

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

      Delete
  42. AnonymousNovember 22, 2013 at 9:47 PM

    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

    ReplyDelete
  43. UnknownDecember 6, 2013 at 10:47 AM

    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.

    ReplyDelete
  44. AjinkaDecember 18, 2013 at 10:05 PM

    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.
    Thanks

    ReplyDelete
  45. AnonymousDecember 30, 2013 at 4:48 AM

    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.

    ReplyDelete
  46. UnknownApril 20, 2014 at 11:30 PM

    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

    ReplyDelete
  47. UnknownMay 30, 2014 at 1:03 PM

    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.

    ReplyDelete
  48. AnonymousJune 4, 2014 at 5:08 PM

    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 : guitar.teacher@hotmail.be)

    ReplyDelete
  49. AnonymousJune 10, 2014 at 10:46 AM

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

    ReplyDelete
  50. ShamsJuly 5, 2014 at 2:28 AM

    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

    ReplyDelete
  51. AnonymousJuly 5, 2014 at 10:54 AM

    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.

    ReplyDelete
  52. mark.stJuly 7, 2014 at 2:25 PM

    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

    ReplyDelete
  53. Sunil Kumar KashyapJuly 11, 2014 at 4:20 AM

    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

    ReplyDelete
  54. AnonymousJuly 18, 2014 at 6:26 AM

    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

    ReplyDelete
  55. AnonymousSeptember 3, 2014 at 11:49 PM

    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 :)

    ReplyDelete
  56. AnonymousNovember 3, 2014 at 7:34 AM

    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,

    ReplyDelete
  57. AnonymousNovember 16, 2014 at 9:00 AM

    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.

    ReplyDelete
  58. AnonymousDecember 24, 2014 at 1:45 AM

    can you upload a video on SQL PROFILER plz..

    ReplyDelete
  59. AnonymousApril 28, 2015 at 9:04 AM

    Hi Venkat,

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

    ReplyDelete
  60. UnknownJuly 26, 2015 at 10:34 PM

    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)

    ReplyDelete
  61. UnknownAugust 22, 2015 at 4:24 AM

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

    ReplyDelete
  62. UnknownAugust 26, 2015 at 1:04 AM

    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
    thanks

    ReplyDelete
  63. UnknownAugust 31, 2015 at 3:13 AM

    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.

    ReplyDelete
  64. Muhammad AliSeptember 6, 2015 at 7:26 AM

    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

    ReplyDelete
  65. UnknownSeptember 24, 2015 at 10:02 PM

    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.

    ReplyDelete
  66. UnknownOctober 12, 2015 at 6:24 PM

    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.

    ReplyDelete
  67. Fii CofeOctober 16, 2015 at 6:34 AM

    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.

    ReplyDelete
  68. Fii CofeOctober 16, 2015 at 6:35 AM

    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.

    ReplyDelete
    Replies
    1. Rajendra Prasad C SAugust 2, 2016 at 3:21 AM

      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....

      Delete
  69. UnknownOctober 29, 2015 at 11:25 PM

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

    ReplyDelete
  70. UnknownOctober 30, 2015 at 5:13 AM

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

    ReplyDelete
  71. AnonymousNovember 10, 2015 at 7:59 PM

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

    ReplyDelete
  72. UnknownNovember 15, 2015 at 7:27 AM

    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.

    Regards,

    Sandani Basha Shaik

    ReplyDelete
  73. UnknownNovember 29, 2015 at 4:45 PM

    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,
    Arvind

    ReplyDelete
  74. RushabhWritesNovember 30, 2015 at 3:57 AM

    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.

    Regards,
    Rushabh

    ReplyDelete
  75. UnknownJanuary 7, 2016 at 5:12 PM

    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.

    Regards,

    Sandani Basha Shaik

    ReplyDelete
  76. UnknownJanuary 13, 2016 at 3:48 AM

    Please explain me this :

    view schema binding,
    view with check option

    Tenx

    ReplyDelete
    Replies
    1. UnknownFebruary 14, 2016 at 8:18 PM

      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.

      Delete
  77. Ajay PalJuly 15, 2016 at 1:44 PM

    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.

    ReplyDelete
  78. sudhakar singhJuly 18, 2016 at 12:47 PM


    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.)

    ReplyDelete
    Replies
    1. Rajendra Prasad C SJuly 31, 2016 at 10:13 PM

      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....








      Delete
  79. UnknownAugust 14, 2016 at 10:48 PM

    HELLO SIR

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

    ReplyDelete
  80. UnknownDecember 4, 2016 at 11:06 AM

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

    ReplyDelete
  81. AnonymousMarch 7, 2017 at 12:25 AM

    Hiya Venkat,

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

    ReplyDelete
  82. UnknownApril 2, 2017 at 10:29 PM

    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.

    ReplyDelete
  83. askasiJune 15, 2017 at 3:53 AM

    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:)

    ReplyDelete
  84. AnonymousSeptember 27, 2017 at 12:16 AM

    Can you please Explain Nesting Stored Procedures?

    ReplyDelete
  85. Mohbat RaiNovember 2, 2017 at 3:28 AM

    please do video of MEMORY_OPTIMIZED and Native compiled store procedure

    ReplyDelete
  86. AnonymousJanuary 12, 2018 at 2:19 AM

    i cannot view employee table by

    Select * from tblEmployee

    do i have to import these tables?

    please help i am noob :(

    ReplyDelete
  87. UnknownApril 8, 2018 at 3:15 AM

    Hi Venkat,

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

    ReplyDelete
  88. UnknownMay 4, 2018 at 7:51 PM

    First create the table

    ReplyDelete
  89. kundan kulkarniJune 5, 2018 at 9:17 PM

    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.

    ReplyDelete
  90. PankajAugust 5, 2018 at 4:55 AM

    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

    ReplyDelete
  91. UnknownAugust 9, 2018 at 1:07 PM

    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

    ReplyDelete
  92. UnknownSeptember 15, 2018 at 9:25 PM

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

    ReplyDelete
  93. UnknownOctober 14, 2018 at 11:55 AM

    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.
    Ali

    ReplyDelete
  94. This is a place where you learn, read and explore contents related to web development technology like ASP.NET , MVC, WEB API, Angular 2, Jquery, Linq, Entity framework, SQL, Barcode etc.October 23, 2018 at 9:21 AM

    Hi,

    Thanks. Your all post are very benefit.

    ReplyDelete
  95. UnknownFebruary 28, 2019 at 9:37 AM

    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.

    ReplyDelete
  96. Siniša JanjetovićJune 30, 2019 at 4:01 AM

    This comment has been removed by the author.

    ReplyDelete
  97. Pl.tell me how to write queryJuly 9, 2019 at 1:22 AM




    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 ...

    ReplyDelete
  98. Saddam husainSeptember 14, 2019 at 4:50 PM

    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...

    ReplyDelete
  99. Arlnorld TabongNovember 22, 2019 at 7:23 AM

    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.

    Thanks

    ReplyDelete
  100. manoharDecember 25, 2019 at 9:31 PM

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

    ReplyDelete
  101. UnknownMarch 10, 2020 at 11:28 PM

    Sir How can we use bell curve for grading

    ReplyDelete
  102. UnknownApril 22, 2020 at 7:17 AM

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

    ReplyDelete
  103. UnknownNovember 28, 2020 at 8:36 AM

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

    ReplyDelete
  104. SarfarazMay 30, 2021 at 5:03 AM

    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

    ReplyDelete
  105. Gopal SharmaSeptember 24, 2021 at 7:07 AM

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

    ReplyDelete
  106. UnknownJanuary 26, 2022 at 11:01 PM

    Create function fnComputeAge (@DOB Datetime)
    returns nvarchar(50)
    as
    begin

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


    select @tempdate = @DOB

    select @years = DATEDIFF(YEAR, @tempdate, GETDATE())-
    case
    when (MONTH(@DOB)>MONTH(GETDATE())) or
    (MONTH(@DOB)=MONTH(GETDATE()) and DAY(@DOB)> DAY(GETDATE()))
    then 1 else 0
    end
    select @tempdate = DATEADD(YEAR, @years, @tempdate)
    select @month = DATEDIFF(MONTH, @tempdate, GETDATE())-
    case
    when DAY(@DOB)>DAY(GETDATE())
    then 1 else 0
    end
    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
    end



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

    ReplyDelete
    Replies
    1. AnonymousDecember 17, 2023 at 9:08 AM

      CREATE FUNCTION fnComputeAge (@DOB DATETIME)
      RETURNS NVARCHAR(50)
      AS
      BEGIN
      DECLARE @tempdate DATETIME, @years INT, @month INT, @days INT

      SELECT @tempdate = @DOB

      SELECT @years = DATEDIFF(YEAR, @tempdate, GETDATE()) -
      CASE
      WHEN (MONTH(@DOB) > MONTH(GETDATE()) OR
      (MONTH(@DOB) = MONTH(GETDATE()) AND DAY(@DOB) > DAY(GETDATE())))
      THEN 1
      ELSE 0
      END

      SELECT @tempdate = DATEADD(YEAR, @years, @tempdate)

      SELECT @month = DATEDIFF(MONTH, @tempdate, GETDATE()) -
      CASE
      WHEN DAY(@DOB) > DAY(GETDATE())
      THEN 1
      ELSE 0
      END

      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(5)) + ' Days old'

      -- Handle the case where the birthdate is exactly the same as the current date
      IF @years <= 0 AND @month <= 0 AND @days <= 0
      SET @Age = 'Born Today'

      RETURN @Age
      END

      Delete
  107. AnonymousMay 10, 2022 at 6:56 PM

    Hi ,

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

    ReplyDelete

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

Subscribe to: Posts (Atom)