Final Project Presentation & Certificate

Expand all sectionsCollapse all sections

Introduction to SQL and Databases
Get acquainted with databases and the role SQL plays in data-driven systems. Understand relational databases, the structure of tables, and the importance of SQL in modern applications. You’ll set up your working environment and execute your first queries.
5
Retrieving Data with SELECT
Master the foundational SELECT statement to pull data from one or more tables. Learn how to filter, sort, and format query results to extract meaningful insights.
5
Working with Multiple Tables
Discover how to combine data from multiple tables using JOINs. Learn when and how to use INNER JOIN, LEFT JOIN, RIGHT JOIN, and more to explore relationships between datasets.
6
Aggregating Data
Learn to perform calculations across data records to uncover summaries and trends. You’ll use aggregate functions and group data to analyze datasets effectively.
6
Modifying Data
Learn how to manipulate and maintain your data using SQL’s powerful INSERT, UPDATE, and DELETE commands, while understanding the importance of safety and backups.
5
Database Design Basics
Gain foundational knowledge of how databases are structured, normalized, and optimized. Understand how to design scalable databases and create relationships that mirror real-world data systems.
5
Practical Applications of SQL and Capstone Project
Bring it all together with practical use cases. You’ll build a real-world mini-database project from scratch, design, create, populate, and query your own database.
5

SQL Programming Fundamentals