Advanced SQL
-
01.Advanced SQL Server Demo 01 On 16th June 2023 (37:32)
-
02.Advanced SQL Class on 19th June 2023 (61:56)
-
03.Advanced SQL Class-CTE Basic revision and recursive CTE on 20th June 2023 (55:23)
-
04.Advanced SQL Class-Recursive CTE and Hierarchy Id data type on 21st June 2023 (60:24)
-
05.Advanced SQL Class HierarchyID on 22nd June 2023 (60:16)
-
06.Advanced SQL-Pivot unpivot Class on 26th June 2023 (61:48)
-
Pivot and Un Pivot Point Document.
-
07.Background of horizontal partitiontioning of data Class on 28th June 2023 (65:12)
-
Hierarchy-ID
-
SQL Server logical architecture
-
08.Advanced SQL-Simple table parition Class on 29th June 2023 (69:06)
-
SQL Server logical architecture
-
Simple Table partition
-
09.Advanced SQL sliding window partition Class on 30th June 2023 (67:36)
-
Sliding window
-
SQL Server logical architecture 30-06-2023
-
10.Advanced SQL Class-Windowing function introduction on 3rd July 2023 (68:52)
-
11.Advanced SQL Class on 4rth July 2023 (59:32)
-
12.Advanced SQL Class on 5th July 2023 (64:44)
-
Windowing function - Part 2
-
13.Advanced SQL Class on 6th July 2023 (58:47)
-
14.Advanced SQL Class on 7th July 2023 (50:25)
-
Error and Exception
-
15.Advanced SQL-Revision and change tracking. Class on 10th July 2023 (63:45)
-
Raiseerror vs Throw
-
Change Tracking
-
Sequence vs Identity
-
16.Advanced SQL Class on July 14th, 2023 (59:16)
-
17.Advanced SQL Class on July 17,2023 (63:58)
-
Temporal table and intro to physical architecture on July 17,2023
-
18.Advanced SQL Class on July 18th ,2023 (67:27)
-
Table Internals
-
19.Advanced Class on July19th,2023 Table Internals 2 and Index Internal (61:39)
-
Table Internals 2 and Index Internal
-
20.Advanced SQL(Physical architecture recap) Class on July 21th ,2023 (55:21)
-
Advanced - SQL- 21-07-2023
-
Internals - Addition 24-07-2023
-
21.Advanced SQL (Internals Recap 2) Class on July 24th ,2023 (53:40)
-
22. Advanced SQL Class on July 25th,2023 (52:22)
-
23.Adanced SQL Class(Recap Index FilestreamIntro) on 26th July,2023 (64:30)
-
AdvancedSQL25-07-2023
-
Recap Index FilestreamIntro 26-07-2023
-
24.Advanced SQL Class(Filestream fileable and other aspects of sql server architecture) on July 27th,2023 (58:40)
-
SQL Server Advanced 27-07-2023
-
25.Advanced SQL Class(25.Recap Filestable an filestream Introduction to transactioning) on July 28th,2023 (58:23)
-
SQL Server Advanced 27-07-2023
-
SQL Server Advanced 28-07-2023
-
26.Advanced SQL(Transaction Types) Class on July 31st,2023 (52:39)
-
27.Advanced SQL(Recap transaction) Class on Aug 4th,2023 (48:16)
-
Advanced sql 04-08-2023
-
28.Advanced SQL(Transaction types) Class on Aug7th,2023 (58:51)
-
Advanced - SQL- 07-08-2023 - Transaction types
-
29.Advanced SQL(concurrency) Class on Aug8th,2023 (53:27)
-
Advanced - SQL- 08-08-2023 - Concurrency
-
30.Advanced SQL Class (Concurrency Isolation levels)on Aug9th,2023 (46:39)
-
Advanced - SQL- 09-08-2023 - Concurrency Isolation levels
-
31.Advanced SQL Class(Concurrency Isolation levels Part 2) on Aug 10th,2023 (40:46)
-
Advanced - SQL- 10-08-2023 - Concurrency Isolation levels Part 2
-
32.Advanced SQL Class (Concurrency Isolation levels Part 3 and Locking)on Aug 11th,2023 (49:56)
-
Advanced - SQL- 11-08-2023 - Concurrency Isolation levels Part 3 and Locking
-
33.Advanced SQL Class( Locking part 2) on Aug 14th,2023 (53:37)
-
34.Advanced SQL Class on Aug17,2023 (58:08)
-
35.Advanced SQL Class(Query Execution Plan Part 1)on Aug18,2023 (53:09)
-
Advanced - SQL- 18-08-2023 - Query Execution Plan Part 1
-
36.Advanced SQL Class(Query Execution Plan part 2) on Aug21st,2023 (51:54)
-
Advanced - SQL- 21-08-2023 - Query Execution Plan Part 2
-
37.Advanced SQL Class(Query Execution Plan Part 3) on Aug 22nd,2023 (45:02)
-
Advanced - SQL- 22-08-2023 - Query Execution Plan Part 3
-
38.Advanced SQL Class(Query Execution Plan Part 4) on Aug 23rd,2023 (55:50)
-
Advanced - SQL- 23-08-2023 - Query Execution Plan Part 4
-
39.Advanced SQL Class(Recap) on Aug 25th,2023 (53:23)
-
Advanced - SQL- 25-08-2023 - Recap
