Advanced Database Design Patterns in Action
- Descrição
- Currículo
- FAQ
- Revisões
In this hands-on course, Advanced Database Design Patterns in Action, we will dive deep into advanced database design techniques that go far beyond the basics. Starting with a basic implementation of an online store database, each lesson will introduce and apply a new design pattern to enhance the database’s speed, data integrity, or scalability. You’ll learn how to implement these advanced techniques in a way that solves real-world problems, enabling you to design highly efficient and robust databases.
What Makes This Course Stand Out:
-
Advanced Patterns Rarely Covered in Other Courses – This course tackles sophisticated concepts, from indexing strategies and horizontal partitioning to handling hierarchical data and multi-language support, preparing you to think and design like a database architect.
-
Hands-On, Project-Based Learning – You’ll build and optimize a realistic database project, seeing the immediate impact of each pattern and technique on performance and reliability.
-
Skills for Any RDBMS – While exercises use SQL Server, the principles you’ll learn are valuable across MySQL, PostgreSQL, Oracle, and other platforms.
Topics Covered Include:
-
Primary Key and Indexing Strategy
-
Foreign Keys and Constraints
-
Normalization (1st to 4th Normal Form)
-
Horizontal and Vertical Partitioning
-
Hierarchical Data Modeling
-
Multi-language Data Handling
-
Soft Deletes, History Tables, Computed Columns
-
Indexed Views, Precalculated Tables, Statistics, and more!
If you’re ready to master patterns that boost performance, scalability, and data integrity, this course will take you to advanced database design mastery.
-
15
Section Overview -
16
Heap
-
17
Index Basics
-
18
Nonclustered Index
-
19
Nonclustered Index Types And Use Cases
-
20
Clustered Index - Introduction
-
21
Clustered Index Design
-
22
Clustered Index On An Integer Column
-
23
Clustered Index On A GUID Column
-
24
Clustered Index Type And A Table Size
A clustered index key size and its impact on a table size.
-
25
(Script 002 #1) - Clustered Index Key Size Impact
A clustered index key size and its impact on nonclustered indexes.
-
26
(Script 002 #2) - IDENTITY Gaps
-
27
Nonclustered Primary Keys
-
28
Data Access Operators
-
29
Query Patterns
-
30
(Script 002 #3) - Indexes And Cardinality
-
31
(Script 002 #4) - Composite Index
-
32
(Script 002 #5) - Composite Index vs Index With Included Column
-
33
(Script 002 #6) - Non-sargable queries
-
34
Nested Loops
-
35
Merge Join
-
36
Hash Join
-
37
(Script 002 #7) - Indexing For JOIN
-
38
(Script 002 #8) - Indexing For ORDER BY
-
39
(Script 002 #9) - Indexing For GROUP BY
-
40
(Script 002 #10) - Indexing For COUNT
-
41
(Script 002 #11) - Indexing For MIN, MAX, SUM, AVG
-
42
(Script 002 #12) - Analyzing indexes with DMVs
-
43
Indexing Strategy
-
44
Section Overview
-
45
Foreign Keys - Introduction
-
46
Types Of Referenced Tables
-
47
On Delete, On Update Settings Guidelines
-
48
(Script 003 #1) Getting Information About Foreign Keys
-
49
(Script 003 #2) Foreign Key Index And Cascade Delete
-
50
(Script 003 #3) Foreign Key Index And Join Performance
-
51
Foreign Key
-
52
Section Overview
-
53
Normalization
-
54
1st Normal Form
-
55
2nd Normal Form
-
56
3rd Normal Form
-
57
Boyce-Codd Normal Form (BCNF)
-
58
4th Normal Form
-
59
Normalization – Mental Model
-
60
How Far To Normalize
-
61
(Script 004) Splitting The Customer Table
-
62
(Script 005 #1) Splitting The Name Column - Problem Definition
-
63
(Script 005 #2) Splitting The Name Column - Scaffolding code
-
64
(Script 005 #3) Splitting The Name Column - Data migration
-
65
Normalization
