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 Tables | ||||
| 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. 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. |
|
| 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 from the previous deck every time we meet. Also, all MPs are due at the beginning of class. |
|
| 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 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) |
|
| Wed 9/17 | SQL Nested and Union Queries, Having statement | Deck07 |
Read page 8 of the Intro to SQL | |
| Mon 9/22 | In class SQL Pratice | Deck08 |
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) |
|
| 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 |
-- |
Lab RRH 317 A GenAI allowed - Your own computer allowed |
|
| Wed 10/1 | MP4 intro: DigiSonos and UBC (individual) Data Modeling practice | Deck10 |
No Orange Words (you are welcome!) |
|
| Mon 10/6 | More Data Modeling practice | Deck11 |
No Orange Words (you are welcome!) | |
| Wed 10/8 | MP4 solutions feedback & MP5 intro: B2B data integration |
Deck12 |
No Orange Words. Due: MP4 - DigiSonos and UBC (individual) |
|
| Mon 10/13 | Reading day - no class | |||
| Wed 10/15 | Good DB designs: Normalization | Deck13 |
No orange words. | |
| Mon 10/20 | Good DB designs: Denormalization MP6 intro: Pressley |
Deck14 |
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 | ||||
| Wed 10/22 | BI: Operational DB vs. Data Warehouses | Deck15 |
Orange words from previous deck | |
| Mon 10/27 | DW architecture MP7 intro: REI_Not |
Deck16 |
Orange words from previous deck Due: MP6 - Pressley |
|
| Wed 10/29 | Star schemas for DWs | Deck17 |
Orange words from previous deck In class Demo |
|
| Mon 11/3 | DW Granularity and Snowflakes BI's last mile: pivot tables MP8 intro: Acme Global |
Deck18 |
Orange words from previous deck 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 |
No orange words Due: MP8 - Acme Global |
|
| Wed 11/12 | Building BI reports |
Deck21 |
Orange words from previous deck | |
| Mon 11/17 | Building BI reports II | Deck22 |
Orange words from previous deck Due: MP9 - Nolex |
|
| Wed 11/19 | MP10 intro: WWI | Deck23 |
Orange words from previous deck Navigating large DBs |
|
| Mon 11/24 | SQL practice: working with large databases | Deck24 |
Orange words from previous deck (if any) Practice queries with solutions (must unzip to use) |
|
| Wed 11/26 | Thanksgiving recess - no class - Happy Thanksgiving! | |||
| Part III : Managing Data | ||||
| Mon 12/1 | SQL practice: working with large databases | |
No more orange words ever! | |
| Wed 12/3 | Rescheduled! In-class SQL Test II - lab 230 in Shumway |
Deck24 | GenAI allowed - see Deck 24 for sample queries |
|
| Mon 12/8 | Consulting on Data | |
Guest Speaker Due on Tue 12/9 at 11:59pm: MP10 - WWI is here |
|