مهم جدا
يجب ان تكون قد انهيت جميع الكورسات المشار اليها بالاخضر
سيتم تنزيل الدروس تدريجيا بشكل شبه يومي
محتوى الكورس
Important Introduction
Available in
days
days
after you enroll
Introduction About T-SQL
Available in
days
days
after you enroll
Variables in T-SQL
Available in
days
days
after you enroll
IF Satatement
Available in
days
days
after you enroll
Case Statement
Available in
days
days
after you enroll
Loops Statements In T-SQL
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
Error Handling
Available in
days
days
after you enroll
@@ROWCOUNT
Available in
days
days
after you enroll
Transactions
Available in
days
days
after you enroll
Variable Tables
Available in
days
days
after you enroll
Temporary Tables
Available in
days
days
after you enroll
Stored Procedures
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
Window Functions:
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
Table-Valued Functions
Available in
days
days
after you enroll
Dynamic SQL and SQL Injection Attack
Available in
days
days
after you enroll
Triggers
Available in
days
days
after you enroll
After Triggers
Available in
days
days
after you enroll
Instead of Triggers
Available in
days
days
after you enroll
Cursors in T-SQL
Available in
days
days
after you enroll
CTE
Available in
days
days
after you enroll
- 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
Available in
days
days
after you enroll
