Schedule

June 5th (Th)
Topic:Course Introduction
Handout:Syllabus
 
June 9th (M)
Topic:Getting Started
Basic Database Concepts (1 of 2)
Background:Data, Data Everywhere (InformationWeek)
What is a Database, Anyway? (Cheeseman)
Introduction to Relational Databases (Mote)
 
June 10th (Tu)
Topic:Basic Database Concepts (2 of 2)
Background:An Introduction to Relational Databases and SQL (Murach, Ch 1)
 
June 11th (W)
Topic:Database Modeling (1 of 2)
Database Keys (Chapple)
Primary and Foreign Keys (DatabaseDev.co.uk)
Introduction to ER Diagrams (Mote)
Understanding Entity Relationship Diagrams (CERI)
Entity-Relationship Model (Wikipedia)
 
June 12th (Th)
Topic:Database Modeling (2 of 2)
Background:How to Design a Database (Murach, Ch 9)
Table Relationships (DatabasePrimer.com)
Many-to-Many Relationship (Techopedia.com)
Foreign Key (Google Definitions)
Foreign Key (Wikipedia)
SQL Foreign Key (1KeyData.com)
Referential Integrity (Chapple)
Referential Integrity (Google Definitions)
 
June 16th (M)
Topic:Modeling Exercise 1
 
June 17th (Tu)
Topic:Normalization
Background:How to Design a Database (Murach, Ch 9)
Normalization (Mote)
Normalization Exercise (Mote)
Normalization Practice Problem (Mote)
Database Normalization (Microsoft Knowledge Base)
Database Normalization (ServerWatch)
Database Normalization (Wikipedia)
Database Normalization (Chapple)
Database Normalization (Database Journal)
Database Normalization for the Average Jane/Joe (Database Journal)
Searching for Database Normalization (Google)
 
June 18th (W)
Topic:Modeling Exercise 1, Revisited
 
June 19th (Th)
Topic:Modeling Exercise 2
Handout:Modeling Exercise
 
June 23rd (M)
Topic:SQL Data Definition Language (1 of 2)
Background:How to Use Oracle SQL Developer (Murach, Ch 2)
How to Create Tables, Indexes and Sequences (Murach, Ch 10)
 
June 24th (Tu)
Topic:SQL Data Definition Language (2 of 2)
Background:How to Create Tables, Indexes and Sequences (Murach, Ch 10)
 
June 25th (W)
Topics:SQL DDL Wrap-up
and Review
 
June 26th (Th)
Topic:Exam One
 
June 30th (M)
Topic:SQL Data Manipulation Language Overview
Background:SQL Select Statement (w3schools)
SQL Insert Statement (w3schools)
SQL Update Statement (w3schools)
SQL Delete Statement (w3schools)
Select Statement Basics (FirstSQL.com)
Insert/Update/Delete Statement Basics (FirstSQL.com)
How to Retrieve Data from a Single Table (Murach, Ch 3)
How to Insert, Update and Delete Data (Murach, Ch 7)
 
July 1st (Tu)
Topic:Basic SQL Select (1 of 2)
Sample Data:Instructions (Person Table)
CREATE TABLE command
Excel spreadsheet (zip format)
Background:How to Retrieve Data from a Single Table (Murach, Ch 3)
How to Work with Data Types and Functions (Murach, Ch 8)
How to Create Views (Murach, Ch 11)
 
July 2nd (W)
Topics:Basic SQL Select (2 of 2)
Aggregation SQL Select
Background:How to Code Summary Queries (Murach, Ch 5)
 
July 3rd (Th)
Topic:Multi-Table SQL Select (1 of 2)
Sample Data:Instructions (Office, Employee & Dependent Tables)
CREATE TABLE commands
Excel spreadsheet (zip format)
Background:How to Retrieve Data from Two or More Tables (Murach, Ch 4)
SQL Join (w3schools)
SQL Join (SQL-Tutorial.net)
SQL Join (tizag.com)
A Visual Explanation of SQL Joins (Coding Horror)
 
July 7th (M)
Topic:Multi-Table SQL Select (2 of 2)
Background:How to Retrieve Data from Two or More Tables (Murach, Ch 4)
How to Work with Timestamps and Intervals (Murach, Ch 17)
FYI:Clearing a Path Through the 3NF Join Jungle (Database Journal)
Maybe Normalization Isn't Normal (Coding Horror)
 
July 8th (Tu)
Topics:SQL Subquery Select
Self Joins
Sample Data:Instructions (Supervisor)
ALTER TABLE & UPDATE commands
Background:How to Code Subqueries (Murach, Ch 6)
SQL Subquery (Beginner SQL Tutorial)
SQL Subqueries (TutorialsPoint)
SQL Subquery (1KeyData)
Correlated Subquery (Wikipedia)
SQL Subqueries (Google Search)
 
July 9th (W)
Topic:Action Commands, Functions, Stored Procedures & Triggers
Background:How to Insert, Update and Delete Data (Murach, Ch 7)
How to Create Stored Procedures and Functions (Murach, Ch 15)
How to Create Triggers (Murach, Ch 16)
 
July 10th (Th)
Topic:Exam Two