jackmyers.info

Schedule for DB

Week of Monday Wednesday Assignments
1/15 MLK Day 1. Introduction to Databases
2. Data Modeling


Modeling our Movie Database in Access and Using the Query Wizard


Chapter 3: Data Modeling Using the ER Model
Read chapters 3, 4
1/22 2. Data Modeling

Chapter 3: Data Modeling Using the ER Model
2. Data Modeling

Section Tally Modeling


Chapter 3: Data Modeling Using the ER Model
Read chapter 9

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.
1/29 2. Data Modeling
Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm
Chapter 4: The Enhanced ER (EER) Model
2. Data Modeling
Chapter 4: The Enhanced ER (EER) Model
Section 9.2: Mapping EER Model Constructs to Relations
Read Chapter 5

Ready for Modeling Test
2/5 2. Data Modeling
(final thoughts, if needed)

MySQL Workbench, Sakila and AdventureWorks queries


3. Keys and SELECT
Chapter 5: The Relational Data Model and Relational DB Constraints
3. Keys and SELECT
Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL
Read Chapter 7

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.
2/12 3. Keys and SELECT

MySQL Workbench, Sakila and AdventureWorks queries


Chapter 5: The Relational Data Model and Relational DB Constraints
Section 6.3: Basic Retrieval Queries in SQL
4. Advanced Queries:
    Variables and Inner Joins

Chapter 7: More SQL...
Section 7.1.6: Joined Tables in SQL and Outer Join

Using variables in Sakila
Basic Queries in Adventureworks

2/19 4. Advanced Queries:
    Inner Joins

Chapter 7: More SQL...
Section 7.1.6: Joined Tables in SQL and Outer Join

Using variables in Sakila
Joining Tables in Adventureworks

4. Advanced Queries:
    Outer Joins, Unions

Section 7.1.6: Joined Tables in SQL and Outer Join

Joining Tables in Adventureworks

Read Chapter 6

ASSIGNMENT DUE: AdventureWorks Basic SQL
2/26 4. Advanced Queries:
    Outer Joins, Unions,
    Aggregation Queries

Section 7.1.6: Joined Tables in SQL and Outer Join
Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
4. Advanced Queries:
    Aggregation Queries

Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
ASSIGNMENT DUE: JOINing in AdventureWorks

Ready for SQL / Keys Test
3/5 5. Subqueries and Views:
    Introduction

Sections 7.1.2: Nested Queries
5. Subqueries and Views:
    Correlated Queries

Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE

Subqueries in AdventureWorks


Read Chapters 10, 11

ASSIGNMENT DUE: Aggregation in AdventureWorks
3/12 Spring Break
3/19 6. DDL and DML
Sections 6.1, 6.2 & 6.3: DDL, Data Types, Constraints,
7. Database Programming
    DB Level: Procedures

Chapter 10: Introduction to SQL Programming Techniques

7. Database Programming
    DB Level: Triggers

Chapter 10: Introduction to SQL Programming Techniques
7. Database Programming
    Web Server Level: PHP

Chapter 11: Web Database Programming Using PHP

Getting PHP to work on elvis

Read Chapter 14

ASSIGNMENT DUE: Subqueries in AdventureWorks
3/26 7. Database Programming
    Web Server Level: PHP

Chapter 11: Web Database Programming Using PHP
8. Normalization
    Intro to Funct. Dependencies

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
Read Chapter 24
4/2 8. Normalization
    More FDs, 1NF to 2NF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
8. Normalization
    3NF to BCNF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
PROJECT DUE: PHP — AdventureWorks and Sakila on the Web
4/9 9. NoSQL, CAP Theorem
Chapter 24: NoSQL DBs and Big Data Storage Systems

MongoDB

9. NoSQL: Mongo
Chapter 24: NoSQL DBs and Big Data Storage Systems

MongoDB

Read Chapter 18
4/16 9. NoSQL: Mongo
Chapter 24: NoSQL DBs and Big Data Storage Systems

MongoDB

10. Performance:
      Query Optimization

Chapter 18: Strategies for Query Processing

Neo4j

Read Chapter 20

PROJECT DUE: MongoDB
4/23 11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

Neo4j

12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
PROJECT DUE: Neo4j database
4/30 Finals Week Finals Week



Modified: