Program Overview
This course introduces you to the principles of relational databases and SQL programming. Learn to create, query, and manage databases, and develop skills for data-driven decision-making.
Learn to define tables, enforce constraints, perform queries, and analyze data effectively. By the end, learners will be equipped to manage databases and write SQL queries in real-world scenarios.
What you’ll learn
- Understand Database Concepts — Tables, relationships, keys, and normalization
- Write SQL Queries — SELECT, JOIN, GROUP BY, and aggregations
- Data Analysis — Query real datasets for insights
- Apply Best Practices — Build efficient, normalized, and maintainable databases
Skills you’ll learn
- SQL Queries
- Database Design
- Joins & Aggregations
- Transactions
- Data Analysis
Tools you’ll learn
- SQL
- SQLite
- MySQL
- PostgreSQL
- DB Browser for SQLite
- Visual Studio Code
Comprehensive Curriculum
3 modules, 30+ lessons, 16 weeks of beginner-friendly SQL and database learning
Key Topics
- Introduction to databases
- Relational database concepts
- Tables, rows, and columns
- Primary and foreign keys
- Data types and constraints
- Understanding schemas
Hands-on Projects
- Create your first database and tables
- Define keys and constraints
