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.
Overview
Syllabus
Database Design All-in-One Tutorial Series (8 HOURS!).
Database Design - Introduction.
Database Design 1 - What is a Database?.
Database Design 2 - What is a Relational Database?.
Database Design 3 - RDBMS.
Database Design 4 - Introduction to SQL.
Database Design 5 - Naming Conventions.
Database Design 6 - What is Database Design?.
Database Design 7 - Data Integrity.
Database Design 8 - Database Terms.
Database Design 9 - More Database Terms.
Database Design 10 - Atomic Values.
Database Design 11 - Relationships.
Database Design 12 - One-to-One Relationships.
Database Design 13 - One-to-Many Relationships.
Database Design 14 - Many-to-Many Relationships.
Database Design 15 - Designing One-to-One Relationships.
Database Design 16 - Designing One-to-Many Relationships.
Database Design 17 - Parent Tables and Child Tables.
Database Design 18 - Designing Many-to-Many Relationships.
Database Design 19 - Summary of Relationships.
Database Design 20 - Introduction to Keys.
Database Design 21 - Primary Key Index.
Database Design 22 - Look up Table.
Database Design 23 - Superkey and Candidate Key.
Database Design 24 - Primary Key and Alternate Key.
Database Design 25 - Surrogate Key and Natural Key.
Database Design 26 - Should I use Surrogate Keys or Natural Keys?.
Database Design 27 - Foreign Key.
Database Design 28 - NOT NULL Foreign Key.
Database Design 29 - Foreign Key Constraints.
Database Design 30 - Simple Key, Composite Key, Compound Key.
Database Design 31 - Review and Key Points....HA GET IT? KEY points!.
Database Design 32 - Introduction to Entity Relationship Modeling.
Database Design 33 - Cardinality.
Database Design 34 - Modality.
Database Design 35 - Introduction to Database Normalization.
Database Design 36 - 1NF (First Normal Form of Database Normalization).
Database Design 37 - 2NF (Second Normal Form of Database Normalization).
Database Design 38 - 3NF (Third Normal Form of Database Normalization).
Database Design 39 - Indexes (Clustered, Nonclustered, Composite Index).
Database Design 40 - Data Types.
Database Design 41 - Introduction to Joins.
Database Design 42 - Inner Join.
Database Design 43 - Inner Join on 3 Tables.
Database Design 44 - Inner Join on 3 Tables (Example).
Database Design 45 - Introduction to Outer Joins.
Database Design 46 - Right Outer Join.
Database Design 47 - JOIN with NOT NULL Columns.
Database Design 48 - Outer Join Across 3 Tables.
Database Design 49 - Alias.
Database Design 50 - Self Join.
Taught by
Caleb Curry
