jackmyers.info

Schedule for DB

Week of (Mon) Monday Wednesday Assignments
1/21 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/28 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: 2/5
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.
2/4 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

ASSIGNMENT DUE: 2/17
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/11

MySQL Workbench, Sakila and AdventureWorks queries


3. Keys and SELECT
Chapter 5: The Relational Data Model and Relational DB Constraints
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
Read Chapter 7

ASSIGNMENT DUE: 2/14
Dominic's University (an EER challenge)
2/18 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

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

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

Section 7.1.6: Joined Tables in SQL and Outer Join

Joining Tables in Adventureworks

4. Advanced Queries:
    Aggregation Queries

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

ASSIGNMENT DUE: 3/5
JOINing in AdventureWorks
3/4 5. Subqueries and Views:
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




Ready for SQL / Keys Test
ASSIGNMENT DUE:
Aggregation in AdventureWorks
3/11 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: Procedures and Triggers

Chapter 10: Introduction to SQL Programming Techniques
Read Chapters 10, 11

ASSIGNMENT DUE:
Subqueries in AdventureWorks
3/18 Spring Break
3/25 7. Database Programming
    Web Server Level: PHP

Chapter 11: Web Database Programming Using PHP

Getting PHP to work on elvis

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 14

4/1 8. Normalization
    Funct. Dependencies, 1NF, 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
Read Chapter 24
4/8 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
9. NoSQL: MongoDB
Chapter 24: NoSQL DBs and Big Data Storage Systems

MongoDB

PROJECT DUE: PHP — AdventureWorks and Sakila on the Web
4/15 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 18

PROJECT DUE: MongoDB
4/22 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
Read Chapter 20

PROJECT DUE: Neo4j database
4/29 12. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory
13. DB Security
Chapter 30: Database Security
5/6 Finals Week Finals Week


Modified: