Foundations of Database Management
🗄️

Foundations of Database Management

★ Premium · 📖 71 lessons

Foundations of Database Management provides a practical introduction to the concepts and skills needed to design, build, and manage modern relational databases. Whether you are new to databases or preparing for a career in software development, data analysis, or information technology, this course will help you develop a solid understanding of database design, SQL, normalization, indexing, transactions, security, and performance optimization. Students will work with industry-standard database systems while learning the principles that apply across virtually all relational database platforms. The course combines clear video instruction with hands-on labs, quizzes, and a companion textbook to reinforce every concept through practical experience. You'll write SQL queries, create and modify database objects, manage data, and complete real-world exercises that build confidence and problem-solving skills. By the end of the course, you'll have the foundational database knowledge needed to support modern applications and continue your learning in advanced database administration, software development, cloud computing, and data engineering.

📚 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