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)
- Text | Slides | Connecting to SQL Server
- Text | Slides | Creating, altering and dropping a database
- Text | Slides | Creating and working with tables
- Text | Slides | Default Constraint
- Text | Slides | Cascading referential integrity
- Text | Slides | Check Constraint
- Text | Slides | Identity column
- Text | Slides | Get last generated id in sql server
- Text | Slides | Unique key constraint in SQL Server
- Text | Slides | SQL Select statement
- Text | Slides | Group By in SQL Server
- Text | Slides | Basic Joins
- Text | Slides | Advanced Joins
- Text | Slides | Self join
- Text | Slides | Different ways to replace NULL
- Text | Slides | Coalesce function
- Text | Slides | Union and Union All
- Text | Slides | Stored Procedures
- Text | Slides | Stored Procedures with output parameters
- Text | Slides | Difference between output parameters and return values
- Text | Slides | Advantages of stored procedures
- Text | Slides | Built in string functions
- Text | Slides | Left, Reight, Charindex and Substring functions
- Text | Slides | Replicate, Space, Patindex, Replace and Stuff functions
- Text | Slides | DateTime functions
- Text | Slides | IsDate, Day, Month, Year and DateName functions
- Text | Slides | DatePart, DateAdd and DateDiff functions
- Text | Slides | Convert and Cast functions
- Text | Slides | Mathematical functions
- Text | Slides | Scalar User Defined functions
- Text | Slides | Inline Table Valued functions
- Text | Slides | Multi-Statement Table Valued functions
- Text | Slides | Important concepts related to functions in sql server
- Text | Slides | Temporary tables
- Text | Slides | Indexes
- Text | Slides | Clustered and NonClustered Indexes
- Text | Slides | Unique and Non-Unique Indexes
- Text | Slides | Advantages and disadvantages of indexes
- Text | Slides | Views
- Text | Slides | Updateable Views
- Text | Slides | Indexed Views
- Text | Slides | View Limitations
- Text | Slides | DML Triggers
- Text | Slides | DML After Update Trigger
- Text | Slides | Instead of insert trigger
- Text | Slides | Instead of update trigger
- Text | Slides | Instead of delete trigger
- Text | Slides | Derived table and CTE's
- Text | Slides | Common Table Expressions
- Text | Slides | Updatable CTE
- Text | Slides | Recursive CTE
- Text | Slides | Normalization & First Normal Form
- Text | Slides | 2NF and 3NF
- Text | Slides | Pivot Operator
- Text | Slides | Error handling in SQL Server 2000
- Text | Slides | Error handling in SQL Server 2005 and later versions
- Text | Slides | Transactions in SQL Server
- Text | Slides | Transaction ACID Tests
- Text | Slides | Subqueries in sql
- Text | Slides | Correlated subquery
- Text | Slides | Creating a large table with random data for performance testing
- Text | Slides | What to choose for performance - SubQuery or Joins
- Text | Slides | Cursors in sql server
- Text | Slides | Replacing cursors using joins
- Text | Slides | List all tables in a sql server database using a query
- Text | Slides | Writing re-runnable sql server scripts
- Text | Slides | Alter database table columns without dropping table
- Text | Slides | Optional parameters in sql server stored procedures
- Text | Slides | Merge in SQL Server
- Text | Slides | SQL Server concurrent transactions
- Text | Slides | SQL Server dirty read example
- Text | Slides | SQL Server lost update problem
- Text | Slides | Non repeatable read example in sql server
- Text | Slides | Phantom reads example in sql server
- Text | Slides | Snapshot isolation level in sql server
- Text | Slides | Read committed snapshot isolation level in sql server
- Text | Slides | Difference between snapshot isolation and read committed snapshot
- Text | Slides | SQL Server deadlock example
- Text | Slides | SQL Server deadlock victim selection
- Text | Slides | Logging deadlocks in sql server
- Text | Slides | SQL Server deadlock analysis and prevention
- Text | Slides | Capturing deadlocks in sql profiler
- Text | Slides | SQL Server deadlock error handling
- Text | Slides | Handling deadlocks in ado.net
- Text | Slides | Retry logic for deadlock exceptions
- Text | Slides | How to find blocking queries in sql server
- Text | Slides | SQL Server except operator
- Text | Slides | Difference between except and not in sql server
- Text | Slides | Intersect operator in sql server
- Text | Slides | Difference between union intersect and except in sql server
- Text | Slides | Cross apply and outer apply in sql server
- Text | Slides | DDL Triggers in sql server
- Text | Slides | Server-scoped ddl triggers
- Text | Slides | SQL Server trigger execution order
- Text | Slides | Audit table changes in sql server
- Text | Slides | Logon triggers in sql server
- Text | Slides | Select into in sql server
- Text | Slides | Difference between where and having in sql server
- Text | Slides | Table valued parameters in SQL Server
- Text | Slides | Send datatable as parameter to stored procedure
- Text | Slides | Grouping Sets in SQL Server
- Text | Slides | Rollup in SQL Server
- Text | Slides | Cube in SQL Server
- Text | Slides | Difference between cube and rollup in SQL Server
- Text | Slides | Grouping function in SQL Server
- Text | Slides | GROUPING_ID function in SQL Server
- Text | Slides | Debugging sql server stored procedures
- Text | Slides | Over clause in SQL Server
- Text | Slides | Row_Number function in SQL Server
- Text | Slides | Rank and Dense_Rank in SQL Server
- Text | Slides | Difference between rank dense_rank and row_number in SQL
- Text | Slides | Calculate running total in SQL Server 2012
- Text | Slides | NTILE function in SQL Server
- Text | Slides | Lead and Lag functions in SQL Server 2012
- Text | Slides | FIRST_VALUE function in SQL Server
- Text | Slides | Window functions in SQL Server
- Text | Slides | Difference between rows and range
- Text | Slides | LAST_VALUE function in SQL Server
- Text | Slides | UNPIVOT in SQL Server
- Text | Slides | Reverse PIVOT table in SQL Server
- Text | Slides | Choose function in SQL Server
- Text | Slides | IIF function in SQL Server
- Text | Slides | TRY_PARSE function in SQL Server 2012
- Text | Slides | TRY_CONVERT function in SQL Server 2012
- Text | Slides | EOMONTH function in SQL Server 2012
- Text | Slides | DATEFROMPARTS function
- Text | Slides | Difference between DateTime and SmallDateTime in SQL Server
- Text | Slides | DateTime2FromParts function in SQL Server 2012
- Text | Slides | Difference between DateTime and DateTime2 in SQL Server
- Text | Slides | Offset fetch next in SQL Server 2012
- Text | Slides | Identifying object dependencies in SQL Server
- Text | Slides | sys.dm_sql_referencing_entities in SQL Server
- Text | Slides | sp_depends in SQL Server
- Text | Slides | Sequence object in SQL Server 2012
- Text | Slides | Difference between sequence and identity in SQL Server
- Text | Slides | Guid in SQL Server
- Text | Slides | How to check GUID is null or empty in SQL Server
- Text | Slides | Dynamic SQL in SQL Server
- Text | Slides | Implement search web page using ASP.NET and Stored Procedure
- Text | Slides | Implement search web page using ASP.NET and Dynamic SQL
- Text | Slides | Prevent sql injection with dynamic sql
- Text | Slides | Dynamic SQL in Stored Procedure
- Text | Slides | Sql server query plan cache
- Text | Slides | exec vs sp_executesql in sql server
- Text | Slides | Dynamic sql table name variable
- Text | Slides | Quotename function in SQL Server
- Text | Slides | Dynamic SQL vs Stored Procedure
- Text | Slides | Dynamic sql output parameter
- Text | Slides | Temp tables in dynamic sql
SQL Server Performance Tuning and Query Optimization
About Instructor
Reviews
Details
-
Muhammad2 months ago
Sql Server
The tutor is teaching concepts in an easy and understandable way. happy to found this site. Thanks to all.
-
Edijs3 months ago
Perfect !
Perfect !
-
Altay Myrzagaliyev3 months ago
very useful
Very interesting and useful. thank u so much
-
Azadeh3 months ago
SQL server installation
I installed SQL server successfully with guide line provided by you which is incredible and really user friendly. And now I would like to follow the training courses , for sure they will be really useful. Thank you!
-
Ashish5 months ago
Great Course
Great content. Best course so far to learn all the concepts of SQL. I am almost finished with it. Can you please tell how to get a certification?
-
Vinod Kumar Verma9 months ago
SQl Courses
Your explanation is really very good and I would like to see more videos about SQL Server.
-
Zewdie Abate10 months ago
organization
It is well organized. I am just starting to learn using this page tutorial but I believe it is an excellent resouce.
-
siva kumar12 months ago
SQL
Excellent material & approach towards the subject thanks a lot venkat, ji
-
Sushil1 year ago
sushsree
Amazing content. Thank you Venkat. Appreciate your effort to create such a good content.
-
Aman Arora1 year ago
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 Ali1 year ago
SQL Course
Best course for the beginners because your teaching level is too good to understand.
-
Pujithreddy1 year ago
Sql
I love your teaching approach
-
Vinit1 year ago
Just Great
you people are awesome and I shall be always thankful.
-
Sushant1 year ago
The Unstoppable
Venkat sir you are really unstoppable. Very difficult to find such course on internet.Thanks a lot sir...
-
Koteswara Rao Ambati1 year ago
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 Rahman1 year ago
Excellent
Life changing course. Thanks a lot.
-
Mike2 years ago
Really informative
well laid out and extremely helpful
-
Ashar Hussain2 years ago
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.
-
Trupti2 years ago
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!
-
Neelam2 years ago
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 Yasir2 years ago
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 Choudhury2 years ago
Excellent tutorials
I really like this SQL course.Very good explanation.This is very helpful for us.
-
rekha2 years ago
Good place to learn
The tutor is teaching concepts in an easy and understandable way. happy to found this site. Thanks to all.
-
Hamna M2 years ago
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 Karthiya2 years ago
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 Alaaeldein2 years ago
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 A2 years ago
Venkat is an amazing teacher!
What an amazing teacher! Thank you so much for breaking down these concepts for us! :)
-
Anonymous2 years ago
-
Rupesh kumar2 years ago
SQL
Your explanation is really good and would like to see more videos
-
Luigi Zambetti3 years ago
Invaluable
My primary source of learning on SQL Server, also for preparing the exam 70-761. Great course Venkat.
-
Lesley Whitehouse3 years ago
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.