This is a course that I took that taught its students to do database engineering---with an emphasis on relational databases and the SQL programming language. The [course syllabus](./DAD 220 Syllabus.pdf) and [course infographic](./DAD 220 Course Infographic.pdf) discussess these in detail.
This course culminated into the creation of a MySQL-powered relational database (discussed here) and the use of the SQL programming language to do rudimentary data analysis (discussed here).
Assignments
- 1-4 Lab: Practicing Query Language in Codio (submission, grade)
- 2-3 Activity: Updating Tables and SQL Identification (submission, grade)
- 2-4 Lab: Updating Tables (submission, grade)
- 3-2 Lab: Table Joins (submission, grade)
- 3-3 Major Activity: Create a Database (submission, grade)
- 4-2 Lab: Cardinality and Targeted Data (submission, grade)
- 4-3 Major Activity: Load and Query the Data (submission, grade)
- 5-2 Activity: Analysis and Summary (submission, grade)
- 5-3 Major Activity: Analyzing Queries (submission, grade)
- 6-1 Project One: Creating a Database and Querying Data (submission, grade)
- 7-1 Project Two: Analyzing Databases (submission, grade)
Erratas & retrospection
todo