This course teaches beginners how to design and plan a database. By the end of the course, learners will understand database concepts, database design, data integrity, relationships, keys, normalization, indexes, data types, and various types of joins. The course uses a combination of lectures and examples to explain these topics. The intended audience for this course is beginners who want to learn about designing databases.
Overview
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.
Taught by
freeCodeCamp.org
