Stanford Online: Databases: Relational Databases and SQL
-
Learned foundational concepts of relational databases: tables, relationships, keys, integrity, normalization, and schema design.
-
Mastered SQL query writing: filtering, joining, aggregations, subqueries, sorting and grouping data efficiently.
-
Gained hands-on experience working with real relational datasets, practicing both query and data-modification (insert, update, delete) operations.
-
Strengthened ability to wrangle and prepare data for analysis, ensuring data correctness and structuring for downstream analytics and applications.
​
Tools & Techniques:
-
SQL for querying and data manipulation (SELECT, JOIN, GROUP BY, ORDER BY, subqueries)
-
Schema design, data normalization, primary/foreign keys
-
Data integrity: constraints, handling missing or inconsistent data
-
Practice using relational database management systems (RDBMS) / SQLite or similar platform for exercises