Relational Database Administration and ETL Capstone Project

Database administration is more than just writing basic SQL queries; it requires managing real-world data flows, optimization, and automation. This text-based course guides you through a comprehensive capstone project to solidify your database management and engineering skills. You will transition from understanding database theory to executing practical administration tasks. By reading through structured explanations and analyzing real-world scenarios, you will learn how to design online transaction processing (OLTP) systems, construct robust data warehouses, and automate data pipelines. What you'll learn: Understand foundational relational database administration concepts and core terminology; Configure and manage OLTP databases and structured data warehouses using PostgreSQL; Write and optimize SQL queries for data extraction, transformation, and reporting; Build automated ETL pipelines using Apache Airflow to streamline data movement; Apply modern database practices, including basic containerized deployments and performance tuning. The course begins with essential database administration concepts before moving into step-by-step written walkthroughs for database setup, SQL optimization, and pipeline automation. You will learn by reading detailed code examples and completing practical, text-based exercises. This course is designed for aspiring database administrators, data engineers, and tech beginners who want to apply theoretical knowledge to practical scenarios. Start building your database administration portfolio today through structured, text-based learning.