Главная
Study mode:
on
1
Database Design All-in-One Tutorial Series (8 HOURS!)
2
Database Design - Introduction
3
Database Design 1 - What is a Database?
4
Database Design 2 - What is a Relational Database?
5
Database Design 3 - RDBMS
6
Database Design 4 - Introduction to SQL
7
Database Design 5 - Naming Conventions
8
Database Design 6 - What is Database Design?
9
Database Design 7 - Data Integrity
10
Database Design 8 - Database Terms
11
Database Design 9 - More Database Terms
12
Database Design 10 - Atomic Values
13
Database Design 11 - Relationships
14
Database Design 12 - One-to-One Relationships
15
Database Design 13 - One-to-Many Relationships
16
Database Design 14 - Many-to-Many Relationships
17
Database Design 15 - Designing One-to-One Relationships
18
Database Design 16 - Designing One-to-Many Relationships
19
Database Design 17 - Parent Tables and Child Tables
20
Database Design 18 - Designing Many-to-Many Relationships
21
Database Design 19 - Summary of Relationships
22
Database Design 20 - Introduction to Keys
23
Database Design 21 - Primary Key Index
24
Database Design 22 - Look up Table
25
Database Design 23 - Superkey and Candidate Key
26
Database Design 24 - Primary Key and Alternate Key
27
Database Design 25 - Surrogate Key and Natural Key
28
Database Design 26 - Should I use Surrogate Keys or Natural Keys?
29
Database Design 27 - Foreign Key
30
Database Design 28 - NOT NULL Foreign Key
31
Database Design 29 - Foreign Key Constraints
32
Database Design 30 - Simple Key, Composite Key, Compound Key
33
Database Design 31 - Review and Key Points....HA GET IT? KEY points!
34
Database Design 32 - Introduction to Entity Relationship Modeling
35
Database Design 33 - Cardinality
36
Database Design 34 - Modality
37
Database Design 35 - Introduction to Database Normalization
38
Database Design 36 - 1NF (First Normal Form of Database Normalization)
39
Database Design 37 - 2NF (Second Normal Form of Database Normalization)
40
Database Design 38 - 3NF (Third Normal Form of Database Normalization)
41
Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index)
42
Database Design 40 - Data Types
43
Database Design 41 - Introduction to Joins
44
Database Design 42 - Inner Join
45
Database Design 43 - Inner Join on 3 Tables
46
Database Design 44 - Inner Join on 3 Tables (Example)
47
Database Design 45 - Introduction to Outer Joins
48
Database Design 46 - Right Outer Join
49
Database Design 47 - JOIN with NOT NULL Columns
50
Database Design 48 - Outer Join Across 3 Tables
51
Database Design 49 - Alias
52
Database Design 50 - Self Join
Description:
Dive into an extensive 17-hour database design tutorial series that offers a deep, technical exploration of database concepts. Learn about relational databases, SQL, naming conventions, data integrity, and various types of relationships between tables. Explore key concepts such as primary keys, foreign keys, and indexes. Understand entity relationship modeling, cardinality, and modality. Master database normalization techniques, including 1NF, 2NF, and 3NF. Discover different types of joins, including inner joins and outer joins, and how to implement them across multiple tables. Gain practical knowledge on data types, aliases, and self-joins to enhance your database design skills.

Database Design

Caleb Curry
Add to list
#Programming #Databases #Domain-Specific Languages (DSL) #SQL #Relational Databases #Database Design #Computer Science #Information Technology #Data Management #Data Integrity #Normalization
0:00 / 0:00
1 of 52

Database Design All-in-One Tutorial Series (8 HOURS!)