Relational Database Concepts-Fundamental Relational Database Concepts
Course Introduction
Review of Data Fundamentals
()
Information and Data Models
()
ERDs & Types of Relationship
()
Mapping Entities to Tables
()
Data Types
()
Relational Model Concepts
()
Summary & Highlights
Relational Database Concepts-Introducing Relational Database Products
Database Architecture
()
Distributed Architecture and Clustered Databases
()
Database Usage Patterns
()
Introduction to Relational Database Offerings
()
Db2
()
MySQL
()
PostgreSQL
()
Summary & Highlights
Using Relational Databases-Creating Tables and Loading Data
Types of SQL statements (DDL vs. DML)
()
Creating Tables
()
CREATE TABLE Statement
()
ALTER, DROP, and Truncate tables
()
Data Movement Utilities
()
Loading Data
()
Summary & Highlights
Using Relational Databases-Designing Keys, Indexes, and Constraints
Database Objects & Hierarchy (Including Schemas)
()
Primary Keys and Foreign Keys
()
Overview of Indexes
()
Normalization
()
Relational Model Constraints - Advanced
()
Summary & Highlights
MySQL and PostgreSQL-MySQL
Getting Started with MySQL
()
Creating Databases and Tables in MySQL
()
Loading Data in MySQL
()
Using Keys and Constraints in MySQL
()
Summary & Highlights
MySQL and PostgreSQL-PostgreSQL
Getting Started with PostgreSQL
()
Creating Databases and Loading Data in PostgreSQL
()
Views
()
Summary & Highlights
Course Assignment-Assignment
Approach to Database Design (Including ERD)
()
Course Assignment-Course Wrap-up
Congratulations & Next Steps
Course Team & Acknowledgements