Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Basics May 2024
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
Teach online with
14.Query grouping having order by intro to windowing function Class on June 13th 2024
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock