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: Feb 5th
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 Tally Modeling


Chapter 3: Data Modeling Using the ER Model (n-ary relationships)
Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm
2. Data Modeling
Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm
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: Feb 12th
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: 2/26
AdventureWorks Basic SQL
2/26 4. Advanced Queries:
    Aggregation Queries

Section 7.1.7: Aggregate Functions in SQL
Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses
5. Subqueries and Views:
Sections 7.1.2: Nested Queries
ASSIGNMENT DUE: 3/5
JOINing in AdventureWorks

Ready for SQL / Keys Test
3/5 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


   SNOW DAY
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

Read Chapters 10, 11

ASSIGNMENT DUE: 3/19
: Aggregation in AdventureWorks
3/12 Spring Break
3/19 7. Database Programming
    DB Level: Procedures and 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: 3/26
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
8. Normalization
    Funct. Dependencies, 1NF, 2NF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
Read Chapter 24
4/2 8. Normalization
    3NF to BCNF

Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB
8. Normalization
    BCNF review

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

MongoDB

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

MongoDB

Read Chapter 18
4/16 10. Performance: Indexes
Chapter 17: Indexing Structures for Files and Physical DB design
10. Performance: Explain
Chapter 17: Indexing Structures for Files and Physical DB design

11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems
O'Reilly Text: Neo4j

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 EXAM Schedule:

Class Begin Time - 02:45 PM
Class End Time - 04:45 PM
Finals Week



Modified: