Schedule
See Calendar for due dates
| Activity | Due |
|---|---|
|
Lesson 01 -- Installation | |
|
Introduction Discussion Board |
Wednesday/Friday |
|
Reading – Chapter 1 |
Wednesday |
|
Reading – Chapter 2 |
Wednesday |
|
Introduction to Databases |
Friday |
|
Database 1 Tutorial |
Friday |
|
Orientation to Online Learning at BYU-Idaho |
Friday |
|
VMWare Instance Documentation |
Friday |
|
Exam 1 (Preparation) |
Friday |
|
Lab 1 - Oracle SQL*Plus |
Monday of Lesson 02 |
|
Oracle Exam 1 (one or both tries) |
Monday of Lesson 02 |
|
Lesson 02 -- Creating Tables | |
|
Reading – Chapter 3 |
Wednesday |
|
Reading – Chapter 4 |
Wednesday |
|
Exam 2 (Preparation) |
Friday |
|
Lab 2 – Table & Sequence – Oracle |
Monday of Lesson 03 |
|
Oracle Exam 2 (one or both tries) |
Monday of Lesson 03 |
|
Lesson 3 -- Modeling Data | |
|
Reading – Chapter 5 |
Wednesday |
|
Reading – Chapter 6 |
Wednesday |
|
Exam 3 (Preparation) |
Friday |
|
Lab 3 – Database Design | Monday of Lesson 04 |
|
Oracle Exam 3 (one or both tries) |
Monday of Lesson 04 |
|
Lesson 4 -- Inserting Data | |
|
Reading – Chapter 7 |
Wednesday |
|
Reading – Chapter 8 |
Wednesday |
|
Exam 4 (Preparation) |
Friday |
|
Lab 4 – Inserting Rows of Data |
Monday of Lesson 05 |
|
Oracle Exam 4 (one or both tries) |
Monday of Lesson 05 |
|
Lesson 5 -- SQL Joins & Complex SELECT Statements | |
|
Reading – Chapter 9 |
Wednesday |
|
Reading – Chapter 10 |
Wednesday |
|
Exam 5 (Preparation) |
Friday |
|
Lab 5 – Query Joined Data Sets |
Monday of Lesson 06 |
|
Oracle Exam 5 (one or both tries) |
Monday of Lesson 06 |
|
Lesson 6 -- Applied SQL – Part 1 | |
|
Reading – Chapter 11 |
Wednesday |
|
Exam 6 (Preparation) |
Friday |
|
Lab 6 – Integration |
Monday of Lesson 07 |
|
Lesson 7 -- Applied SQL – Part 2 | |
|
Lab 7 – Inserting Data Sets |
Monday of Lesson 08 |
|
Lesson 8 -- Applied SQL – Part 3 | |
|
Exam 6 (Preparation) |
Friday |
|
Lab 8 – Updating Correlated Sets |
Monday of Lesson 09 |
|
Oracle Exam 6 (one or both tries) |
Monday of Lesson 09 |
|
Lesson 09 -- Large Data Imports – Part 1 | |
|
Lab 9 – Maintenance SQL |
Monday of Lesson 10 |
|
Lesson 10 -- Large Data Imports – Part 2 | |
|
Reading – Chapter 12 |
Wednesday |
|
Lab 10 – ETL Merge Processing |
Monday of Lesson 11 |
|
Lesson 11 -- Large Data Imports – Part 3 | |
|
Lab 11 – Basic Aggregation Queries |
Monday of Lesson 12 |
|
Lesson 12 -- Selective Aggregation – Part 1 | |
|
Lab 12 – ETL 1:1 Processing |
Monday of Lesson 13 |
|
Vocabulary Preparation Test |
Monday of Lesson 13 |
|
Lesson 13 -- Selective Aggregation – Part 2 | |
|
Exam 4 (Preparation) |
Friday |
|
Lab 13 – LAMP Stack |
Monday of Lesson 14 |
|
Lesson 14 -- SQL Joins & Complex SELECT Statements | |
|
Final – Vocabulary Exam |
Monday |
|
Final Practice Query Exam 1 |
Tuesday |
|
Final Practice Query Exam 2 |
Tuesday |
|
Final Practice Query Exam 3 |
Tuesday |
|
Practice Final Exam |
Tuesday |
|
Oracle Final Exam (one or both tries) |
Last day of class |