Syllabus

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

Long Distance Students

Join Zoom Meeting
https://us02web.zoom.us/j/6514910904?pwd=RWkzdWo4M01NWFpnVGIzdlJkdnNLZz09

Meeting ID: 651 491 0904
Passcode: 2021

Office Hours

• Thomas Schwarz TR 15:10 - 16:00 and by appointment.
• Online office hours: to be determined

Examinations

• --> First Midterm (click here) <--
• --> First Midterm (click here) <--

Contents

Homeworks

Homework 1

• HW1 Click here
• article Click here
• Python script Click here

Homework 2

• HW2 Click here

Homework 3

• HW3 Click here
• Presentation Intro to SQL Workbench(mp4) -- Click here --
• zip file -- zip file --

Recordings

• January 17
• January 17
• January 17

Week 1

Preparation: Install MySQL and MySQL Workbench

• Presentation [keynote] Click here
• Presentation [pdf] Click here

Module 1: Introduction

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --

Module 2: Relational Model of Data

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation Intro to SQL Workbench(mp4) -- Click here --

Week 2

Module 3: Simple Description of Relational Databases, MySQL Data Definition Language

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --

Module 4: MySQL Select Statements

• Presentation (keynote) -- Click here --
• Presentation (pdf) -- Click here --
• Presentation (pptx) -- Click here --
• employees.sql download here

The normal way to install a database from a script is to use MySQLWorkbench, go to File -> Run SQL Script and then select the file. I have had difficulties with this. If you have the same difficulties, the safest workaround is to copy and paste the text of employees.sql into a query window and execute it in the Workbench. You can also open up the database in a terminal, type

mysql -u root -p

and then say at the prompt

source employees.sql

Finis