Autoplay
Autocomplete
Previous Lesson
Complete and Continue
21 - Database Level2 - Concepts & T-SQL
Important Introduction
About This Course
Telegram Group for This Course
Introduction About T-SQL
Introduction to T-SQL (17:39)
Quiz
Variables in T-SQL
Variables (13:02)
Quiz
Example 1 - Employee Report (9:06)
Example 2 - Monthly Sales Summary Report (6:48)
Example 3 - Employee Attendance Tracking (7:53)
Example 4 - Loyalty points (8:58)
IF Satatement
Simple IF Statement (3:33)
IF...ELSE Statement (1:38)
Nested IF Statements (2:14)
Using IF with Variables and Conditional Assignments (3:16)
Using IF Statement with AND/OR/NOT (4:19)
Error Handling with IF (4:02)
Using IF with EXISTS (3:20)
Best Practices & Summary
Quiz
Case Statement
CASE Statement
Simple CASE as SWITCH (4:43)
Searched CASE (More Flexible) (3:27)
Using CASE in ORDER BY (Custom Sorting) (7:42)
CASE in UPDATE Statements (Conditional Data Modification) (5:49)
Nested Case Statements (6:17)
CASE statement within a GROUP BY (7:23)
Quiz
Loops Statements In T-SQL
WHILE Loops - Example 1 - Simple Counter (2:47)
Example 2: Iterating Over a Table (4:01)
03 Example 3 - Loop with Conditional Exit (2:24)
Example 4 - Nested While Loops - 10 x 10 Multiplication Table (2:35)
Example 5 - 10 x 10 Matrix Multiplication Table (2:15)
Example 6 - BREAK and CONTINUE Statements (3:47)
Important: There is No For Loop or Do While Statement In T-SQL
Quiz
BEGIN...END Blocks
BEGIN...END Blocks in T-SQL
Error Handling
Error Handling in T-SQL - Try .. Catch (4:56)
Quiz 1
Error Functions (2:28)
Quiz 2
THROW Statement (7:02)
Quiz 3
@@ERROR Function (5:07)
Quiz 4
@@ROWCOUNT
@@ROWCOUNT (3:42)
Quiz
Transactions
Introduction to Transactions (10:37)
Example Performing a Bank Transfer (7:59)
Quiz
Variable Tables
Table Variables in T-SQL (8:28)
Example (3:11)
Quiz
Temporary Tables
Introduction to Temporary Tables (5:37)
Example (4:10)
Quiz1
Differences between Temp Table vs Variable Table
Quiz2
Differences between temporary tables and normal (permanent) tables
Quiz3
Stored Procedures
Stored Procedures in T-SQL (12:56)
CREATE: Add a New Person SP. (6:06)
READ: Get All People (2:20)
READ: Get Person By ID way 1 (2:06)
READ: Get Person By ID way 2 (5:02)
UPDATE: Update a Person's Details (1:39)
DELETE: Remove a Person (1:11)
RETURN Statement (3:00)
Drop SP (1:33)
SP_HELPTEXT command. (1:35)
Quiz
Built-In Functions
String Functions (6:39)
Date Functions (6:21)
Aggregate functions (SUM, AVG, COUNT, MIN, MAX) (3:41)
Window Functions:
What is Window Functions? (3:32)
Understanding the ROW_NUMBER() Function in SQL (4:51)
Understanding the RANK() Function in SQL (3:52)
Understanding the Difference Between RANK and DENSE_RANK in SQL (2:34)
Using the RANK() Function with PARTITION BY in SQL (4:09)
Aggregate Functions with Partition (2:28)
Exploring LAG and LEAD Functions Using a Single SQL Query (4:16)
Paging in SQL using OFFSET and FETCH NEXT (10:16)
Quiz
Scalar Functions
Scalar Functions in T-SQL (18:06)
Quiz
Table-Valued Functions
Introduction (7:41)
Quiz 1
Inline Table-Valued Functions (ITVFs) in T-SQL (7:45)
Using Inline Table-Valued Functions with JOIN in T-SQL (3:44)
Quiz 2
Multi-Statement Table-Valued Functions (MTVFs) in T-SQL (8:49)
Quiz 3
Dynamic SQL and SQL Injection Attack
Dynamic SQL (5:57)
SQL injection attack (4:55)
Quiz
Triggers
Introduction to Triggers in T-SQL (8:56)
Quiz
After Triggers
After Insert Triggers in T-SQL (7:54)
Quiz 1
After Update Triggers in T-SQL (7:24)
Quiz 2
After Delete Triggers in T-SQL (5:31)
Quiz 3
Inserted and Deleted Tables in T-SQL Triggers
Quiz 4
Instead of Triggers
Understanding Instead Of Triggers in T-SQL (4:31)
Quiz 1
"Instead Of Delete" Trigger in T-SQL (7:40)
Quiz 2
Instead of Update Trigger in T-SQL (6:39)
Quiz 3
Instead of Delete Trigger in T-SQL (3:34)
Quiz 4
Cursors in T-SQL
Introduction to Cursors in T-SQL (8:14)
Quiz 1
Static Cursors in T-SQL (11:20)
Quiz 2
Dynamic Cursors in T-SQL (5:38)
Quiz 3
Forward-Only Cursors in T-SQL (4:25)
Quiz 4
Scrollable Cursors in T-SQL (6:22)
Quiz 5
CTE
Common Table Expressions (CTEs) in T-SQL (10:17)
Recursive CTE Example 1 (3:21)
Understanding Recursive CTEs for Building Employee Hierarchies (8:20)
Generating a Date Series Using CTE (3:12)
Identifying Duplicate Records Using CTE in T-SQL (3:23)
Ranking Items Using CTE (2:51)
Calculating Average Sales of Top Performing Employees Using CTE (3:03)
Quiz
End Of Course Message
Thank You. (2:58)
Calculating Average Sales of Top Performing Employees Using CTE
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock