This course from Coursera covers a wide range of topics, from executing basic queries to database modeling. What sets it apart is its emphasis on hands-on learning through real-world data exercises.
- Data Definition Language (DDL): CREATE
- Data Manipulation Language (DML): DELETE, INSERT and UPDATE
- Data Query Language (DQL): SELECT
- SQL clauses: COUNT, LIMIT, DISTINCT, JOIN
- Sub-queries and CTEs
- Database access using Python
- Analyzing data with Python
- Working with real-word datasets
- Relational databases concepts
- Relational Model Constraints