🗄️

Foundations of Database Management

Free · 📖 59 lessons

Imported from publisher slug: foundations_of_database_management.

← Back to Courses

Course Content

59 lessons
Module 1: Introduction to Databases and the Relational Model 5 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
Module 2: Getting Started with PostgreSQL 5 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
Module 3: Data Types and Table Basics 5 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
Module 4: Keys and Relationships 5 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
Module 5: Database Design Fundamentals 5 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
Module 6: Normalization 5 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
Module 7: Querying Data with SQL 5 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
Module 8: Advanced Querying 5 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
Module 9: Modifying Data and Transactions 5 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
Module 10: Indexes and Performance 5 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
Module 11: Backup, Security, and Administration 5 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
Module 12: Final Project 4 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