jackmyers.info

Schedule for Databases

Monday Tuesday Wednesday Thursday Weekend
Week of Lesson Topics Lesson Topics Lesson Topics Lesson Topics Work Due
6/27/2016 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 2: Database System Concepts and Architecture 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

2 Data Modeling

Chapter 3: Data Modeling Using the ER Model
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)

3 Data Modeling, Keys and SELECT

Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations
Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL

Sakila and AdventureWorks queries

ASSIGNMENT DUE: Happy July 4th, but READ the chapters
7/4/2016 4th of July 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

4 From Basic to Advanced Queries

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

More Sakila and AdventureWorks queries

5 DDL and DML

Sections 6.1. 6.2 & 6.3

TBD

ASSIGNMENT DUE: Extending the NL East Model (exercise 4.30) then take your EER NL East Model and build it in MS Access. Upload the Access file and the EER diagram.:
7/11/2016 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

4 Aggregation Queries:

Section 7.1.7: Aggregate Functions in SQL

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

4 Aggregation Queries

Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses

Aggregation in Advenure Works

5 Subqueries

Sections 7.1.2: Nested Queries

TBD

ASSIGNMENT DUE:
7/11/2016 6 Subqueries
Data Normalization


Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB

TBD

6 Data Normalization

Chapter 15: Relational DB Design Algorithms and Further Dependencies

TBD

7 Query Optimization

Chapter 18: Strategies for Query Processing

TBD

7 Query Optimization

Chapter 19: Query Optimization

TBD

ASSIGNMENT DUE:
7/18/2016 8 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

9 Programming at Web Server Level

Chapter 11: Web Database Programming Using PHP

TBD

10 Java EE and Java Persistence API


TBD

ASSIGNMENT DUE:
7/25/2016 11 Hierachical, Network and NOSQL Databases

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

11 NOSQL Databases

Chapter 24: NOSQL DBs and Big Data Storage Systems

MongoDB

12 Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory
Chapter 21: Concurrency Control Techniques

MongoDB

13 Transactions and Locking

Chapter 20: Introduction to Transaction Processing Concepts and Theory
Chapter 21: Concurrency Control Techniques

TBD

ASSIGNMENT DUE:


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