Learn the fundamentals of relational databases, their management systems, and principles of effective database design. Understand the importance of naming conventions, data integrity, keys, indexes, and cardinality. Explore different types of joins and the benefits of using aliases. Plus, get an introduction to the Database Modeling Language (DBML).
Table of contents
IntroductionWhat is a Database?What is a Relational Database?RDBMSIntroduction to SQLNaming ConventionsWhat is Database Design?Data IntegrityDatabase TermsAtomic ValuesIntroduction to KeysPrimary Key IndexLook up TableSuperkey and Candidate KeyPrimary Key and Alternate KeySurrogate Key and Natural KeyShould I use Surrogate Keys or Natural Keys?Foreign KeyNOT NULL Foreign KeyForeign Key ConstraintsSimple Key, Composite Key, Compound KeyRelationshipsOne-to-One RelationshipsOne-to-Many RelationshipsMany-to-Many RelationshipsDesigning Relationships (SQL Implementation)Parent Tables and Child TablesIntroduction to Entity Relationship ModelingCardinalityModalityIntroduction to Database Normalization1NF (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 TypesIntroduction to JoinsInner JoinInner Join on 3 Tables (Example)Introduction to Outer JoinsRight Outer JoinJOIN with NOT NULL ColumnsOuter Join Across 3 TablesAliasSelf JoinDatabase Markup Language (DBML)Conclusion4 Comments
Sort: