Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Basics Sept'2023
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
Teach online with
45.Cursor Part -3
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock