Contents
Work to do
| Date | Topic | Deck | How to prepare & Homework due | |
|---|---|---|---|---|
| Wed 8/27 | Welcome to DM4DM! | Deck01 | Browse this web site. Bring to class any questions you might have. | |
| Part I : Working with Relational | ||||
| Mon 9/1 | Accessing single tables with SQL Tool: ADS MP1 intro: Smallbank (A) |
Deck02 |
Review Deck01 and prep for the orange words Read the SQL intro by the WWW Schools Read the first 5 pages of my Intro to SQL Check your email for a link to join the class MS Teams chat |
|
| Wed 9/3 | Organizing business data Tool: ERD, Draw.IO |
Deck03 |
Review Deck02 and prep for the orange words Watch the Intro to DBs and ERDs Watch the ERD tutorial |
|
| Mon 9/8 | Placing foreign keys correctly MP2 intro: Notflix |
Deck04 |
Due: MP1 - Smallbank (A) From now on, review the orange words every time we meet |
|
| Wed 9/10 | SQL Joins | Deck05 |
Read page 6-8 of the Intro to SQL | |
| Mon 9/15 | SQL Joins practice MP3 intro: SmallBank (B) |
Deck06 |
Due: MP2 - Notflix Optional: connect to SmallBankDB at the beginning of class to follow the in-class practice (no time to help you connect while in class) |
|
| Wed 9/17 | SQL Nested and Union Queries, Having statement | Deck07 |
Read page 8 of the Intro to SQL | |
| Mon 9/22 | SQL Partitions In-class SQL intro |
Deck08 |
Due: MP3 - Smallbank (B) Ask your GenAI what is an SQL partition and to show a few examples | |
| Wed 9/24 | SQL Practice | Deck09 |
Optional: connect to SmallBankDB at the beginning of class to follow the in-class practice (no time to help you connect while in class) | |
| Mon 9/29 | In-class SQL Test I |
GenAI allowed | ||
| Wed 10/1 | MP4 intro: DigiSonos and UBC (individual) Business design practice |
Deck10 |
Orange words from Deck09 |
|
| Mon 10/6 | SQL: Tables and data creation, update and deletion | Deck11 |
Read all remaining pages of the Intro
to SQL Learn about Create Table, Alter Table, and Delete Table in W3 |
|
| Wed 10/8 | MP5 intro: B2B data integration MP4 solutions feedback |
Deck12 |
Due: MP4 - DigiSonos and UBC (individual) | |
| Mon 10/13 | Reading day - no class | |||
| Wed 10/15 | Good DB designs: Normalization | Deck13 |
Orange words from previous deck | |
| Mon 10/20 | Good DB designs: Denormalization MP6 intro: Pressly |
Deck14 |
Due: MP5 - B2B data integration (team) | |
| Part II : Business Intelligence and Data Warehousing | ||||
| Wed 10/22 | BI: Operational DB vs. Data Warehouses | Deck15 |
Orange words from previous deck | |
| Mon 10/27 | Star schemas for DWs MP7 intro REI_Not |
Deck16 |
Due: MP6 - Pressly | |
| Wed 10/29 | DW design: granularity |
Deck17 |
Orange words from previous deck | |
| Mon 11/3 | BI's last mile: pivot tables MP8 intro: Acme Global |
Deck18 |
Due: MP7 - REI_Not | |
| Wed 11/5 | BI workflows: PowerBI |
Deck19 |
Orange words from previous deck | |
| Mon 11/10 | Data wrangling MP9 intro- Nolex |
Deck20 |
Due: MP8 - Acme Global | |
| Wed 11/12 | Building BI reports |
Deck21 |
Orange words from previous deck | |
| Mon 11/17 | In class SQL test intro: WWII |
|
Due: MP9 - Nolex | |
| Wed 11/19 | SQL pratice: working with large databases | |
Orange words from previous deck | |
| Mon 11/24 | In-class SQL Test II |
|
GenAI allowed | |
| Wed 11/26 | Thanksgiving recess - no class | |||
| Part III : Managing Data | ||||
| Mon 12/1 | MP10 intro: WWI | |
Orange words from previous deck | |
| Wed 12/3 | Consulting on Data | |
Guest Speaker | |
| Mon 12/8 | Tools for your career | |
Due: MP10 - WWI | |