jackmyers.info

Schedule for Databases

Monday Wednesday Weekend
Week of Lesson Topics Lesson Topics Work Due
5/22/2017 1 Introduction to Databases

Chapter 1: Databases and Database Users
Chapter 2: Database System Concepts and Architecture

Modeling our Movie Database in Access and Using the Query Wizard

2 Data Modeling

Chapter 3: Data Modeling Using the ER Model
Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm

Refining Access Database

Setting up MySQL Workbench

Read chapters 1-3
5/29/2017 Happy Memorial Day 2 Data Modeling

Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations

Building a ER Model of the National League East (exercise 3.22)

ASSIGNMENT DUE: Complete exercise 3.22 in the textbook. Upload your ER diagram and a Word file that states the assumptions you have made. For this exercise, you must use a Baseball team. You do not have to upload the Access file, as we will be modifying this in the next assignment.

Ready for Modeling Test
6/5/2017 3 Data Modeling, Keys and SELECT

Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL

Sakila and AdventureWorks queries

3 Keys and SELECT

Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL

Sakila and AdventureWorks queries

ASSIGNMENT DUE: Extending the NL East Model (exercise 4.30) then take your EER NL East Model and build it in MS Access including data. Upload the Access file and the EER diagram.
6/12/2017 4 From Basic to Advanced Queries

Section 6.3: Basic Retrieval Queries in SQL Chapter 7: More SQL...

More Sakila and AdventureWorks queries

4 Using Variables and Inner Joins

Section 7.1.6: Joined Tables in SQL and Outer Join

Using variables in Sakila
Joining Tables in Adventureworks

ASSIGNMENT DUE: AdventureWorks Basic SQL
6/19/2017 4 Aggregation Queries

Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses

emp/secretary/technician/janitor - from Hazel to Hank

Aggregation in AdventureWorks

5 Subqueries

Sections 7.1.2: Nested Queries

TBD

ASSIGNMENT DUE: JOINing in AdventureWorks
6/26/2017 5, 6 Subqueries
DDL and DML


Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE
Sections 6.1. 6.2 & 6.3: DDL, Data Types, Constraints, DML

TBD

7 Data Normalization

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB

TBD

ASSIGNMENT DUE: Aggregation in AdventureWorks

Ready for SQL Test
7/3/2017 Happy 4th of July Weekend 7 Data Normalization

Chapter 15: Relational DB Design Algorithms and Further Dependencies

TBD

ASSIGNMENT DUE: Subqueries in AdventureWorks
7/10/2017 8 Query Optimization

Chapter 18: Strategies for Query Processing

TBD

8 Query Optimization

Chapter 19: Query Optimization

TBD

7/17/2017 9 Programming at DB Level: Procedures and Triggers

Chapter 10: Introduction to SQL Programming Techniques

TBD

9 Programming at Web Server Level

Chapter 11: Web Database Programming Using PHP

TBD

PROJECT DUE: AdventureWorks on the Web (PHP)
7/24/2017 10 Hierachical, Network and NOSQL Databases — plus the CAP Theorem

Appendix D: Overview of the Hierarchical Data Model
Appendix E: Overview of the Network Data Model
Chapter 24: NoSQL DBs and Big Data Storage Systems

MongoDB

10, 11 NOSQL Databases
Neo4j: A Graph Database


Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

MongoDB, Neo4j

PROJECT DUE: MongoDB
7/31/2017 11 Neo4j: A Graph Database

O'Reilly Text: Neo4j

Neo4j

12 Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory

MongoDB

PROJECT DUE: Neo4j database
8/7/2017 No class 12 Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory

TBD


Chapter references from Fundamentals of Database Systems, 7th Edition, Ramez Elmasri & Shamkant B. Navathe, 2016.