Syllabus
Here is the complete syllabus. --Click here.--
Long Distance Students
Zoom link for classes and online office hours: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) <--
- HW1 Click here
- article Click here
- Python script Click here
- HW2 Click here
- HW3 Click here
- Presentation Intro to SQL Workbench(mp4) -- Click here --
- zip file -- zip file --
- Presentation [keynote] Click here
- Presentation [pdf] Click here
- Presentation (keynote) -- Click here --
- Presentation (pdf) -- Click here --
- Presentation (keynote) -- Click here --
- Presentation (pdf) -- Click here --
- Presentation Intro to SQL Workbench(mp4) -- Click here --
- Presentation (keynote) -- Click here --
- Presentation (pdf) -- Click here --
- Presentation (pptx) -- Click here --
- Presentation (keynote) -- Click here --
- Presentation (pdf) -- Click here --
- Presentation (pptx) -- Click here --
- employees.sql download here
Contents
Homeworks
Homework 1
Homework 2
Homework 3
Recordings
Week 1
Preparation: Install MySQL and MySQL Workbench
Module 1: Introduction
Module 2: Relational Model of Data
Week 2
Module 3: Simple Description of Relational Databases, MySQL Data Definition Language
Module 4: MySQL Select Statements
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 -pand then say at the prompt
source employees.sql