COMM 3220 - Course Schedule
DATE | TOPICS | DECKS | HOMEWORK DUE (Draft) |
Wed Aug 23 |
Welcome to the course! DBMSs and BI in Business |
Deck 01 |
Browse this web site. Bring to class any questions you might have. Check your email. I am sending you a link to join the class Teams chat. |
PART I | RELATIONAL DATABASES | |
|
Mon Aug 28 | SQL: accessing single tables Intro to MP1: Smallbank (A) Tools: ADS |
Deck 02 | Review the Aug 23rd deck (orange words). Read the first two (web)pages of the SQL intro by the WWW Schools Skim the first 5 pages of my Intro to SQL |
Wed Aug 30 | Data modeling with ERD Intro to MP2: Notflix |
Deck 03 | Review the previous deck Watch the Intro to DBs and ERDs Watch the ERD tutorial |
Mon Sept 4 | ERD: Foreign keys Tool: Draw.IO |
Deck 04 | DUE: Miniproject MP1 (SmallBank A) Review the previous deck Watch the Draw.io tutorial |
Wed Sept 6 | SQL: Joins | Deck 05 | Review the previous deck Read page 6-7 of the Intro to SQL |
Mon Sept 11 | SQL: Joins practice Intro to MP3: SmallBank (B) |
Deck 06 | DUE: Miniproject MP2 (single or pairs: Notflix) Review the previous deck Optional: connect to the DMBS at the beginning of class to follow the in-class practice (no time to help you connect while in class). Practice queries done in class download the .zip file, then unzip it, then open it with ADS. |
Wed Sept 13 | SQL: Nested queries & Union Queries | Deck 07 | Review the previous deck |
Mon Sept 18 | Business database design practice Intro to MP4: An ERD for B2B |
Deck 08 | DUE: Miniproject MP3 (SmallBank B) Review the previous deck |
Wed Sept 20 | More business database design practice | Deck 09 | Watch the MySQL Workbench tutorial |
Mon Sept 25 | In class SQL Test 1 | No Deck | RRH 317B (3rd floor lab) |
Wed Sept 27 | SQL: Tables and data creation, update and deletion | Deck 10 | Read all remaining pages of the Intro to SQL |
Sep 30 - Oct 3 Fall reading days |
|
||
Wed Oct 4 |
DB integration Intro to MP5: Team ERD |
Deck 11 | Bring an extra copy of your Miniproject 4: we will discuss solutions and take notes. DUE: Miniproject 4 (Database for B2B). |
Mon Oct 9 |
Good DB designs: Normalization | Deck 12 |
Nothing due (you are welcome) |
PART II | BUSINESS INTELLIGENCE | |
|
Wed Oct 11 |
Good DB designs: Denormalization Intro to MP6: Pressly Ad Agency |
Deck 13 |
DUE: Miniproject 5 (Team ERD) Solutions to MP4 are posted in Teams Review the previous deck |
Mon Oct 16 | BI: Data Warehouses (DW) and Data Lakes (DL) | Deck 14 | Review the previous deck |
Wed Oct 18 | Star schema for Data Warehouses | Deck 15 | DUE: Miniproject 6 (Pressly Ad) Review the previous deck |
Mon Oct 23 | Building a Star or a Snowflake schema Intro to MP7: REI_not |
Deck 16 | Review the previous deck |
Wed Oct 25 | Granularity | Deck 17 | Review the previous deck |
Mon Oct 30 | Using DW for decision making: Pivot tables Intro to MP8: Acme Global |
Deck 18 | DUE: Miniproject 7 (DW
at REI_not) Review the previous deck Optional: Watch the refresher for Pivot Tables |
Wed Nov1 | Extract, Transform & Load workflows Tool: Power BI |
Deck 19 | Review the previous deck |
Mon Nov 6 | Data wrangling Intro to MP9: Nolex |
Deck 20 | DUE: Miniproject 8 (Variance analysis at ACME) |
Wed Nov 8 | Intro to SQL test: WWI |
Deck 21 | Watch: Power
BI tutorial (first 33 minutes) Watch: IMDB demo (3 min) Data dictionaries: Link1 Link2 |
Mon Nov 13 | Interrogating DWs with SQL Intro to MP10 |
Deck 22 (quiz prep) |
DUE: Miniproject 9 (Data wrangling at Nolex) |
Wed Nov 15 | SQL Test 2 will take place in the 3rd floor lab |
No deck | Bring your laptop if you prefer to work on it. |
Mon Nov 20 | ERD refresh: identifying and non -identifying, etc. Tool: Power Pivot | Deck 23 | |
Nov 22 - Nov 26 Thanksgiving recess |
|
||
PART III | MANAGING DATA | |
|
Mon Nov 27 | Advanced Topics: Generative AI |
Deck 24 | Read: Exploring opportunities in the generative AI value chain Navigating the New Risks and Regulatory Challenges of GenAI How you would answer a job-interview (or a first-day-on-the-job) question: "How do you think AI can affect our business?" Prepare an answer that will make a good impression. |
Wed Nov 29 | Data quality | No deck | Guest speaker: J. Duncan from CarMax |
Mon Dec 4 | Data Management |
No deck | DUE Miniproject 10 (BI
at WWI) Guest speaker: P. Carr, CapTech |