Tentative Schedule for ITMG 320 Spring 2023
note subject to change
USD FINAL EXAM SCHEDULE Spring_2023
| Date | TOPIC | READINGS | ASSIGNMENT | ||
| tue | 31 | jan | Introduction to Class, database, import data, access | INTRO PDF 1,2, DBD CH 1, CH 2 | |
| tue | 7 | feb | introduction to the relational database model | DBD CH3, CH4 | assignment 1, 2 |
| tue | 14 | feb | databasea design, normalization, entity relationship diagram | DBD CH5, CH6 | assignment 3,4 |
| tue | 21 | feb | QBE, simply queries | DBD CH7, CH8 | assignment 5,6 |
| tue | 28 | feb | QBE advanced queries, EXAM ONE | DBD CH9, CH10 | assignment 7 |
| tue | 7 | mar | NO CLASS SPRING BREAK | NO CLASS SPRING BREAK | NO CLASS SPRING BREAK |
| tue | 14 | mar | SQL, Create, insert, drop, select, in exact match | SQL working packet 1, DBD CH11 | |
| tue | 21 | mar | SQL sort calculate, two tables, aggregrates | SQL working packet 1, DBD CH12 | asignment 8,9 |
| tue | 28 | mar | SQL aggrgrates two, JOINS, subqueries, nested queries | SQL working packet 1 DBD CH 13 | assignemnt 10, 11 |
| tue | 4 | apr | SQL triggers, forms, views, injections, IIS | SQL working packet 2 | assignment 12, 13 |
| tue | 11 | apr | SQL Error Handling, Exam Review/Practive | SQL working packet 2 | assignemnt 14,15 |
| tue | 18 | apr | EXAM TWO | ||
| tue | 25 | apr | Data Warehousing | DBD ch 14 | |
| tue | 2 | may | related specializations and techniques | DBD ch 15 | assignment 16 |
| tur | 9 | may | Lasr Day of Class /WORK Session | ||