SQL Basics
-
00 SQL Basics Demo Part01 (48:12)
-
00 SQL Basics Demo Part02 (46:43)
-
01 SQL Basics - Recap High level design - ER Modelling Part 1 (48:05)
-
02 SQL Basics - ER Modelling Part 2 (54:59)
-
03 SQL Basics - ERM Part 2 and Normalization (46:29)
-
04 SQL Basics - Normalization & Denormalization (48:37)
-
05 SQL Basics - Normalization Recap & Logical Architecture (45:40)
-
06 SQL Basics - SQL Server Logical Architecture Part 2 (65:22)
-
07 SQL Basics - DDL Create database using DDL (51:01)
-
08 SQL Basics - Table Design Part 1 (44:35)
-
09 SQL Basics - Table Design Part 2 (46:41)
-
10 SQL Basics - Table Design Part 3 (44:04)
-
11 SQL Basics - Table Design Part 4 (48:59)
-
12 SQL Basics - Table Design Part 5 (41:23)
-
13 SQL Basics - Table Design Part 6 (48:51)
-
14 SQL Basics - Installation SQL Part1 (50:04)
-
15 SQL Basics - Installation SQL Part2 (53:22)
-
16 SQL Basics - Select Statement (47:36)
-
17 SQL Basics - Select statement where clause and date functions part1 (52:04)
-
18 SQL Basics - Select statement where clause and date functions part2 (45:52)
-
19 SQL Basics - Select statement Group by and having clause part1 (52:45)
-
20 SQL Basics - Select statement Group by and having clause part2 (56:51)
-
21 SQL Basics - Group by with cube and roll up and Join operations (54:32)
-
22 SQL Basics - Join Operations Inner Join Recap and Outer Join (58:19)
-
23 SQL Basics - Self Join Subquery Query Part1 (47:40)
-
24 SQL Basics - Self Join Subquery Query Part2 (48:30)
-
25 SQL Basics - Stored Procedure Part1 (52:09)
-
26 SQL Basics - Stored Procedure Part2 (38:13)
-
27 SQL Basics - Stored Procedure Part3 (38:13)
-
28 SQL Basics - Functions Part1 and Cursors (51:34)
-
29 SQL Basics - Cursor Part2 and Triggers (49:44)
Text Files
-
1 ER Modelling - Part 1
-
1 High level design consideration
-
2 ER Modelling - Part 2 - patty's playschool
-
2 DB Design
-
03 Entity Relationship
-
03 ER Modelling - Part 2 - patty's playschool
-
03 Table conversion
-
04 Normalization Exercises
-
06 Logical architecture
-
07 DDL- Database 15-04-2025
-
08 Table Design Part 1 16-04-2025
-
10 Table Design Part 3
-
11 DDLDML
-
11 Table Design -2 V3
-
15 - DML Query
-
17 Select statement where clause and date functions part1
-
18 SQL Basics - Select statement where clause and date functions part2
-
19 SQL Basics - Select statement Group by and having clause part1
-
20 SQL Basics - Select statement Group by and having clause part2
-
21 SQL Basics - Group by with cube and roll up and Join operations
-
22 SQL Basics - Join Operations Inner Join Recap and Outer Join
-
23 SQL Basics - Self Join Subquery Query Part1
-
24 SQL Basics - Self Join Subquery Query Part2
-
25 SQL Basics - Stored Procedure Part1
-
26 SQL Basics - Stored Procedure Part2
-
27 SQL Basics - Stored Procedure Part3
-
28 SQL Basics - Functions Part1 and Cursors
-
29 SQL Basics - Cursor Part2 and Triggers
