SQL Server Tutorial for Beginners | SQL Tutorial for Beginners

SQL Server Tutorial for Beginners

If you can, let's support Kud Venkat to gift education to those who cannot afford
https://www.pragimtech.com/support-us/

The image version of the slides are free. The images may appear blurred, but if you click on one of the images they get enlarged and will be crystal clear. You can then use left and right arrows on the keyboard to navigate from one slide to another. Use Google chrome browser for best experience.

If you want to download all the PPTs, you can order them from the following link.
https://www.pragimtech.com/downloadcourses/download-all-slides/

Click here to watch the complete SQL course on YouTube

Subscribe to receive an email, when new videos are uploaded

Download and Install SQL Server 2019 Developer Edition from the following link.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads

Download and Install (SQL Server Management Studio) SSMS from the following link
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?redirectedfrom=MSDN&view=sql-server-ver15

How to install SQL Server & SQL Server Management Studio (SSMS)

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

SQL Server Performance Tuning and Query Optimization

  1. Text | How is data stored in SQL database
  2. Text | How do SQL Indexes Work
  3. Text | What is heap table

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

SQL Server Tutorial for Beginners | SQL Tutorial for Beginners

Average Rating

5

25 ratings

5 1

Details

5 Stars
25
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0
  • Zewdie Abate
    7 days ago★★★★★
    5 5 1

    organization

    It is well organized. I am just starting to learn using this page tutorial but I believe it is an excellent resouce.

  • siva kumar
    2 months ago★★★★★
    5 5 1

    SQL

    Excellent material & approach towards the subject thanks a lot venkat, ji

  • Sushil
    3 months ago★★★★★
    5 5 1

    sushsree

    Amazing content. Thank you Venkat. Appreciate your effort to create such a good content.

  • Aman Arora
    3 months ago★★★★★
    5 5 1

    World Best Course

    This series is amazing. I would of still pay if I had to pay for it. The quality of content is really up there. Thank you so much for uploading these, The quality of the content speaks for itself and I can't imagine the time you put in behind the scenes to put this together.

  • Haider Ali
    4 months ago★★★★★
    5 5 1

    SQL Course

    Best course for the beginners because your teaching level is too good to understand.

  • Pujithreddy
    5 months ago★★★★★
    5 5 1

    Sql

    I love your teaching approach

  • Vinit
    6 months ago★★★★★
    5 5 1

    Just Great

    you people are awesome and I shall be always thankful.

  • Sushant
    7 months ago★★★★★
    5 5 1

    The Unstoppable

    Venkat sir you are really unstoppable. Very difficult to find such course on internet.Thanks a lot sir...

  • Koteswara Rao Ambati
    8 months ago★★★★★
    5 5 1

    Architect

    Simply Awesome!!! Amazing Job by Venkat. I strongly recommend these videos ( Venkat's VIdeo Tutorials ) to any one who is willing to learn SQL and other areas easily. Great Job ny Venkat. No words.. I give 10 stars... Super.

  • Marjuke Rahman
    8 months ago★★★★★
    5 5 1

    Excellent

    Life changing course. Thanks a lot.

  • Mike
    9 months ago★★★★★
    5 5 1

    Really informative

    well laid out and extremely helpful

  • Ashar Hussain
    9 months ago★★★★★
    5 5 1

    Excellent Teacher

    I Have Learned Alot From You Including Dot Net And SQL Jquery javascript Thank you so much. this course help me to learn all db concept. Thank You.

  • Trupti
    10 months ago★★★★★
    5 5 1

    SQL

    Thank you very much! You are giving a beginner like us a platform to know about SQL Server before hand, and I'm really grateful for that! It is really helpful!

  • Neelam
    12 months ago★★★★★
    5 5 1

    Learn SQL

    I found this course on Youtube and for free had shocked me. The course curriculum covers major topics and Venkat is an amazing teacher. The course follows proper pace along with depth of the topic with example. Also, good amount of code is taught. Anyone can learn SQL here. Thank you, Venkat.

  • Muhammad Yasir
    12 months ago★★★★★
    5 5 1

    Superb Teacher

    i do not have words to express my feelings i just wanted to say you are on my TOP list youtuber who has extraordinary concept and knowledge..

  • Sandipan Choudhury
    12 months ago★★★★★
    5 5 1

    Excellent tutorials

    I really like this SQL course.Very good explanation.This is very helpful for us.

  • rekha
    1 year ago★★★★★
    5 5 1

    Good place to learn

    The tutor is teaching concepts in an easy and understandable way. happy to found this site. Thanks to all.

  • Hamna M
    1 year ago★★★★★
    5 5 1

    Must Watch Videos for SQL

    Mr.Venkat is truly an amazing teacher. whoever needs to learn SQL I will surely recommend this. You found the right place to learn from scratches. I learned a lot from here . Thanks

  • Jaymin Karthiya
    1 year ago★★★★★
    5 5 1

    An Amazing Course

    Thanks for Sharing, Easy to Understand, for Every Platform like if you are reader, Learning by video or by slides it's free.

  • Hossam Alaaeldein
    1 year ago★★★★★
    5 5 1

    Excellence

    I'd really like to thank Mr. Venkat and Mr. Mohammad Arafa for their great effort to explain SQL for people who want to start a career in the data business, even if you think you're good at SQL, you would still have new things to learn here

  • Justin A
    1 year ago★★★★★
    5 5 1

    Venkat is an amazing teacher!

    What an amazing teacher! Thank you so much for breaking down these concepts for us! :)

  • Anonymous
    2 years ago★★★★★
    5 5 1
  • Rupesh kumar
    2 years ago★★★★★
    5 5 1

    SQL

    Your explanation is really good and would like to see more videos

  • Luigi Zambetti
    2 years ago★★★★★
    5 5 1

    Invaluable

    My primary source of learning on SQL Server, also for preparing the exam 70-761. Great course Venkat.

  • Lesley Whitehouse
    2 years ago★★★★★
    5 5 1

    SQL Courses

    I am bowled over and constantly referring to Pragim YouTube videos as they are so clear and amazingly perfect in the way they are produced at a perfect pace and with clear and definitive examples on SSMS and accompanying integrated notes. Don't know how I would manage without this source of learning and its FREE!, which is great and so endearingly modest.

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.