SQL Server Tutorial New
Your Instructor
Renowned Trainer and Author MR SHIVPRASAD KOIRALA and QuestPond make a team of top MVP recognized professionals in the Microsoft domain. Since 2001, we have trained many professionals in technologies like Angular, MSBI, Power BI, Data Science, Python ML, AI OOP, ASP.NET, SQL Server, WCF, WPF, Azure, Architecture and Project Management. QuestPond is famous for online training's, recorded videos and best-selling books.
For offline training in Mumbai https://www.stepbystepschools.net/
Do Visit to enroll all courses https://www.questpond.com/
Course Curriculum
SQL Server Step by Step Videos
Available in
days
days
after you enroll
-
PreviewLab 1: - Basic Fundamentals Database, Tables, rows and columns. (16:14)
-
StartLab 2: - Primary key, foreign key, referential integrity and constraints. (23:46)
-
StartLab 3: - Database Normalization (1st, 2nd and 3rd normal forms). (33:35)
-
StartLab 4: - SQL basics(Select, Insert, Update and Delete) (80:00)
-
StartLab 5: - DDL (Data definition language) Queries. (31:33)
-
StartLab 6: - Transactions, Locks and Isolation level in SQL Server. (68:04)
-
StartLab 7: - ISNULL and Coalesce functions. (6:16)
-
StartLab 8: - Row_Number, Partition, Rank and DenseRank. (10:49)
-
StartLab 9: - Triggers, inserted and deleted tables. (15:39)
-
StartLab 10: - Instead of and after triggers. (15:52)
-
StartLab 11: - Denormalization, OLTP and OLAP. (10:25)
-
StartLab 12: - Understanding Star schema and Snow flake design. (4:31)
-
StartLab 13: - SQL Server 8 kb pages. (18:09)
-
StartLab 14: - Index and performances. (9:55)
-
StartLab 15: - Page Split and indexes. (8:52)
-
StartLab 16:- Clustered vs non-clustered (5:56)
-
StartLab 17: - Stored procedures and their importance. (24:16)
-
StartLab 18: - Change Data Capture. (8:40)
-
StartLab 19: - Explain Columnstore Indexes? (11:22)
-
StartLab 20: - SQL Server agent. (8:40)
-
StartLab 21: - How can we implement Pivot & Unpivot in SQL Server? (10:27)
Frequently Asked Questions
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.