Advanced Database Design Patterns in Action

سرفصل های دوره

1 - Introduction

1 -Introduction, Course Overview

2 -How to Use Migration Scripts and Navigate Through The Course

3 -OnlineStore Database Introduction

2 - Installation

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

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

2 -Key Types

3 -Primary Key Properties

4 -Surrogate Key

5 -Natural Key

6 -Surrogate Kye vs Natural Key - Summary

7 -(Script 001) - Primary Key

5 - Indexing Strategy

1 -Section Overview

2 -Heap

3 -Index Basics

4 -Nonclustered Index

5 -Nonclustered Index Types And Use Cases

6 -Clustered Index - Introduction

7 -Clustered Index Design

8 -Clustered Index On An Integer Column

9 -Clustered Index On A GUID Column

10 -Clustered Index Type And A Table Size

11 -(Script 002 #1) - Clustered Index Key Size Impact

12 -(Script 002 #2) - IDENTITY Gaps

13 -Nonclustered Primary Keys

14 -Data Access Operators

15 -Query Patterns

16 -(Script 002 #3) - Indexes And Cardinality

17 -(Script 002 #4) - Composite Index

18 -(Script 002 #5) - Composite Index vs Index With Included Column

19 -(Script 002 #6) - Non-sargable queries

20 -Nested Loops

21 -Merge Join

22 -Hash Join

23 -(Script 002 #7) - Indexing For JOIN

24 -(Script 002 #8) - Indexing For ORDER BY

25 -(Script 002 #9) - Indexing For GROUP BY

26 -(Script 002 #10) - Indexing For COUNT

27 -(Script 002 #11) - Indexing For MIN, MAX, SUM, AVG

28 -(Script 002 #12) - Analyzing indexes with DMVs

6 - Foreign Key

1 -Section Overview

2 -Foreign Keys - Introduction

3 -Types Of Referenced Tables

4 -On Delete, On Update Settings Guidelines

5 -(Script 003 #1) Getting Information About Foreign Keys

6 -(Script 003 #2) Foreign Key Index And Cascade Delete

7 -(Script 003 #3) Foreign Key Index And Join Performance

7 - Normalization

1 -Section Overview

2 -Normalization

3 -1st Normal Form

4 -2nd Normal Form

5 -3rd Normal Form

6 -Boyce-Codd Normal Form (BCNF)

7 -4th Normal Form

8 -Normalization Mental Model

9 -How Far To Normalize

10 -(Script 004) Splitting The Customer Table

11 -(Script 005 #1) Splitting The Name Column - Problem Definition

12 -(Script 005 #2) Splitting The Name Column - Scaffolding code

13 -(Script 005 #3) Splitting The Name Column - Data migration

8 - Simple Format

1 -Simple Format - Motivation and Implementation

2 -(Script 006) Simple Format

9 - Lookup Table

1 -Lookup Table - Theory

2 -(Script 007) Vendor Lookup Table

3 -(Script 008) State Lookup Table

4 -(Script 009) Order Status Type Lookup Table

10 - Associative Table

1 -Associative Table - Theory

2 -(Script 010) Associative Table

11 - Master-Detail

1 -Master-Detail - Theory

2 -(Script 011 #1) Master-Detail Implementation

3 -(Script 011 #2) Normal Index vs Filtered Index

12 - History Table

1 -Section Overview

2 -History Table - Theory

3 -(Script 012 #1) Order Status History Table

4 -(Script 012 #2) Event Sourcing

5 -(Script 013 #1) Promotion Table

6 -(Script 013 #2) Temporal Table

13 - Horizontal Partitioning

1 -Section Overview

2 -Horizontal Partitioning - Definition

3 -Horizontal Partitioning Types

4 -Horizontal Partitioning Pros And Cons

5 -Partition Function

6 -Partition Scheme

7 -Partitioned Table

8 -Aligned And Nonaligned Indexes

9 -(Script 014 #1) Partitioned Table Creation

10 -Merge, Split And Switch Operations

11 -(Script 014 #2) Sliding Window

12 -(Script 014 #3) How NOT To Merge Partitions

13 -(Script 014 #4) Partitioned vs Non-partitioned Table

14 - Vertical Partitioning

1 -Section Overview

2 -Data Page

3 -Internal Fragmentation

4 -External Fragmentation

5 -Page Splits

6 -Fragmentation Removal And Prevention

7 -(Script 015 #1) Customer Description Table Creation

8 -(Script 015 #2) Vertical Partitioning And Query Performance

9 -(Script 015 #3) Index Key Size And Fragmentation

15 - Modeling Hierarchical Data

1 -Section Overview

2 -Hierarchical Data - Definition

3 -Adjacency List Pattern

4 -Closure Table Pattern

5 -Nested Sets Pattern

6 -Path Enumeration Pattern

7 -HierarchyID Type

8 -(Script 016 #1) Migration From Adjacency List

9 -(Script 016 #2) Hierarchy ID methods

10 -(Script 016 #3) Path Enumeration vs HierarchyID

11 -(Script 016 #4) HierarchyID Indexes

16 - Modeling Inheritance

1 -Inheritance Patterns

2 -(Script 017) Software Product Table Creation

3 -(Script 018) Hardware Product Table Creation

17 - Handling Multi-language Data

1 -Section Overview

2 -Unicode And Encoding Selection

3 -Collations

4 -Schema Design

5 -(Script 019 #1) Basic Collation Check

6 -(Script 019 #2) Multi-language Data Gotchas

7 -(Script 019 #3) Sorting Single-column Multilanguage Data

8 -(Script 019 #4) Migration To Multi-languages

9 -(Script 019 #5) Changing From VARCHAR To NVARCHAR

18 - Soft Delete

1 -Soft Delete - Theory

2 -(Script 020) Soft Delete

19 - Denormalization With JSON

1 -Denormalization With JSON - Theory

2 -(Script 021) Denormalization With JSON

20 - Computed Column

1 -Computed Column - Theory

2 -(Script 022) Computed Column

21 - Sensitive Data Obfuscation

1 -Section Overview

2 -Use cases

3 -Techniques

4 -(Script 023#1) Using Stored Procedures

5 -(Script 023#2) Using Views

6 -(Script 023#3) Dynamic Data Masking

7 -(Script 023#4) Column Level Encryption

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy