SQL server query and stored procedure.
-
01.SQL server query and stored procedure. (76:22)
-
02.SQL server query and stored procedure. Class on Dec'02nd,2023 (64:11)
-
03.SQL server query and stored procedure. Class on Dec'03rd,2023 (51:44)
-
04.SQL Performance Class on Dec'16th,2023 (128:00)
-
05.Basic SQL Training part 4 Class on Dec'18th 2023 (117:18)
-
05.Basic SQL Training part 4
-
06.Basic SQL Training part 6 Class on Dec 25th 2023 (125:26)
-
06.Basic SQL Training part 6
-
07.Basic Query Part 7 (114:22)
-
07.Basic Query Part 7
-
08.SQL Training part 8 Class on Dec 31st 2023 (157:23)
-
08.Basic SQL Training part 8
-
09. cte and window functions Class on Jan 7th 2024 (107:33)
-
09.Basic SQL Training part 10
-
10.Basic SQL Training part 11 Class on Jan 7th 2024 (202:40)
-
11.Basic SQL Training part 12 Grouping Options Class on Jan 13th 2024 (143:40)
-
12.Basic SQL Training part 12 Group options
-
13.Basic SQL Training part 13 Stored Procedure Class on Jan 14th 2024 (131:14)
-
13.Basic SQL Training part 13 Stored Procedure
-
14.Basic SQL Training part 14 Pivot and unpivot Error handling Class on Jan 15th 2024 (133:56)
-
15.Basic SQL Training part 14 Pivot and unpivot and Exception Handling
SQL query and development part 2
-
01 Training Phase 2 - Class1 Data Movement Fundamentals (82:06)
-
01 Training Phase 2 - Class1 Data Movement Fundamentals
-
02.Training Phase 2 - Class 2 Data Movement Fundamentals & Macro design Class on Jan 24th 2024 (64:20)
-
03.DB Design
-
03.Training Phase 2 - Class 2 Data Movement Fundamentals & Macro design
-
04.Training Phase 2 - Class 3 Data Movement Fundamentals & Macro design &ERD Class on Jan 25th 2024 (65:39)
-
05.Training Phase 2 - Class 3 Data Movement Fundamentals & Macro design &ERD
-
06.Training Phase 2 - Class 4 Data Movement Fundamentals & Macro design &ERD Class on Jan 30th 2024 (65:38)
-
06.Training Phase 2 - Class 4 Data Movement Fundamentals & Macro design &ERD
-
07.Training Phase 2 - Class 5 Data Movement Fundamentals & Macro design &ERD Class on Feb 4th 2024 (65:06)
-
07.Training Phase 2 - Class 5 Data Movement Fundamentals & Macro design &ERD
-
08.Training Phase 2 - Class 6 Data Movement Fundamentals & Macro design &ERD & Normalization Class on Feb 5th 2024 (59:19)
-
08.Normalization Retail
-
08.Training Phase 2 - Class 6 Data Movement Fundamentals & Macro design &ERD &Normalization
-
09.Training Phase 2 - Class 6 Data Movement Fundamentals & Macro design &ERD & Normalization (76:22)
-
09.Normalization Retail Part 2
-
10.Training Phase 2 - Class 8 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 6th 2024 (62:33)
-
Training Phase 2 - Class 8 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 6th 2024
-
11.Training Phase 2 - Class9 DB Design Class on Feb 7th 2024 (62:23)
-
DB Design Class on Feb 7th 2024
-
Training Phase 2 - Class9 DB Design Class on Feb 7th 2024
-
12.Class 10 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 9th 2024 (50:10)
-
12.Class 10 Data Movement Fundamentals & Macro design &ERD &Normalization
-
13.Class 11 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 11th 2024 (52:33)
-
14.Class 11 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 11th 2024
-
15.Class 12 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 12th 2024 (61:20)
-
15.Training Phase 2 - Class 12 Data Movement Fundamentals & Macro design &ERD &Normalization
-
16.Class 13 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 14th 2024 (62:59)
-
16.Training Phase 2 - Class 13 Data Movement Fundamentals & Macro design &ERD &Normalization
-
17.Class 14 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 16th 2024 (63:23)
-
17.Training Phase 2 - Class 14 Data Movement Fundamentals & Macro design &ERD &Normalization
-
18.Class 15 Data Movement Fundamentals & Macro design &ERD &Normalization Class on Feb 17th 2024 (58:54)
-
18.Training Phase 2 - Class 15 Data Movement Fundamentals & Macro design &ERD &Normalization
-
19.Class 15 Business Integrity, Referential Integrity Class on Feb 20th 2024 (43:35)
-
20.Training Phase 2 - Class 15 Data Movement Fundamentals & Macro design &ERD &Normalization (1)
-
21.Class 16 Primary key unique key Class on Feb 21nd 2024 (62:47)
-
21.Training Phase 2 - Class 16 Primary key unique key
-
22.Class 17 Identity Sequence Class on Feb 23rd 2024 (78:15)
-
23.Training Phase 2 - Class 17 Identity Sequence
-
24.Class 18 - DDL Statement Class on Feb 24th 2024 (71:54)
-
25.Class 19 - DML Insert Update Delete Class on Feb 24th 2024 (68:06)
-
26.Class 20 Merge, Stored Proc Temp , Truncate delete Class on Feb 27th 2024 (58:50)
-
27.Remaining content of the second course
-
28.Phase 2 - Class 20 Merge, Stored Proc Temp
-
29.Class 21 Merge, Stored Proc Temp Class on Feb29th 2024 (65:58)
-
30.Phase 2 - Class 21 Merge, Stored Proc Temp
-
31.stored procedure, temp db stored procedure functions-Class on March 1st 2024 (60:09)
-
32.Class number 24 Functions. No files to upload Class on March 4th 2024 (63:36)
-
33.Class number 25 Inline, MSTVF, String-Class on March 6th 2024 (67:50)
-
34.Functions string maths Class on March 7th 2024 (73:35)
-
35.Functions string maths class on March 7th 2024 (29:44)
-
36.Class on March 7th 2024 (29:44)
-
37.Class on March 7th 1 2024 (18:32)
-
38.Stored Procedurescenarios Class on March 10th 2024 (69:05)
-
39.Cross Apply, Exception handling basic, Cursor introduction Class on March 11th 2024 (61:39)
-
40.Static cursors Class on March 13th 2024 (63:30)
-
41.Views Class on March 18th 2024 (61:00)
-
42.Views - 2 , Transaction intro Class on March 19th 2024 (64:21)
-
43.Transaction - check points Class on March 20th 2024 (64:21)
-
44.Transaction - check points, log file Class on March 21st 2024 (65:47)
-
Transaction - check points, Transaction modes Class on March 22nd 2024 (66:21)
-
45.Transaction - Save point Nested transaction class 2 Class on March 26th 2024 (63:17)
-
46.Class on March 27th 2024 (62:24)
-
47.Class on March 28th 2024 (60:54)
-
48.Class on March 29th 2024 (58:39)
-
49.Class on March 30th,2024 (60:26)
-
50.Class on March 31st,2024 (80:43)
-
Cursor Extension Class on March 16th 2024 (55:49)
Additional Topics
-
Concurrency Date 1st April 2024 (59:46)
-
Concurrency Part 02 Date 7th April 2024 (59:52)
-
Concurrency Date 7th April 2024 (59:52)
-
Concurrency Date 8th April 2024 (63:41)
-
Concurrency Date 9th April 2024 (71:00)
-
Concurrency - Snapshot Isolation Date 10th April 2024 (66:54)
-
Concurrency - Snapshot Isolation part 2 Date 11th April 2024 (70:31)
-
Concurrency - Deadlock Date 13th April 2024 (90:06)
-
Concurrency -Deadlock cylic , Conversion & clatrification Class on April 15th 2024 (65:46)
-
Physical Architecture Class on April 17th 2024 (74:09)
-
Physical Architecture Part 2 Class on April 18th 2024 (68:51)
-
Physical Architecture Part 3 Class on April 19th 2024 (65:43)
-
Physical Architecture Part 4 Class on 20th April 2024 (80:01)
-
Index Class on April 23rd 2024 (74:56)
-
Index filtered and Design considerations Class on April 24th 2024 (65:32)
-
Locks Update Class on April 25th 2024 (71:29)
-
Partition basic Class on April 27th 2024 (73:26)
-
Partition Siding widow, internal tables metadata Class on April 28th 2024 (90:01)
-
Partition Index, internal tables metadata Class on April 29th 2024 (66:37)
Additional Topics May 1st 2024
-
Partition Index, internal tables metadata - Part 2 Class on May 1st 2024 (122:35)
-
SQL Server Internal architecture and Query Execution process Class on May 2nd 2024 (64:31)
-
SQL Server Internal architecture and Query Execution Part 2 Class on May 4th 2024 (84:57)
-
SQL Server Internal architecture and Query Execution Part 3 Class on May 5th 2024 (67:28)
-
Scan Part 1 Class on May 6th 2024 (58:28)
-
Scan Part 2 Class on May 7th 2024 (62:54)
-
Scan Part 3 Class on May 8th 2024 (71:35)
-
Scan Seek Part 4 Class on May 11th 2024 (84:43)
-
Scan Seek Part 5 Class on May 12th 2024 (61:12)
-
Joins Aggregates - Part 6 Class on May 15th 2024 (67:05)
-
Joins Aggregates - Part 7 Class on May 16th 2024 (67:05)
-
Aggregates Hints- Part 8 Class on May 20th 2024 (84:08)
-
Query execution Recollection- Part 9 Class on May21st 2024 (66:59)
-
Query execution Recollection- Part 10 Class on May 22nd 2024 (74:32)
-
Query execution Recollection- Statistics Part 11 Class on May 29th 2024 (65:23)
