| First Week of Class Begins: | Monday, 10/19/2026 |
| Add without Instructor Permission by: | Sunday, 10/18/2026 |
| Last Day to Add with APC*: | Thursday, 10/29/2026 |
| Drop with Refund by: | Saturday, 10/24/2026 |
| Drop without "W" Grade by: | Thursday, 10/29/2026 |
| Drop with "W" Grade by: | Tuesday, 12/1/2026 |
| Last Week of Class Ends: | Wednesday, 12/16/2026 |
| Week Number |
Canvas Quizzes | Due Date Quizzes are Due Monday expire Wednesday |
Assignments** are Due Monday |
|---|---|---|---|
| 1st | orientation/intro quiz | Due Monday same week as tutorial.sql | Course Orientation, |
| 1st | Quiz 1 tutorial (10pts) | Special Expiration Saturday (i.e., 5 days Later) | submit tutorial.sql (10pts) |
| 2nd | Quiz 2 select.sql (10pts) | submit select.sql (10pts) | |
| 3rd | Quiz 3 intermediate (10pts) | submit intermediate.sql (20pts) | |
| 4 | Quiz 4 pmaIntro (10pts) |
submit pmaIntro.sql+ (11pts) | |
| 5 | Quiz 5 pmaView 1st 2 Video (10Pts) Crunch time begins next week, so do Chapter1 and pmaReset now. |
submit pmaView.sql, (15 pts) | |
| 6 | Chap 1 Quiz (20 pts) |
due same time as PMAReset, but A&B get it done sooner | Read Chapter 1 Discussion Board w SQL stay strong |
| 6 | Quiz 7 pmaReset (10 pts) DB Restore, and Intro Cloud (relatively easy assignment) |
submit - pmaReset.sql (12 pts) | |
| 7 | Quiz 8 pmaTrigger (20pts) | submit pmaTrigger.sql (15pts) | |
| 8 | Quiz 9 pmaRoutine (20Pts) Quiz10 pmaTransaction (20Pts) |
submit pmaRoutine.sql (12pts) and email - pmaReport (15pts) |
|
| C Grade Totals | 160 Pts *0.92 = 147 | 120 Pts *0.92 = 105 | |
| Table Below is Assignments/Quizzes A & B Student Must Complete | |||
| A | Quiz | Due Date/Quiz Expiration | You should complete up to and including pmaView.sql before starting the assignments and quizzes in this table. |
| 6 | Assignment Quiz One (20 pts) | submit p21.sql (10 pts) | |
| 6 | Chapter 2 (20 pts) | submit p58.sql (7 pts) | |
| 7 | Chapter 3 (20 pts) | submit p87.sql (10 pts) | |
| 7 | Chapter 4 (20 pts) | submit p125.sql (21 pts ) | |
| 8 | Chapter 5 (20 pts) | submit p157.sql (20 pts) | |
| 8 | Chapter 6 (20 pts) | submit p177.sql (15 pts ) | |
| 8 | Chapter 7 Extra Credit (10 bonus pts) | submit casinoNoJoin.sql (10 bonus points) | |
** For assignments, you may submit them late but they will be penalized. After due date you can complete the assignment in the next 7 days at a 25% penalty, after that the penalty is 50%. However last day of class is last day of class; For a logic oriented course you must complete work in order and at a steady pace. Both the material and assignments build on themselves. For on line courses if you snooze you loose.
+ pma is short for phpMyAdmin
++ Class officially ends Wednesday 08/12/ 11:59PM - Final Due date is 08/12/2026;