Foundations of Database Management
πŸ—„οΈ

Foundations of Database Management

β˜… Premium Β· πŸ“– 71 lessons

Foundations of Database Management teaches relational database design and SQL from the ground up using PostgreSQL, one of the most widely used production databases. The course covers the relational model, data types and table design, keys and relationships, normalization, and progresses through querying data, advanced SQL, transactions, indexing and performance, and backup/security/administration. With 23 hands-on labs working directly against a real PostgreSQL database, students don't just learn database theory β€” they design schemas, write real queries, and manage a live database end to end, finishing with a final project that ties design, querying, and administration together into one complete, portfolio-ready piece of work.

πŸ“š Get Access by Buying the Book
Every copy includes a free access code for this course.
Buy on Amazon β†’
← Back to Courses

Course Content

71 lessons
Module 1: Introduction to Databases and the Relational Model 6 items
1.1
What Is a Database?
Video
1.2
The Relational Model and Its Advantages
Video
1.3
PostgreSQL and the Database Landscape
Video
1.4
Installing PostgreSQL
Lab
1.5
Connecting with psql
Lab
1.6
Introduction to Databases and the Relational Model Quiz
Quiz
Module 2: Getting Started with PostgreSQL 6 items
2.1
PostgreSQL Architecture
Video
2.2
Databases, Schemas, and Roles
Video
2.3
Working with psql and GUI Tools
Video
2.4
Creating a Database and Schema
Lab
2.5
Exploring the PostgreSQL Environment
Lab
2.6
Getting Started with PostgreSQL Quiz
Quiz
Module 3: Data Types and Table Basics 6 items
3.1
Core PostgreSQL Data Types
Video
3.2
Creating Tables
Video
3.3
Constraints and Data Integrity
Video
3.4
Creating Your First Tables
Lab
3.5
Adding Constraints
Lab
3.6
Data Types and Table Basics Quiz
Quiz
Module 4: Keys and Relationships 6 items
4.1
Primary Keys
Video
4.2
Foreign Keys and Referential Integrity
Video
4.3
Types of Relationships
Video
4.4
Modeling Relationships with Foreign Keys
Lab
4.5
Building a Many-to-Many Relationship
Lab
4.6
Keys and Relationships Quiz
Quiz
Module 5: Database Design Fundamentals 6 items
5.1
The Database Design Process
Video
5.2
Entity-Relationship Diagrams
Video
5.3
From ERD to Schema
Video
5.4
Drawing an Entity-Relationship Diagram
Lab
5.5
Implementing a Schema from an ERD
Lab
5.6
Database Design Fundamentals Quiz
Quiz
Module 6: Normalization 6 items
6.1
Why Normalize? Data Anomalies Explained
Video
6.2
The Normal Forms
Video
6.3
Denormalization and Practical Trade-offs
Video
6.4
Normalizing a Messy Table
Lab
6.5
Normalized vs Denormalized Design
Lab
6.6
Normalization Quiz
Quiz
Module 7: Querying Data with SQL 6 items
7.1
SELECT and Filtering
Video
7.2
Sorting, Limiting, and Aggregating
Video
7.3
Joining Tables
Video
7.4
Writing Basic Queries
Lab
7.5
Practicing Joins
Lab
7.6
Querying Data with SQL Quiz
Quiz
Module 8: Advanced Querying 6 items
8.1
Subqueries and Common Table Expressions
Video
8.2
Grouping and Aggregation in Depth
Video
8.3
Window Functions
Video
8.4
Building Reports with CTEs
Lab
8.5
Using Window Functions
Lab
8.6
Advanced Querying Quiz
Quiz
Module 9: Modifying Data and Transactions 6 items
9.1
Inserting, Updating, and Deleting Data
Video
9.2
Transactions and ACID Properties
Video
9.3
Concurrency and Locking
Video
9.4
Practicing Data Modification
Lab
9.5
Working with Transactions
Lab
9.6
Modifying Data and Transactions Quiz
Quiz
Module 10: Indexes and Performance 6 items
10.1
How Indexes Work
Video
10.2
Creating and Choosing Indexes
Video
10.3
Analyzing Query Performance
Video
10.4
Creating and Testing Indexes
Lab
10.5
Analyzing Query Plans
Lab
10.6
Indexes and Performance Quiz
Quiz
Module 11: Backup, Security, and Administration 6 items
11.1
Users, Roles, and Permissions
Video
11.2
Backup and Restore
Video
11.3
Database Security Best Practices
Video
11.4
Managing Roles and Privileges
Lab
11.5
Backing Up and Restoring a Database
Lab
11.6
Backup, Security, and Administration Quiz
Quiz
Module 12: Final Project 5 items
12.1
Final Project Overview
Video
12.2
Designing and Building Your Database
Video
12.3
Querying and Presenting Your Results
Video
12.4
Final Database Project
Lab
12.5
Final Project Quiz
Quiz