Zenler Player
Your course is loading. Hang tight.
Learn MS SQL Server Advanced Concepts
Back to curriculum
0% Complete
0% Complete
Lecture 1 : Creating Stored Procedures With No Input And No Output Params
Lecture 2 : Creating Stored Procedures With Input And No Output Params
Lecture 3 : Creating Stored Procedures With Input And Output Params
Lecture 4 : Creating User Defined Functions
Lecture 5 : Scalar SubQueries
Lecture 6 : MultiValued SubQueries
Lecture 7 : EXISTS and not EXISTS
Lecture 8 : Correalated SubQueries
Lecture 9 : Delete Vs Truncate
Lecture 10 : OUTPUT Clause
Lecture 11 : IIF Function
Lecture 12 : Case When
Lecture 13 : If_Else
Lecture 14 : Views
Lecture 15 : Slowly changing Dimensions
Lecture 16 : Scope Identity Functions
Lecture 17 : Transactions
Lecture 18 : Triggers
Section 1 : Data Manipulation Language - Stored Procedures And Functions
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
Lecture 5 : Scalar SubQueries
Lecture 6 : MultiValued SubQueries
Lecture 7 : EXISTS and not EXISTS
Lecture 8 : Correalated SubQueries
Section 3 : Advanced Data Manuplation And Control Structures
Lecture 9 : Delete Vs Truncate
Lecture 10 : OUTPUT Clause
Lecture 11 : IIF Function
Lecture 12 : Case When
Lecture 13 : If_Else
Section 4 : Advanced Operations
Lecture 14 : Views
Lecture 15 : Slowly changing Dimensions
Lecture 16 : Scope Identity Functions
Lecture 17 : Transactions
Lecture 18 : Triggers
×
This is an unpublished lesson. This lesson will not be shown for students unless you set it as Public.
Back to Dashboard
No contents are available in this lesson!
No lessons available !
Back to Dashboard
Lesson contents locked
Enroll to unlock this lesson.
Enroll to unlock
Next Lesson