This course on database design aims to help learners understand fundamental database concepts and gain a deeper understanding of database design. By the end of the course, students will be able to design and implement databases effectively. The course covers topics such as relational databases, SQL, data integrity, relationships, keys, entity-relationship modeling, normalization, indexes, data types, and joins. The teaching method includes tutorials, examples, and practical exercises. This course is best suited for individuals looking to enhance their database design skills and knowledge, regardless of prior experience in the field.
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
