Database Design Course - Learn how to design and plan a database for beginners

Overview

Embark on a comprehensive 8-hour course designed to teach database concepts and design principles for beginners. Gain a deep understanding of database organization, relational models, and data interrelationships. Explore essential topics including SQL basics, naming conventions, data integrity, and various types of relationships (one-to-one, one-to-many, many-to-many). Dive into key concepts such as primary and foreign keys, normalization forms, and entity-relationship modeling. Learn about different join types, indexing, and data types to optimize database performance. By the end of this course, you'll have the knowledge to plan and design efficient databases, setting a strong foundation for your data management skills.

Syllabus

) Introduction.
) What is a Database?.
) What is a Relational Database?.
) RDBMS.
) Introduction to SQL.
) Naming Conventions.
) What is Database Design?.
) Data Integrity.
) Database Terms.
) More Database Terms.
) Atomic Values.
) Relationships.
) One-to-One Relationships.
) One-to-Many Relationships.
) Many-to-Many Relationships.
) Designing One-to-One Relationships.
) Designing One-to-Many Relationships.
) Parent Tables and Child Tables.
) Designing Many-to-Many Relationships.
) Summary of Relationships.
) Introduction to Keys.
) Primary Key Index.
) Look up Table.
) Superkey and Candidate Key.
) Primary Key and Alternate Key.
) Surrogate Key and Natural Key.
) Should I use Surrogate Keys or Natural Keys?.
) Foreign Key.
) NOT NULL Foreign Key.
) Foreign Key Constraints.
) Simple Key, Composite Key, Compound Key.
) Review and Key Points....HA GET IT? KEY points!.
) Introduction to Entity Relationship Modeling.
) Cardinality.
) Modality.
) Introduction to Database Normalization.
) 1NF (First Normal Form of Database Normalization).
) 2NF (Second Normal Form of Database Normalization).
) 3NF (Third Normal Form of Database Normalization).
) Indexes (Clustered, Nonclustered, Composite Index).
) Data Types.
) Introduction to Joins.
) Inner Join.
) Inner Join on 3 Tables.
) Inner Join on 3 Tables (Example).
) Introduction to Outer Joins.
) Right Outer Join.
) JOIN with NOT NULL Columns.
) Outer Join Across 3 Tables.
) Alias.
) Self Join.