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 |
4. Advanced Queries: Inner Joins Chapter 7: More SQL... Section 7.1.6: Joined Tables in SQL and Outer Join Using variables in Sakila |
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 |