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