Contents
Work to do
| Date | Topic | Deck | How to prepare & Homework due | |
|---|---|---|---|---|
| Tue 08/25 | Welcome to DM4DM! | Deck01 |
Browse this web site. Bring to class any questions you might have. | |
| Part I : Working with Relational Tables | ||||
| Thu 08/27 | Accessing single tables with SQL Tool: VS Code MP1 intro: SmallBank (A) |
Deck02 |
Review Deck01 and prep for the orange words Read the SQL intro by the WWW Schools. Try the green "try it yourself" button. Read the first 5 pages of my Intro to SQL Check your email for a link to join the class MS Teams chat. |
|
| Tue 09/01 | Organizing business data Tool: ERD, Draw.IO |
Review Deck02 and prep for the orange words Watch the Intro to DBs and ERDs Watch the ERD tutorial |
||
| Thu 09/03 | Placing foreign keys correctly MP2 intro: Notflix |
Due: MP1 - Smallbank (A) From now on, review the orange words from the previous deck every time we meet. Also, all MPs are due at the beginning of class. |
||
| Tue 09/08 | SQL Joins | |
Read page 6-8 of the Intro to SQL | |
| Thu 09/10 | SQL Joins practice MP3 intro: SmallBank (B) |
|
Due: MP2 - Notflix Note: there are no orange words from deck 05 (you are welcome). Optional: connect to SmallBankDB at the beginning of class to follow the in-class practice (no time to help you connect while in class) |
|
| Tue 09/15 | SQL Nested and Union Queries, Having statement | |
Read page 8 of the Intro to SQL | |
| Thu 09/17 | In class SQL Pratice | |
Due: MP3 - Smallbank (B) Optional: connect to SmallBankDB at the beginning of class to follow the in-class practice (no time to help you connect while in class) |
|
| Tue 09/22 | SQL Practice | |
Optional: connect to SmallBankDB at the beginning of class to follow the in-class practice (no time to help you connect while in class) | |
| Thu 09/24 | In-class SQL Test I |
-- |
Lab RRH 317 A GenAI allowed - Your own computer allowed |
|
| Tue 09/29 | MP4 intro: DigiSonos and UBC (individual) Data Modeling practice | |
No Orange Words (you are welcome!) |
|
| Thu 10/01 | More Data Modeling practice | |
No Orange Words (you are welcome!) | |
| Thu 10/08 | MP4 solutions feedback & MP5 intro: B2B data integration |
No Orange Words. Due: MP4 - DigiSonos and UBC (individual) |
||
| Reading day - no class | ||||
| Tue 10/13 | Good DB designs: Normalization | |
No orange words. | |
| Thu 10/15 | Good DB designs: Denormalization MP6 intro: Pressley |
|
Orange words are back! Due: MP5 - B2B data integration (team) Read all remaining pages of the Intro to SQL Learn about Create Table, Alter Table, and Delete Table in W3 |
|
| Part II : Business Intelligence and Data Warehousing | ||||
| Tue 10/20 | BI: Operational DB vs. Data Warehouses | |
Orange words from previous deck | |
| Thu 10/22 | DW architecture MP7 intro: REI_Not |
|
Orange words from previous deck Due: MP6 - Pressley |
|
| Tue 10/27 | Star schemas for DWs | |
Orange words from previous deck In class Demo |
|
| Thu 10/29 | DW Granularity and Snowflakes BI's last mile: pivot tables MP8 intro: Acme Global |
|
Orange words from previous deck Due: MP7 - REI_Not |
|
| Thu 11/05 | BI workflows: PowerBI |
|
Orange words from previous deck | |
| Tue 11/10 | Data wrangling MP9 intro- Nolex |
|
No orange words Due: MP8 - Acme Global |
|
| Thu 11/12 | Building BI reports |
|
Orange words from previous deck | |
| Tue 11/17 | Building BI reports II | |
Orange words from previous deck Due: MP9 - Nolex |
|
| Thu 11/19 | MP10 intro: WWI | Orange words from previous deck Navigating large DBs |
||
| Tue 11/24 | SQL practice: working with large databases | |
Orange words from previous deck (if any) Practice queries with solutions (must unzip to use) |
|
| Thanksgiving recess - Happy Thanksgiving! | ||||
| Part III : Managing Data | ||||
| Tue 12/01 | SQL practice: working with large databases | |
No more orange words ever! | |
| Thu 12/03 | Tentative date In-class SQL Test II - lab 230 in Shumway |
|
GenAI allowed - see Deck 24 for sample queries |
|
| Tue 12/08 | Consulting on Data | |
Guest Speaker Due on Tue 12/9 at 11:59pm: MP10 - WWI is here |
|
The 'work to do' may be modified to fit the class needs.