Course overview
BeginnerLearn to design databases and write practical SQL queries.
What you will learn
- Design simple relational databases
- Write safe SQL queries
- Connect related tables with keys and joins
Course curriculum
- Database fundamentals and tables
- SELECT, INSERT, UPDATE, and DELETE
- WHERE, ORDER BY, and GROUP BY
- Aggregate functions
- Primary keys and foreign keys
- Relationships and database design
- JOINs and advanced SQL
Practical examples
- Find top customers by total purchase
- Join orders to customer records
Projects
- Student records database
- Small shop inventory database