| 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.
|
|