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 |
Deck03 |
Review Deck02 and prep for the orange words Watch the Intro to DBs and ERDs |
|
| Thu 09/03 | Placing foreign keys correctly MP2 intro: Notflix Tool: Draw.IO |
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. Watch the ERD tutorial and the Keys Tutorial. |
|
| Tue 09/08 | SQL Joins | Deck05 |
Read page 6-8 of the Intro to SQL Make sure you understand the SQL you wrote for MP1 - you may be ask to explain it in class |
|
| Thu 09/10 | SQL Types of Joins MP3 intro: SmallBank (B) |
Deck06 |
Due: MP2 - Notflix Note: there are no orange words from deck 05 (you are welcome). |
|
| Tue 09/15 | SQL Nested and Union Queries, Having statement | Deck07 |
Read page 8 of the Intro to SQL | |
| Thu 09/17 | In class SQL Practice | 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) |
|
| Tue 09/22 | In class 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). Reminder: I might ask you to explain one of your MP3 queries. |
|
| Thu 09/24 | In-class SQL Test I |
-- |
Lab RRH 317 A for the 12:30 section. GenAI allowed - Your own computer allowed |
|
| Tue 09/29 | MP4 intro: DigiSonos and UBC (individual) Data Modeling practice | Deck10 |
No Orange Words (you are welcome!) |
|
| Thu 10/01 | More Data Modeling practice | Deck11 |
No Orange Words (you are welcome!) | |
| Reading day - no class | ||||
| Thu 10/08 | MP4 solutions feedback & MP5 intro: B2B data integration |
Deck12 |
No Orange Words. Due: MP4 - DigiSonos and UBC (individual) |
|
| Tue 10/13 | Good DB designs: Normalization | Deck13 |
No orange words. | |
| Thu 10/15 | Good DB designs: Denormalization MP6 intro: Pressley |
Deck14 |
Orange words are back! Due (ideal): 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 | Business Intelligence: Operational DB vs. Data Warehouses |
Deck15 |
Due (also fine - no penalty - if you could not meet the 10/15 deadline): MP5
- B2B data integration (team) Orange words from previous deck |
|
| Thu 10/22 | Building and using a DW for BI: the REI not case |
Deck16 |
Orange words from previous deck |
|
| Tue 10/27 | DW architecture: Star schemas for DWs (MP7 Intro) |
|
There are no orange words from previous deck (you are welcome) Due: MP6 - Pressly |
|
| Thu 10/29 | DW Granularity and Snowflakes BI's last mile: pivot tables |
|
Orange words from previous deck |
|
| Thu 11/05 | BI workflows: PowerBI MP8 intro: Acme Global |
|
Orange words from previous deck Due: MP7 - REI_Not |
|
| Tue 11/10 | Data wrangling | |
Orange words from previous deck |
|
| Thu 11/12 | Building BI reports MP9 intro- Nolex |
|
Orange words from previous deck Due: MP8 - Acme Global |
|
| Tue 11/17 | Building BI reports II | |
Orange words from previous deck |
|
| Thu 11/19 | MP10 intro: WWI | Orange words from previous deck Navigating large DBs Due: MP9 - Nolex |
||
| 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.