| January 18th (Wednesday) |
| Topic: | Course Introduction |
| Handout: | Syllabus |
| FYI: | Forbes Magazine Names Codd's Relational Database Model One of the Most Important Innovations of the Past 85 Years (Forbes) |
| |
| January 23rd (Monday) |
| Topic: | Basic Database Concepts (Part 1) |
| Readings: | What is a Database, Anyway? (Cheeseman) |
| An Introduction to Relational Databases and SQL (Murach, Ch 1, Pg 3-21) |
| Introduction to Relational Databases (Mote) |
| FYI: | Data, Data Everywhere (InformationWeek) |
| The Cost of Data Management (CIO) |
| Enterprises Face New e-Discovery Rules (IDG News Service) |
| E-Medical Records: What Seems To Be The Problem? (Computerworld) |
| Xtreme ROI: Four Projects That Blew the Doors Off (Computerworld) |
| |
| January 25th (Wednesday) |
| Topic: | Class Cancelled - No electricity in UTC |
| |
| January 30th (Monday) |
| Topic: | Basic Database Concepts (Part 2) |
| Readings: | ANSI SQL Can Combine Advantages and Principles of Relational and Hierarchical Data Processing (Database Journal) |
| Primary and Foreign Keys (DatabaseDev.co.uk) |
| Foreign Key (Google Definitions) |
| Foreign Key (Wikipedia) |
| SQL Foreign Key (1KeyData.com) |
| FYI: | Five Indispensable IT Skills of the Future (IT World) |
| Ten of the Biggest Mistakes Developers Make With Databases (Developer.com) |
| Protecting Your Data Against Human Mistakes (Computerworld) |
| Managing Data Growth with Enterprise-class Databases
(Database Journal) |
| |
| February 2nd (Wednesday) |
| Topic: | Database Models & ER Diagrams |
| Readings: | How to Design a Database (Murach, Ch 9, Pg 292-303) |
| Introduction to ER Diagrams (Mote) |
| Understanding Entity Relationship Diagrams (CERI) |
| Creating ER Diagrams with Visio 2010 (Mote) |
| Handout: | Sample Visio ER Diagram |
| FYI: | Entity-Relationship Model (Wikipedia) |
| Crow's Foot Notation (Scribd) |
| Visio ERD Part 1 (YouTube) |
| Visio ERD Part 2 (YouTube) |
| Visio ERD Part 3 (YouTube) |
| |
| February 6th (Monday) |
| Topic: | Normalization |
| Readings: | How to Design a Database (Murach, Ch 9, Pg 304-318) |
| Normalization (Mote) |
| Normalization Exercise (Mote) |
| Normalization Practice Problem (Mote) |
| FYI: | 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) |
| |
| February 8th (Wednesday) |
| Topic: | Modeling Exercise |
| Handout: | Modeling Exercise (Mote) |
| FYI: | The Tech Behind 236 eHarmony Members Getting Hitched Daily (Computerworld) |
| eHarmony's Database (Oracle) |
| eHarmony Hacked (Geeker's) |
| Keys to Locking Down Storage Security on a Database (eWeek) |
| Link Between IT Sabotage and Work Behavior (TechWorld.com) |
| How to Mitigate Customer Data and Identity Theft Risks (eWeek) |
| When to Shred: Purging Data Saves Money, Cuts Legal Risk (Computerworld) |
| |
| February 13th (Monday) |
| Topic: | SQL Introduction |
| Handout: | SQL Introduction (Mote) |
| Readings: | Introduction to Relational Databases and SQL (Murach, Ch 1) |
| Skim: | How to Use Management Studio (Murach, Ch 2) |
| How to Retrieve Data from a Single Table (Murach, Ch 3) |
| How to Insert, Update and Delete Data (Murach, Ch 7) |
| How to Create and Maintain Databases and Tables with SQL Statements (Murach, Ch 10) |
| FYI: | The Age of Big Data (New York Times) |
| The Big Promise of Big Data (IT World) |
| The Small World of Big Data (IT World) |
| What is Hadoop? (O'Reilly) |
| Learning from Physics Research to Tackle Big Data (CNET) |
| |
| February 15th (Wednesday) |
| Topic: | SQL Data Definition Language (Part 1) |
| Handout: | Introduction to Management Studio (Mote) |
| Readings: | Introduction to Relational Databases and SQL (Murach, Ch 1) |
| How to Use Management Studio (Murach, Ch 2) |
| How to Create and Maintain Databases and Tables with SQL Statements (Murach, Ch 10) |
| FYI: | ANSI Standard SQL? What the heck is ANSI? (Wikipedia) |
| SQL Tutorial (W3Schools) |
| SQL Server Tutorials (MSDN) |
| |
| February 20th (Monday) |
| Topic: | SQL Data Definition Language (Part 2) |
| Readings: | How to Create and Maintain Databases and Tables with SQL Statements (Murach, Ch 10) |
| How to Use Management Studio for Database Design (Murach, Ch 11) |
| FYI: | Effective Database Application Design - a Reminder of the Fundamentals (Database Journal) |
| Untangling your Unruly Data (Computerworld) |
| What is Data Science? (O'Reilly) |
| |
| February 22nd (Wednesday) |
| Topic: | Exam One |
| |