SQL BASICS
-
SQL Basics Demo Part 01 on Aug 20th 2024.mp4 (49:15)
-
SQL Basics Demo Part 02.mp4 (47:19)
-
03.Recap From demo and ERModelling - Part1 Class on Aug 26th 2024 (60:04)
-
04.Recap ERModelling - Part2 Class on Aug 27th 2024. (56:50)
-
05.ERModelling - Part 3 and Normalization Class on Aug 28th 2024 (53:05)
-
06.ERModelling recap- Part 4 and Normalization Part 2 Class on Aug 29th 2024 (59:15)
-
10.Class 5 - Normalization Part 3 Denormalization Class on Aug 30th 2024 (68:53)
-
11.Class 6 Denormalization and Logical SQL Server Architecture (61:48)
-
12.DB design
-
13.Normalization excersices
-
14. Class 7 Logical SQL Server Architecture - part 2 and DDL (59:48)
-
15.Class 8 Logical SQL Server Architecture - part 3 and DDL (57:52)
-
16.Class 9 Logical SQL Server Architecture - part 4 and DDL (63:06)
-
17.Class 10 DDL For database (69:08)
-
18.Class 11 Table design Part 1 (66:15)
-
19.Class 12 Table design Part 2 (67:01)
-
20.Class 13 Table design Part 3 (72:32)
-
21.Class 14 Table design Part 4. (70:23)
-
22.Class 15 Table design Part 5 (71:46)
-
23.Class 16 Table design Part 6 (60:50)
-
24.Class 17: Table design Part 7 and DML part 1 (57:58)
-
25.Class 18 DML Part 2 and query intro (62:53)
-
26.Class 19 Query Intro (63:27)
-
27.Class 20 Query Part 2 (69:57)
-
Query Day -1 21-09-2024
-
28.Class 21 Query Part 3 (65:04)
-
Query Day 2 23-09-2024
-
29.Class on Sept 25th 2024 (65:04)
-
30.Class on Sept 27th 2024 (66:13)
-
31.Class 23 Query Part 5 (67:59)
-
Class 23 Query Part 5
-
32.Class 24 -DDL Table Class on Sept 30th 2024 (69:38)
-
33.Class 25 -DDL Table Part 2 Class on Oct 1st 2024 (66:49)
-
34.Class 26 -Query Grouping Class on Oct 3rd 2024 (64:48)
-
Class 26 Group by Clause - 03-10-2024
-
35.Class 27 -Query Grouping part 2 Class on October 4th 2024 (70:07)
-
Class 27 Group by Clause - 04-10-2024
-
36.Class 28 -Query Grouping part 3 (69:42)
-
Class 28 Group by Clause - 05-10-2024
-
Class 29. Class on October 10th 2024 (62:51)
-
Class 29 Group by Clause having cube rollup - 10-10-2024
-
Class 30 -Query Joins Part 1
-
Class 31 -Query Joins Part 2 (71:07)
-
Class 31 Join Intro - 12-10-2024
-
Class 32 -Query Outer Joins Part 3. (21:10)
-
Class 32 -Joint Intro
-
Class 33 -Query Joins Part 4 (60:36)
-
Class 33 Join Intro - 18-10-2024
-
Class 34 -Query Full Outer and Self Join Part 5 (61:05)
-
Class 34 Join Intro - 19-10-2024
-
Class 35 -Subquery Part 1 (70:40)
-
Class 36 -Subquery Part 2 (59:47)
-
Class 36 SubQuery -22-10-2024
-
Class 37 -Subquery Part 3 (65:44)
-
Class 37 Sub Query -24-10-2024
-
Class 38 -Subquery Part 4 (66:43)
-
Class 38 SubQuery -25-10-2024
-
Class 39 -Subquery Part 5 Class on October 28th 2024 (62:21)
-
Class 39 Sub Query -28-10-2024
-
Class 40 -Subquery Part 6 (1:13)
-
Class 40 -Subquery Part 6
-
Class 41 -Subquery Part 7 (73:52)
-
Class 41 Sub Query - 05-11-2024
-
Class 42 -Subquery Part 8 and Intro SP (105:08)
-
Class 42 SubQuery - 07-11-2024
-
Class 43 - SP class 2 (65:28)
-
Class 43 SubQuery - 08-11-2024
-
Class 44 - SP class 3 (67:33)
-
Class 44 SubQuery - 09-11-2024
-
Class 45 - SP class 3 (67:33)
-
Class 45 SubQuery - 11-11-2024
-
Class 46 - SP class 4 (63:10)
-
Class 46 SP - 12-11-2024
-
Class 47 - SP Class 5 (59:14)
-
Class 48 - SP Class 6 (65:58)
-
Class 49 - SP Class 7 (69:07)
-
Class 50 - SP Class 8 (61:42)
-
Class 50 SP - 18-11-2024
-
Class 51 - SP Class 9-Cursor (62:52)
-
Class 52 -Cursor introduction (69:01)
-
Class 52 - Cursor File
-
Class 52 - Stored Procedures
-
Class 53 -Cursor Part2 (61:56)
-
Class 53 - Cursor File
-
Class 53 - Static Cursor File
-
Class 54 -Cursor Part3 (63:13)
-
Class 54 - Cursor File
-
Class 55 - Cursor Part 4 (62:11)
-
Class 55 - Cursor file
-
Class 56 - Function Part1 (63:12)
-
Class 56 - Function file
-
Class 57 - Function Part2 (58:40)
-
Class 57 Functions File
-
Class 58 - Function Part 3 (52:06)
-
Class 58 - Triggers
-
Class 59 -Triggers Part1 (41:04)
-
Class 59 - Functions File
-
Class 60 - Triggers Part3 (59:49)
-
Class 60 Functions File
-
Class 61 - Triggers Part4 (65:07)
-
Class 61 Functions File
-
Class 62 - Triggers Part5 (62:56)
-
Class 63 - Triggers Part6 (61:06)
-
Class 63 - Triggers File
-
Class 64 -Views Part1 (64:54)
-
Class 64 - Views File
-
Class 65 - Views Part2 (65:20)
-
Class 65 - Views File
-
Class 66 - Views Part3 (58:48)
-
Class 66 - Views File
-
Class 67 - Window Function Part1 (64:11)
-
Class 67 - Views File
-
Class 68 -WindowFunction part 2 (58:06)
-
Class 68 Views- 21-12-2024
