Learn MS SQL Server Advanced Concepts

Lectures : 13 | Video : 1.9 hours | Includes : Lifetime access

Course Summary

Hi, if you are done with Learn MS SQL Server From Scratch Free Course then this is the right course for you. In this course we will start from understand how to write different kinds of stored procedures and user defined function. Then we will go for writing sub queries which includes scalar, multi valued and correlated sub queries.

Moving ahead we see the programming logic in query writing using T-SQL and understand how to write conditional statements in your large complex stored procedures. And finally we will try to understand the advanced concepts like views, scope identity function, transactions and triggers.

So, I ensure you that you will enjoy each and every minute of the videos by learning something new.

Course Curriculum

Section 1 : Data Manipulation Language - Stored Procedures And Functions
4 Lessons
- Lecture 1 : Creating Stored Procedures With No Input And No Output Params
  Preview
- Lecture 2 : Creating Stored Procedures With Input And No Output Params
  Preview
- Lecture 3 : Creating Stored Procedures With Input And Output Params
  Preview
- Lecture 4 : Creating User Defined Functions
  Preview
Section 2 : Subqueries
4 Lessons
- Lecture 5 : Scalar SubQueries
  Start
- Lecture 6 : MultiValued SubQueries
  Start
- Lecture 7 : EXISTS and not EXISTS
  Start
- Lecture 8 : Correalated SubQueries
  Start
Section 3 : Advanced Data Manuplation And Control Structures
5 Lessons
- Lecture 9 : Delete Vs Truncate
  Start
- Lecture 10 : OUTPUT Clause
  Start
- Lecture 11 : IIF Function
  Start
- Lecture 12 : Case When
  Start
- Lecture 13 : If_Else
  Start
Section 4 : Advanced Operations
5 Lessons
- Lecture 14 : Views
  Start
- Lecture 15 : Slowly changing Dimensions
  Start
- Lecture 16 : Scope Identity Functions
  Start
- Lecture 17 : Transactions
  Start
- Lecture 18 : Triggers
  Start

Manzoor Ahmed Mohammed

Manzoor is a Microsoft Certified Trainer who has been working on MS .Net technologies for more than a decade. Apart from development he is also passionate about delivering training on various MS .Net technologies and he has 10+ years of experience as a software development teacher. He writes articles for code-project as well. His YouTube channel has 1 million hits. He is the founder of ManzoorTheTrainer portal.

"I focus on simplifying, complex concepts..." - ManzoorTheTrainer

Course Summary

Course Curriculum

Section 1 : Data Manipulation Language - Stored Procedures And Functions

Section 2 : Subqueries

Section 3 : Advanced Data Manuplation And Control Structures

Section 4 : Advanced Operations

Manzoor Ahmed Mohammed

Course Pricing

Paid Course