Syllabus

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

Office Hours

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

Examinations

• Midterm
  • Preparation: Install and analyze the sample employees database. You should do so at your earliest convenience. Create a diagram of the contents by analyzing the table definitions. Only notice that not all foreign key constraints are currently enforced.
  • -- midterm.sql to install a data base (click here) --
  • -- Midterm (click here) --
• Final
  • -- 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 --
• February 3, 2029 -- Click here for 3/2/2025 --
• February 5, 2029 -- Click here for 3/5/2025 --
• February 10, 2029 -- Click here for 3/10/2025 --
• February 12, 2029 -- Click here for 3/12/2025 --
• February 24, 2029 -- Click here for 3/24/2025 --
• February 26, 2029 -- Click here for 3/26/2025 --

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

Module 5: Database Design Theory

• Presentation (pdf) -- Click here --

Online Only: The SQL Language

• Data Model Language
  1. SQL Data Model -- Click here --
  2. SQL Schema Definition (12 min) -- Click here --
  3. SQL Creating a Database (26 min) -- Click here --
• Data Query Language
  1. SQL First Look at Selects (43 min) -- Click here --
  2. Preparation: Install the MySQL Sakila database. official link click here
  3. SQL Joins (22 min) -- Click here --
  4. Run the Python script Download here
  5. Source the resulting file or download it from here: _Click here
  6. SQL Joins (17 min) -- Click here --

SQL Language

• Algebraic Query Language -- click here
• SQL Operations (repetition) -- 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
• Homework 3 (due February 7, 2025, via D2L) -- Click here for text
• Homework 4 (due February 21, 2025, via D2L) -- Click here for text
• Homework 5 (due March 3, 2025, via D2L) -- Click here for text

Finis