Support us .Net Basics C# SQL ASP.NET ADO.NET MVC Slides C# Programs Subscribe Buy DVD

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

94 comments:

  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

    ReplyDelete
    Replies
    1. plz... upload sql locks and cursors videos

      Delete
  2. plz upload what is difference between Const and Readonly

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

      Thanks
      Chaitanya.

      Delete
    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

      Delete
    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

      Delete
  3. Hi Venkat,

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

    ReplyDelete
  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

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

    Thanks&Regards,
    Raghu.

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

    ReplyDelete
  7. 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. Thank You Very Much Venkat.Thank you for your assistance

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

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

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

    I love your videos! Excelent job!

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

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

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

    Thanks

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

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

    Thanks

    ReplyDelete
  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?

    Thanks

    Nisha


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

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

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

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

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

    ReplyDelete
  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?

    ReplyDelete
  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?

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

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

    THanks,
    Vicky

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

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

    Thanks

    ReplyDelete
  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

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

    Shayma.ahmad@gmail.com

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

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

    ReplyDelete
  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

    Thanks

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

    ReplyDelete
  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

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

    ReplyDelete
  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

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

    RESPECT... YOU EARNED IT

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

    ReplyDelete
    Replies
    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

      Delete
  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

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

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

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

    ReplyDelete
  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

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

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

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

    ReplyDelete
  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

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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

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

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

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

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

    ReplyDelete
  58. Hi Venkat,

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

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

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

    ReplyDelete
  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
    thanks

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

    ReplyDelete
  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

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

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

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

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

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

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

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

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

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

    Regards,

    Sandani Basha Shaik

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

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

    Regards,
    Rushabh

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

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

    Regards,

    Sandani Basha Shaik

    ReplyDelete
  76. Please explain me this :

    view schema binding,
    view with check option

    Tenx

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

      Delete
  77. This blog awesome and i learn a lot about programming from here.The best thing about this blog is that you doing from beginning to experts level.

    Love from

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

  79. 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. 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
  80. HELLO SIR

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

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

    ReplyDelete
  82. Hiya Venkat,

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

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

If you like this website, please share with your friends on facebook and Google+ and recommend us on google using the g+1 button on the top right hand corner.