Volkers Web Site

Disclaimer: This website was last updated in January 2016--MATERIAL MAY BE DATED.

Relational Database Development
Last revised: May 3, 2015

Syllabus

Instructor's Notes  
Volker's 10-Steps for Database Design
Unit 1 YouTube Videos
How to design databases (without all the technical jargon).
Concepts of Database Design Details for each of the 10 steps of database design.
Data Dictionary Template Word template for database data dictionary
SQL: Creating and Populating Database Tables
Unit 2 YouTube Videos
Notes on how to create new tables, delete tables, populate tables, delete records, update records, and view records using SQL.
SQL: Single Table Queries
Unit 3 YouTube Videos
Basics of SQL queries using the SELECT command. Covers the WHERE clause, ORDER BY clause, GROUP BY clause and calculated fields.
SQL: Multi-Table Queries
Unit 4 YouTube Videos
Advanced SQL queries to combine data from multiple tables. Includes discussions of Joins, subqueries, self joins, UNION, INTERSECT, MINUS.
Updating Database Structure and Data
Unit 5 YouTube Videos
SQL queries to change existing data in a database and to change the structure of existing tables.
Views, Indexes and Security
Unit 6 YouTube Videos
SQL queries to create, manage and use views and indexes. SQL commands to grant privileges to other users.

Labs Guided Learning Exercises
PortableApps Lab Lab to create PortableApps USB drive that will be used to create HTML, CSS and JavaScript
SQL 1 - Creating Tables Lab to experiment with creating and populating tables.

Assignments  
Due Date Policies Policies regarding assignment due dates, NQA coupons, updates and tickets
Tickets Daily mini-assignments required to get into the next class period.
Terminology Worksheet DBMS terminology worksheet
ERD Practice Small assignment to practice building ERDs
Database Design Assignment Part 1 Assignment to create ERDs and Data Dictionaries for Premiere Products.
Database Design Assignment Part 2 Assignment to create ERDs and Data Dictionaries for Henry Books and Alexamara Marina.
SQL Build and Populate Assignment to create databases, tables and records.
Single Table Queries
       Master Files
       Result Set Key
Assignment related to Chapter 4 in the text (Single Table Queries)
MySQL Master Files for assignments. Use Workbench to import into server.
Compare your query results to mine.
Multi-Table Queries
       Result Set Key
Assignment related to Chapter 5 in the text (Multiple-Table Queries)
Compare your query results to mine.
Updating Structure and Data Assignment related to Chapter 6 in the text (Updating Data)
Views, Indexes and Security
       Result Set Key
Assignment related to Chapter 7 in the text.
Compare your query results to mine.

Evaluation Sheets Evaluate your own assignments before turning them in.
Premiere Products Database Design Evaluation sheet for Premiere Products Database Design assignment
Henry Books and Alexamara Marina Database Design Evaluation sheet for Henry Books and Alexamara Marina Database Design assignment
SQL Build and Populate Part 2 Evaluation sheet for Rentals SQL build and populates commands assignment.

Handouts  
Installing XAMPP and MySQL Query Browser How to install XAMPP to get a portable version of MySQL.
Exporting and Importing MySQL Databases Instructions for how use phpMyAdmin to back up and restore your MySQL databases. Used to transfer databases from school to home and vice versa. 

Additional Resources  
Database Design Resource Good database terminology resource.

 
MSTC Stevens Point