Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced SQL
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
Teach online with
27.Advanced SQL(Recap transaction) Class on Aug 4th,2023
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock