jackmyers.info
Schedule for DB
| Week of (Mon) | Monday | Wednesday | Assignments | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9/2 | Labor Day |
1. Introduction to Databases
|
|||||||||
| 9/9 | 2. Data Modeling
Chapter 3: Data Modeling Using the ER Model Quiz on ER Modeling (Chapter 3) Practicing with Section Tally |
2. Data Modeling
Chapter 3: Data Modeling Using the ER Model Practice exercises on ER modeling |
ASSIGNMENT (See due dates in Canvas) Baseball Modeling A database is being constructed to keep track of the teams and games of a baseball sports league. A team has a number of players, not all of whom participate in each game. It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER schema diagram for this application, stating any assumptions you make. |
||||||||
| 9/16 |
2. Data Modeling Section 9.1: Relational DB Design Using ER-Relational Mapping Algorithm Converting ER diagrams to physical models |
2. Data Modeling
Chapter 4: The Enhanced ER (EER) Model Section 9.2: Mapping EER Model Constructs to Relations |
PROJECT Part 1 (See due dates in Canvas) Graded with final project. Building a database for a Fitness Application Database creation Create the tables and constraints for a fitness application. Populate the tables. |
||||||||
| 9/23 |
3. Keys, SELECT and inner joins
Chapter 5: The Relational Data Model and Relational DB Constraints Section 6.3: Basic Retrieval Queries in SQL |
4. Outer joins and UNIONs
Section 7.1.6: Joined Tables in SQL and Outer Join |
TEST 1: Data Modeling PROJECT Part 2 (See due dates in Canvas) Graded with final project SQL against an inheritant database |
||||||||
| 9/30 | 5. Database Programming Procedures/Functions Chapter 10: Introduction to SQL Programming Techniques |
5. Database Programming Triggers Chapter 10: Introduction to SQL Programming Techniques |
|||||||||
| 10/7 | 5. Database Programming PHP |
6. Aggregation and Windows Functions Aggregation Queries Section 7.1.7: Aggregate Functions in SQL Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses |
PROJECT Part 3: (See due dates in Canvas) Graded with final project. Database programming PHP — Fitness Application |
||||||||
| 10/14 | 7. NoSQL, CAP Theorem, Intro to MongoDB Chapter 24: NoSQL DBs and Big Data Storage Systems |
7. MongoDB
|
ASSIGNMENT (See due dates in Canvas) MongoDB |
||||||||
| 10/21 | 7. MongoDB: 8. Subqueries: Sections 7.1.2: Nested Queries |
8. Subqueries: Correlated Queries Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4 : Correlated Queries, EXISTS/UNIQUE Subqueries in AdventureWorks |
|||||||||
| 10/28 | TBD | TEST 2: SQL | |||||||||
| 11/4 | 9. Normalization Intro to Funct. Dependencies Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
9. Normalization Funct. Dependencies, 1NF, 2NF Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
|||||||||
| 11/11 | 9. Normalization 3NF to BCNF
Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB |
9. Normalization BCNF, higher forms
|
|||||||||
| 11/18 | 10. Views Section 29.6 Data Warehouse vs. Views |
Thanksgiving |
PROJECT Part 4: (See due dates in Canvas) Graded with final project. Materialized Views Views, Materialized Views and Triggers |
||||||||
| 11/25 | 11. NoSQL: Neo4j a Graph DB
Chapter 24: NoSQL DBs and Big Data Storage Systems O'Reilly Text: Neo4j Neo4j |
12. Performance: Indexes and Explain
Chapter 17: Indexing Structures for Files and Physical DB design |
ASSIGNMENT (See due dates in Canvas) Neo4j |
||||||||
| 12/2 | 13. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory |
13. Transactions and Locking
Chapter 20: Introduction to Transaction Processing Concepts and Theory |
|||||||||
| 12/9 | 14. DB Security
Chapter 30: Database Security |
Reading Day |