About This Course | ProgrammingAdvices

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)

About This Course

Complete and Continue

Discussion

93 comments