SQL Basics
-
01 SQL Server Basics Demo Part1 - Sep 26th, 2023 (35:11)
-
02 SQL Server Basics Demo Part2 - Sep 27th, 2023 (35:58)
-
03 SQL Server Basics -database high level design Class on Sept'29th,2023 (51:41)
-
High level design consideration
-
DB Design
-
4.SQL Server Basics Class on Sept29th,2023 (52:41)
-
ER Modelling - Part 1
-
05 SQL Server Basics - ERD part 2 Class on Sept'3rd,2023 (50:26)
-
IPL ERM
-
Entity RelationShip.
-
ER Modelling - Part 2
-
06 SQL Server Basics-ER to table conversion Class on Oct'4th,2023 (54:14)
-
Table conversion
-
07 SQL Server Basics-Normalization Part 2 Class on Oct'5th,2023 (61:05)
-
Normalization Exercises
-
08.SQL Server Basics-SQL Server Logical Architecture Part 1. Class on Oct'6th,2023 (56:14)
-
Logical architecture
-
09 SQL Server Basics- Table design Part - 1 Class on Sept'10th,2023 (55:35)
-
09.Table Design -1
-
10 SQL Server Basics-Table Design - 2 Class on Oct'11th,2023 (45:05)
-
10.Table Design -2
-
11 SQL Server Basics -Table Design - 3 Class on Oct'12,2023 (46:34)
-
11.Table Design -2 V2
-
12 SQL Server Basics-Check constraints 1 Class on Oct'13th,2023 (51:44)
-
12.Table Design -2 V3
-
13 SQL Server Basics - Check Constraint 2 Class on Oct'17th,2023 (53:38)
-
13.IPL_-_Constraints
-
14 SQL Server Basics-T-SQL DDL Part 1 Class on Oct'18th,2023 (53:49)
-
14.Create Database Table using T-SQL
-
15 SQL Server Basics - T-SQL DDL, DML - 1 Class on Oct'19th,2023 (54:34)
-
16 SQL Server Basics-Query Session 1 Class on Oct'20th,2023 (55:07)
-
16.SQL Server Query 1
-
17.SQL Server Basics Class on Oct'29th,2023 (62:31)
-
18. SQL Server Basics-Query class 3 on Oct'31st,2023 (53:59)
-
18.Where Clause Query 3
-
19 SQL Server Basics-Query Where clause 2 (49:21)
-
20.Where Clause Query 4
-
21.SQL Server Class-SQL Query Class 5. on Nov'2nd,2023 (52:34)
-
22.Query Class 5
-
23.SQL Basics -Where Clause Query Class 6. on Nov'11th,2023 (56:08)
-
24.Query class 6
-
25.SQL-Query class 7 Grouping and Having clause. Class on Nov'7th,2023 (49:18)
-
25.Query class 7
-
26.SQL Class-Query Class 8 Aggregate and Joins on Nov'07th,2023 (50:34)
-
26.Query class 8
-
27.SQL Class -Joins class 2 Query class 9 on Nov'09th,2023 (56:37)
-
27.Query class 9
-
28.SQL Server-Query Class 9 Left right Outer Join- Class on Nov'14th,2023 (53:18)
-
28.Query class 10
-
29.SQL-Query Join class 11 on Nov'14th,2023 (51:40)
-
29.Query class 11
-
30.SQL-Self Joins Subquery Class on Nov'16th,2023 (58:57)
-
31.Query Class on Nov'16th,2023
-
32.SQL-Subquery class 13 on Nov'17th,2023 (52:13)
-
33.Query class 13 - subquey
-
34.SQL Basics -query class 14 on Nov'17th,2023 (55:16)
-
34.Query class 14 - subquey
-
35.Query class 15- Revision Class1 Class on November'21st,2023 (37:57)
-
36.Query class 15- Revision Class1 Class on November'21st,2023
-
37.Query class 16- Revision Class 2 Class on Nov'22nd,2023 (66:42)
-
38.Query class 16- Revision Class 2
-
39.Stored Procedure -Class 1 (52:58)
-
40.Stored Procedure -Class 1
-
41.Stored Procedure Class 2 (69:47)
-
41.Create procedure printSales - Class 2
-
42.Stored procedure class 3 Class on Nov'27th,2023 (59:13)
-
42..Create procedure printSales - Class 3
-
43.SQL Cursor class 1 Class on Nov'29th,2023 (64:20)
-
43.Cursor Part -1
-
44.SQL Cursor Part 2. Class on Nov'29th,2023 (58:50)
-
44.Cursor Part -2
-
45.SQL Cursor part 3 Class on Nov'30th,2023 (58:11)
-
45.Cursor Part -3
-
46.triggers class 1 SQL Class on Dec'1st,2023 (42:29)
-
47.Multistatement Table Vlaued function Scenario & triggers
-
48.Trigger part 2. SQL Class on Dec'06th,2023 (56:00)
-
48.Triggers part 2
-
49.trigger Part 3 Class on Dec'12th,2023 (54:09)
-
49.Triggers part 3
-
50.Views. SQL Class on Dec'8th,2023 (59:32)
-
50.Views class
