Course Content
المحتوى
0/54
Complete Database Design Tutorial Series – 8 Hours
08:21:35
Complete Database Design Tutorial Series – 8 Hours
08:21:35
Introduction to Database Design
08:21:35
Understanding Databases
08:21:35
Exploring Relational Databases
08:21:35
Introduction to RDBMS
08:21:35
Getting Started with SQL
08:21:35
Database Naming Conventions
08:21:35
What is Database Design?
08:21:35
Ensuring Data Integrity
08:21:35
Key Database Terminology
08:21:35
Additional Database Terms
08:21:35
Understanding Atomic Values
08:21:35
Database Relationships
08:21:35
One-to-One Relationships
08:21:35
One-to-Many Relationships
08:21:35
Many-to-Many Relationships
08:21:35
Designing One-to-One Relationships
08:21:35
Designing One-to-Many Relationships
08:21:35
Parent and Child Tables
08:21:35
Designing Many-to-Many Relationships
08:21:35
Summary of Database Relationships
08:21:35
Introduction to Database Keys
08:21:35
Primary Key Index
08:21:35
Lookup Tables
08:21:35
Superkey and Candidate Key
08:21:35
Primary Key vs. Alternate Key
08:21:35
Surrogate Key vs. Natural Key
08:21:35
Choosing Between Surrogate and Natural Keys
08:21:35
Understanding Foreign Keys
08:21:35
NOT NULL Foreign Keys
08:21:35
Foreign Key Constraints
08:21:35
Simple, Composite, and Compound Keys
08:21:35
Review of Key Points
08:21:35
Introduction to Entity Relationship Modeling
08:21:35
Understanding Cardinality
08:21:35
Exploring Modality
08:21:35
Introduction to Database Normalization
08:21:35
First Normal Form (1NF)
08:21:35
Second Normal Form (2NF)
08:21:35
Third Normal Form (3NF)
08:21:35
Indexes: Clustered, Nonclustered, and Composite
08:21:35
Understanding Data Types
08:21:35
Introduction to Joins
08:21:35
Inner Join Explained
08:21:35
Inner Join with Three Tables
08:21:35
Example of Inner Join with Three Tables
08:21:35
Introduction to Outer Joins
08:21:35
Right Outer Join Explained
08:21:35
JOIN with NOT NULL Columns
08:21:35
Outer Join Across Three Tables
08:21:35
Using Aliases in SQL
08:21:35
Self Join Explained
08:21:35
Final Exam - Comprehensive Database Design Certification
Comprehensive Database Design Certification

Understanding the differences between surrogate keys and natural keys.

Previous
Next
0% Complete