jackmyers.info

Schedule for DB

Week of	Monday	Wednesday	Assignments
9/2	Labor 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 ASSIGNMENT DUE: 9/9 Getting setup for class
9/9	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: 9/16 Complete exercise 3.22 in the textbook. Upload your Chen-based ER diagram, a screen shot of the physical model from Access, the Access database you have created, and a Word file that states the assumptions you have made. For this exercise, you must use a Baseball team.
9/16	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 chapters 5, 6 Ready for Modeling Test
9/23	2. Data Modeling (final thoughts, if needed) MySQL Workbench: queries, table creation, data population, primary and foreign keys 3. Keys, SELECT and inner joins Chapter 5: The Relational Data Model and Relational DB Constraints	3. Keys, SELECT and inner joins Chapter 5: The Relational Data Model and Relational DB Constraints Section 6.3: Basic Retrieval Queries in SQL	Read chapter 10 ASSIGNMENT DUE: 9/30 Building a database for Research Papers Create the tables and constraints for a citation management system. Populate the tables. **ASSIGNMENT START You can begin the SQL Self Study Assignment(s)
9/30	3. SELECT, inner joins, variables 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. Database Programming Procedures/Functions/Triggers Chapter 10: Introduction to SQL Programming Techniques	Read chapter 7 TEST 1: Data Modeling
10/7	4. Database Programming PHP	5. Adv. SQL: Outer Joins, UNIONS, Section 7.1.6: Joined Tables in SQL and Outer Join Joining Tables in Adventureworks
10/14	5. Advanced Queries: Aggregation Queries Section 7.1.7: Aggregate Functions in SQL Section 7.1.8: Grouping: The GROUP BY and HAVING Clauses	6. Subqueries: Sections 7.1.2: Nested Queries	PROJECT DUE: 10/21 PHP — Research Paper System
10/21	6. Subqueries: Correlated Queries Sections 7.1.2: Nested Queries Sections 7.1.3 - 7.1.4: Correlated Queries, EXISTS/UNIQUE Subqueries in AdventureWorks	7. NoSQL, CAP Theorem, Intro to MongoDB Chapter 24: NoSQL DBs and Big Data Storage Systems	TEST 2: SQL
10/28	7. MongoDB	8. Normalization Intro to Funct. Dependencies Chapter 14: Basics of Functional Dependencies and Normalization for Relational DB	Read Chapter 14
11/4	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 PROJECT DUE: 11/11 MongoDB
11/11	8. Normalization BCNF, higher forms	9. Views Section 29.6 Data Warehouse vs. Views	ASSIGNMENT DUE: 11/18 Views, Materialized Views and Triggers
11/18	test	10. Performance: Indexes Chapter 17: Indexing Structures for Files and Physical DB design	Read Chapter 18
11/25	10. Performance: Indexes and 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
12/2	12. Transactions and Locking Chapter 20: Introduction to Transaction Processing Concepts and Theory	12. Transactions and Locking Chapter 20: Introduction to Transaction Processing Concepts and Theory	PROJECT DUE: Neo4j database
12/9	13. DB Security Chapter 30: Database Security	Finals Week