Advanced Database Design Patterns in Action

Focused View

10:37:13

0 View

1 - Introduction

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

2 - Installation

1 -Installation of SQL Server & SQL Server Management Studio (Windows).mp4

03:56

3 - Migration Scripts and Slides

1 -Advanced Database Design Patterns in Action.pdf

1 -migration scripts.zip

1 - Migration Scripts and Slides.html

1 - Migration Scripts - Dependencies.html

4 - Primary Key

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

5 - Indexing Strategy

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

6 - Foreign Key

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

7 - Normalization

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

8 - Simple Format

1 -Simple Format - Motivation and Implementation.mp4

02:24

2 -(Script 006) Simple Format.mp4

05:03

9 - Lookup Table

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

10 - Associative Table

1 -Associative Table - Theory.mp4

03:39

2 -(Script 010) Associative Table.mp4

05:00

11 - Master-Detail

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

12 - History Table

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

13 - Horizontal Partitioning

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

14 - Vertical Partitioning

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

15 - Modeling Hierarchical Data

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

16 - Modeling Inheritance

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

17 - Handling Multi-language Data

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

18 - Soft Delete

1 -Soft Delete - Theory.mp4

04:48

2 -(Script 020) Soft Delete.mp4

06:30

19 - Denormalization With JSON

1 -Denormalization With JSON - Theory.mp4

04:31

2 -(Script 021) Denormalization With JSON.mp4

09:43

20 - Computed Column

1 -Computed Column - Theory.mp4

04:01

2 -(Script 022) Computed Column.mp4

13:50

21 - Sensitive Data Obfuscation

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

Description

What You'll Learn?

60+ HANDS-ON sessions
140+ slides and 20+ sql migrations scripts available for download
Understand how to choose the right data type for your index
Choose the right indexing strategy to boost query performance
Apply advanced data modeling techniques to handle complex data scenarios
Master table partitioning—both horizontally and vertically—to efficiently manage large datasets
Design databases for multilingual applications without sacrificing speed
Model and implement hierarchical data structures for intuitive data organization
Prevent index fragmentation with smart design choices from the start
Implement table inheritance to model complex relationships effectively
Know when to normalize to improve data integrity, and when to denormalize to optimize performance

Who is this for?

Database developers and architects who are looking to level up their database design skills with advanced techniques

Full-stack developers, and junior DBAs who understand basic SQL Server concepts and can write simple SQL queries

SQL Server professionals who want to optimize performance, scalability, and maintainability in real-world projects

Software engineers working with large datasets who need to implement effective partitioning and indexing strategies

Data professionals tasked with designing complex database systems, including support for hierarchical data, multi-language applications, and table inheritance

What You Need to Know?

Students should have some experience working with relational databases and a basic understanding of design concepts such as normalization, indexes, triggers, and stored procedures

More details

Description
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.
Who this course is for:
Database developers and architects who are looking to level up their database design skills with advanced techniques
Full-stack developers, and junior DBAs who understand basic SQL Server concepts and can write simple SQL queries
SQL Server professionals who want to optimize performance, scalability, and maintainability in real-world projects
Software engineers working with large datasets who need to implement effective partitioning and indexing strategies
Data professionals tasked with designing complex database systems, including support for hierarchical data, multi-language applications, and table inheritance

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.