| Class Type / Number | Date | Topic | Activities before Class |
| Lecture 1 | Jan 11 | - Introduction
- Getting familiar with MySQL Workbench Environment and Jupyter
- The Relational Model
| – |
| Canceled | Jan 18 | - Class was canceled due to inclement weather
| – |
| Lecture 2 | Jan 25 | - Basic SQL
- Single-table Queries
| - Read and practice Lecture_1.pptx
- Install MySQL Server and MySQL Workbench on your machine and redo the activities from Lecture 1
|
| Lecture 3 | Feb 1 | - Quiz 1
- Multi-table Queries
- Set Operators
| - Read and practice Lecture_2.pptx
- Using MySQL try out all the SQL commands your learned
- Submit Problem Set 1
|
| Lecture 4 | Feb 8 | - Quiz 2, 3 (two sections)
- Nested Queries
- Aggregation & GROUP BY
| - Read and practice Lecture_3.pptx
|
| Review 1 | Feb 15 | - Quiz 4
- NULL Values & Outer Joins
- Review & In-class Exercise
| - Read and practice Lecture_4.pptx
- Submit Problem Set 2
|
| Test 1 | Feb 22 | Test I Semester midpoint: February 27 | |
| Lecture 5 | Mar 1 | - Create Database
- Create/Alter/Delete Tables
- Insert/Delete/Modify Tuples
- The E/R Model Part I
| - Start looking for project teammates and a project topic
|
| Lecture 6 | Mar 8 | - Quiz 5
- The E/R Model Part II
| - Read and practice Lecture_5.pptx
- Finalize your project team and topic
|
| Spring Break | Mar 15 | - Good time to review the course material!
- Also have fun!
| – |
| Lecture 7 | Mar 22 | - Quiz 6
- Design Theory: Part I
- Normal Forms and Functional Dependencies
- Finding Functional Dependencies
| - Read and practice Lecture_6.pptx
|
| Lecture 8 | Mar 29 | - Quiz 7
- Design Theory: Part II
- Boyce-Codd Normal Form (BCNF)
- Multi-Value Dependencies (MVDs)
- Decomposition
| - Read and practice Lecture_7.pptx
- Submit Problem Set 3
|
| Lecture 9 | Apr 5 | - Quiz 8
- Transactions & Concurrency
- Indexes
- Views
| - Read and practice Lecture_8.pptx
- Submit Problem Set 4
|
| Lecture 10 | Apr 12 | - Quiz 9
- Data Security
- XML, JSON, NoSQL
- Data Mining
| - Read and practice Lecture_9.pptx
|
| Review 2 | Apr 19 | - Quiz 10
- Review & Course Wrap-up
- In-class Exercise
| - Read and practice Lecture_10.pptx
- Submit the Class Project
|
| Test 2 | Apr 26 | Test II | |
| Grades | May 3 | - Final grades will be posted on PAWS on May 3 at 5PM.
- The detailed grades will be made available on iCollege.
| |
