مهم جدا
يجب ان تكون قد انهيت جميع الكورسات المشار اليها بالاخضر
سيتم تنزيل الدروس تدريجيا بشكل شبه يومي
محتوى الكورس
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
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
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
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
Available in
days
days
after you enroll
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
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
Available in
days
days
after you enroll
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
Available in
days
days
after you enroll