Tentative Schedule CIM205A SQL/MySQL Last Updated: |
||
| Week | Description | Chapter |
|---|---|---|
| 1 | Read Syllabus and Review Class Website. | |
| 2-5 | Complete the following assignments: questionnarie, tutorial.sql, fruitcmds.sql, phpMyAdmin and select.sql. Blackboard has full set of videos on completing these assignments. You will also have to complete the pre Chapter 1 quizzes, Quizzes are listed in order that they should be taken. The book is relatively easy to read once you have completed the five intro assignments (questionnaire..select.sql). |
|
| 6 | Read Chapter 1 Introduction to Premiere Products, We will only be using the Premiere Database Take Quiz1 and do assignment 1. Note assignment and quiz numbers correspond to chapter number, |
1 |
| 8 | Read Chapter 2 Database Design Fundamentals Take Quiz 2 and Complete Assignment 2 | 2 |
| 10 | Read Chapter 3 An Introduction to SQL take blackboard Quiz 3 and complete assignment 3 | 3 |
| 12 | Read Chapter 4: Single Table Queries Take Quiz 4 and complete assignment 4 | 4 |
| 14 | Read Chapter 5: Multiple-Table Queries Take Quiz 5 and complete assignment 5 | 5 |
| 15 | Read Chapter 6: Updating Data Take Quiz 6 and complete assignment 6 | 6 |
| 16 | Tentative Extra Credit...
|
|