SQL Basics
-
01 SQL Server Basics Part 01 (48:26)
-
02 SQL Server Basics Part 02 (60:29)
-
03 SQL Basics Demo Part 03 (55:55)
-
04 Table design - Part 2 (57:28)
-
05.SQL Basics-Table design - Part 3 - datatypes and Keys (57:16)
-
06.Table design - Part 4 - Implement Constraints Class on June 3rd 2024 (67:17)
-
07.Table design - Part 5 - DDL Class on June 6th 2024 (63:20)
-
Code File - DDL
-
Exercise Bank Case Study
-
08.Class 6 - DDL Constraints and Table Class on June 5th 2024 (59:32)
-
09.DDL DML and query introduction Class on June 6th 2024 (66:03)
-
DDLDML2
-
10.query Select clause Class on June 7th 2024 (66:12)
-
Query Exercise - Class 8
-
11.query where clause Class on June 10 th 2024 (62:52)
-
Query Exercise - Class 9
-
12.query where clause DateTime Functions Class on June 11th 2024 (69:17)
-
Query Exercise - Class 10
-
13.query DateTime Functions, Order and grouping Class on June 12th 2024 (71:11)
-
Query Exercise - Class 11
-
14.Query grouping having order by intro to windowing function Class on June 13th 2024 (65:52)
-
Query Exercise - Class 12
-
15.Windowing function part 2 Class on June 14th 2024 (95:45)
-
Query Exercise - Modified Class 12 & Class 13
-
16.SQL Installation and Data Base attachments (68:30)
-
17.Joins Class on June 19th 2024 (63:16)
-
Source file
-
18.Query Exercise - Class 17 Subquery in Select clause, From clause and where clause June 24th 2024 (64:36)
-
19.Query Exercise - Class 18 Subquery in where clause and correlated subquery June 25th 2024 (1:30)
-
20.Query Exercise - Class 19 Query recollection and exercises Class on June 26th 2024 (61:34)
-
Query Exercise - Class 19 Query recollection and exercises
-
21.Query Exercise - Class 20 Stored Procedure Part 1 Class on June 27th 2024 (61:15)
-
22.Query Exercise - Class 21 Stored Procedure Part 2 Class on June 28th 2024 (69:12)
-
23.Query Exercise - Class 22 Stored Procedure Part 3 Class on July 2nd 2024 (57:25)
-
Query Exercise - Class 22 Stored Procedure Part 3
-
24.Query Exercise - Class 23 Cursor Part 1 Class on July 3rd 2024 (64:54)
-
Query Exercise - Class 23 Cursor Part 1
-
24.Query Exercise - Class 24 Cursor Part 2 Class on July 4th 2024 (54:24)
-
Query Exercise - Class 24 Cursor Part 2
-
25.Query Exercise - Class 25 Cursor Part 3 and Functions Intro Class on June 5th 2024 (62:01)
-
26.Query Exercise - Class 26 Functions and Triggers Intro Class on July 8th 2024 (53:57)
-
Query Exercise - Class 26 Functions and Triggers Introduction
-
27.Basic SQL- Class 27 Triggers - Class 2 Class on July 9th 2024 (60:38)
-
Query Exercise - Modified Class 12 & Class 13
-
28.Basic SQL- Class 28 Triggers - Class 3 Class on July 10th 2024 (69:08)
-
29.Basic SQL- Class 28 Triggers - Class 3
-
Basic 30.SQL- Class 29 & 30 Views Recollection of entire course Class on July 12th 2024 (44:01)
-
Basic SQL- Class 29 & 30 Views and Course recap
