Syllabus

Here is the complete syllabus. --Click here.--

Office Hours

• Thomas Schwarz MWF 12:00 - 13:00 or by appointment.

Examinations

• -- Midterm (click here) <--

• -- Final (click here) <--

Contents

• Overview -- Click here --

Download Sample Databases

• Follow the instructions at Click here for link to MySQL Sample Database

Recordings

• January 13, 2025 -- Click here for 13/1/2025 --
• January 15, 2025 -- Click here for 15/1/2025 --
• January 22, 2025 -- Click here for 22/1/2025 --
• January 27, 2025 -- Click here for 27/1/2025 --
• January 29, 2029 -- Click here for 29/1/2025 --

Week 1

Module 1: History of Databases

• Presentation (History) (pdf) -- Click here --
• First Homework -- Click here --

Module 2: Relational Model of Data

• Presentation (pdf) -- Click here --
• Using MySQL (mp4) -- Click here --

Module 3: Simple Description of Relational Database Tables

• Presentation (pdf) -- Click here --

Module 4: Select Statement

• Presentation (pdf) -- Click here --
• Netflix Example: You need Python3.13, mysql.connector, NumPy, Pandas. Download and place the following files in the same directory. Update the password and username in the Python script, then run it.
  • netflix_titles.csv -- Click here --
  • reader.py -- Click here --

Homeworks

• Homework 1 (due January 21, via D2L) -- Click here for hw1 --
• Homework 1 (due January 21, via D2L) -- Click here for python script --
• Homework 1 (due January 21, via D2L) -- Click here for Bachman article --
• Homework 2 (due January 31, via D2L) -- Click here for text
  • Python Script: Click here for script
  • CSV file from Kaggle: Click here for csv file

Finis