Welcome to the introduction to database course!
We will start the course by learning what is Relational Database and dive into the detail of concrete database like MySQL.
Later on in the course, we will, then, go over the advance yet central topic of Relational Database -- Joins. Of course, with a lot of examples to practice JOINs.
After we are done with Relational Database, we will go over the NoSQL database such as MongoDB to get a hands on difference between Relational Database and NoSQL database.
All in all after the class, you should be able to read/write code to read/store/manipulate data into database.
As this course is 100 level courses, I do not expect any of you to have any programming background before hands. Thus, the course will assume you know nothing and teach everything from ground up.
Although it is not required but please be familiar with terminal (Command line interface on windows). Most of the examples within lectures will be in terminal.
While some may be in the MySQL workbench, I'd prefer to do everything in terminal
I do recommend you to have a programming text-editor ready like Sublime Text, Atom or Visual Studio Code installed on your computer so you can code well.
The schedule below is tentative and is subject to change.
| Week # [date] | Topic | Notes |
|---|---|---|
| 1 [01/27] | Introduction | Set up environment |
| 2 [02/03] | SQL Syntax | |
| 3 [02/10] | Aggregation & Sub-queries | Lab 1 |
| 4 [02/17] | SQL Joins | Homework 1 |
| 5 [02/24] | SQL Joins, SQL Functions | |
| 6 [03/03] | Advanced Queries | Lab 2 |
| 7 [03/10] | Data Manipulation | Lab 3 |
| 8 [03/17] | Mid term | Homework 2 |
| 9 [03/24] | Data definition language | |
| 10 [03/31] | Spring break | |
| 11 [04/07] | Data definition language | |
| 12 [04/14] | Advance Topic in SQL | Lab 4 |
| 13 [04/21] | No class | no class |
| 14 [04/28] | Introduction to NoSQL, MongoDB Aggregation | |
| 15 [05/05] | MongoDB Aggregation | Homework 3 |
| 16 [05/12] | Database Summary | Homework 4, Extra Credit |
| Final [05/19] | Final |