Master Advanced Database Design: Patterns & Optimization (2024 Pro)
Focused View
10:37:13
1 -Introduction, Course Overview.mp4
04:53
2 -How to Use Migration Scripts and Navigate Through The Course.mp4
11:20
3 -OnlineStore Database Introduction.mp4
07:11
1 -Installation of SQL Server & SQL Server Management Studio (Windows).mp4
03:56
1 -Advanced Database Design Patterns in Action.pdf
1 -migration scripts.zip
1 - Migration Scripts and Slides.html
1 - Migration Scripts - Dependencies.html
1 -Section Overview.mp4
00:51
2 -Key Types.mp4
02:54
3 -Primary Key Properties.mp4
02:13
4 -Surrogate Key.mp4
05:19
5 -Natural Key.mp4
03:26
6 -Surrogate Kye vs Natural Key - Summary.mp4
00:53
7 -(Script 001) - Primary Key.mp4
07:15
1 -Section Overview.mp4
00:43
2 -Heap.mp4
02:30
3 -Index Basics.mp4
02:14
4 -Nonclustered Index.mp4
06:06
5 -Nonclustered Index Types And Use Cases.mp4
04:13
6 -Clustered Index - Introduction.mp4
02:19
7 -Clustered Index Design.mp4
03:31
8 -Clustered Index On An Integer Column.mp4
01:44
9 -Clustered Index On A GUID Column.mp4
02:22
10 -Clustered Index Type And A Table Size.mp4
02:38
11 -(Script 002 #1) - Clustered Index Key Size Impact.mp4
10:15
12 -(Script 002 #2) - IDENTITY Gaps.mp4
02:32
13 -Nonclustered Primary Keys.mp4
03:22
14 -Data Access Operators.mp4
05:03
15 -Query Patterns.mp4
07:19
16 -(Script 002 #3) - Indexes And Cardinality.mp4
17:50
17 -(Script 002 #4) - Composite Index.mp4
13:29
18 -(Script 002 #5) - Composite Index vs Index With Included Column.mp4
05:55
19 -(Script 002 #6) - Non-sargable queries.mp4
03:19
20 -Nested Loops.mp4
02:56
21 -Merge Join.mp4
01:34
22 -Hash Join.mp4
01:48
23 -(Script 002 #7) - Indexing For JOIN.mp4
11:49
24 -(Script 002 #8) - Indexing For ORDER BY.mp4
02:54
25 -(Script 002 #9) - Indexing For GROUP BY.mp4
11:02
26 -(Script 002 #10) - Indexing For COUNT.mp4
05:47
27 -(Script 002 #11) - Indexing For MIN, MAX, SUM, AVG.mp4
07:12
28 -(Script 002 #12) - Analyzing indexes with DMVs.mp4
04:18
1 -Section Overview.mp4
00:30
2 -Foreign Keys - Introduction.mp4
01:41
3 -Types Of Referenced Tables.mp4
03:29
4 -On Delete, On Update Settings Guidelines.mp4
04:21
5 -(Script 003 #1) Getting Information About Foreign Keys.mp4
04:37
6 -(Script 003 #2) Foreign Key Index And Cascade Delete.mp4
05:19
7 -(Script 003 #3) Foreign Key Index And Join Performance.mp4
04:25
1 -Section Overview.mp4
00:42
2 -Normalization.mp4
02:27
3 -1st Normal Form.mp4
01:18
4 -2nd Normal Form.mp4
01:31
5 -3rd Normal Form.mp4
01:31
6 -Boyce-Codd Normal Form (BCNF).mp4
03:16
7 -4th Normal Form.mp4
02:40
8 -Normalization Mental Model.mp4
03:02
9 -How Far To Normalize.mp4
03:58
10 -(Script 004) Splitting The Customer Table.mp4
06:23
11 -(Script 005 #1) Splitting The Name Column - Problem Definition.mp4
01:55
12 -(Script 005 #2) Splitting The Name Column - Scaffolding code.mp4
12:16
13 -(Script 005 #3) Splitting The Name Column - Data migration.mp4
03:15
1 -Simple Format - Motivation and Implementation.mp4
02:24
2 -(Script 006) Simple Format.mp4
05:03
1 -Lookup Table - Theory.mp4
04:11
2 -(Script 007) Vendor Lookup Table.mp4
04:01
3 -(Script 008) State Lookup Table.mp4
02:44
4 -(Script 009) Order Status Type Lookup Table.mp4
05:07
1 -Associative Table - Theory.mp4
03:39
2 -(Script 010) Associative Table.mp4
05:00
1 -Master-Detail - Theory.mp4
03:25
2 -(Script 011 #1) Master-Detail Implementation.mp4
08:21
3 -(Script 011 #2) Normal Index vs Filtered Index.mp4
03:19
1 -Section Overview.mp4
00:54
2 -History Table - Theory.mp4
03:29
3 -(Script 012 #1) Order Status History Table.mp4
05:10
4 -(Script 012 #2) Event Sourcing.mp4
05:53
5 -(Script 013 #1) Promotion Table.mp4
07:35
6 -(Script 013 #2) Temporal Table.mp4
10:19
1 -Section Overview.mp4
00:41
2 -Horizontal Partitioning - Definition.mp4
02:14
3 -Horizontal Partitioning Types.mp4
02:41
4 -Horizontal Partitioning Pros And Cons.mp4
04:25
5 -Partition Function.mp4
03:03
6 -Partition Scheme.mp4
01:32
7 -Partitioned Table.mp4
01:16
8 -Aligned And Nonaligned Indexes.mp4
03:26
9 -(Script 014 #1) Partitioned Table Creation.mp4
14:41
10 -Merge, Split And Switch Operations.mp4
05:26
11 -(Script 014 #2) Sliding Window.mp4
06:02
12 -(Script 014 #3) How NOT To Merge Partitions.mp4
02:52
13 -(Script 014 #4) Partitioned vs Non-partitioned Table.mp4
06:54
1 -Section Overview.mp4
00:35
2 -Data Page.mp4
03:15
3 -Internal Fragmentation.mp4
01:51
4 -External Fragmentation.mp4
02:58
5 -Page Splits.mp4
02:12
6 -Fragmentation Removal And Prevention.mp4
04:19
7 -(Script 015 #1) Customer Description Table Creation.mp4
06:51
8 -(Script 015 #2) Vertical Partitioning And Query Performance.mp4
12:12
9 -(Script 015 #3) Index Key Size And Fragmentation.mp4
04:15
1 -Section Overview.mp4
00:38
2 -Hierarchical Data - Definition.mp4
00:56
3 -Adjacency List Pattern.mp4
02:26
4 -Closure Table Pattern.mp4
03:34
5 -Nested Sets Pattern.mp4
03:21
6 -Path Enumeration Pattern.mp4
03:27
7 -HierarchyID Type.mp4
03:38
8 -(Script 016 #1) Migration From Adjacency List.mp4
09:32
9 -(Script 016 #2) Hierarchy ID methods.mp4
07:22
10 -(Script 016 #3) Path Enumeration vs HierarchyID.mp4
08:01
11 -(Script 016 #4) HierarchyID Indexes.mp4
07:14
1 -Inheritance Patterns.mp4
03:09
2 -(Script 017) Software Product Table Creation.mp4
05:03
3 -(Script 018) Hardware Product Table Creation.mp4
08:16
1 -Section Overview.mp4
00:38
2 -Unicode And Encoding Selection.mp4
04:41
3 -Collations.mp4
08:33
4 -Schema Design.mp4
06:52
5 -(Script 019 #1) Basic Collation Check.mp4
06:44
6 -(Script 019 #2) Multi-language Data Gotchas.mp4
08:28
7 -(Script 019 #3) Sorting Single-column Multilanguage Data.mp4
06:10
8 -(Script 019 #4) Migration To Multi-languages.mp4
07:04
9 -(Script 019 #5) Changing From VARCHAR To NVARCHAR.mp4
05:23
1 -Soft Delete - Theory.mp4
04:48
2 -(Script 020) Soft Delete.mp4
06:30
1 -Denormalization With JSON - Theory.mp4
04:31
2 -(Script 021) Denormalization With JSON.mp4
09:43
1 -Computed Column - Theory.mp4
04:01
2 -(Script 022) Computed Column.mp4
13:50
1 -Section Overview.mp4
00:57
2 -Use cases.mp4
02:33
3 -Techniques.mp4
04:08
4 -(Script 023#1) Using Stored Procedures.mp4
07:39
5 -(Script 023#2) Using Views.mp4
06:19
6 -(Script 023#3) Dynamic Data Masking.mp4
04:44
7 -(Script 023#4) Column Level Encryption.mp4
06:34
More details
Course Overview
Master professional database design with this comprehensive course covering advanced patterns, optimization techniques, and real-world SQL Server implementations.
What You'll Learn
- Implement advanced indexing strategies for maximum query performance
- Master partitioning techniques for large-scale database management
- Design complex data models including hierarchical and multilingual systems
Who This Is For
- Database architects and developers seeking advanced skills
- SQL Server professionals optimizing enterprise systems
- Full-stack engineers working with complex data structures
Key Benefits
- 60+ hands-on sessions with real-world SQL scripts
- Comprehensive coverage of normalization and denormalization
- Expert techniques for security and performance optimization
Curriculum Highlights
- Advanced Indexing & Partitioning Strategies
- Complex Data Modeling Techniques
- Database Security & Performance Optimization
Focused display
Category
- language english
- Training sessions 134
- duration 10:37:13
- Release Date 2025/05/10
