| -- IT 125 -- |
|---|
| Introduction To SQL Using MySQL |
| Lab Assignments |
|
|
| Following are the Lab and Extra Credit Assignments for IT 125: |
|---|
| Link To All Available Extra Credit Below |
|
Lab 1
Due by Week 2 |
| MySQL and MySQL Workbench Install |
| Return to IT 125 Syllabus |
|
|
Lab 2
Due by Week 3 |
| Create A MySQL Table |
| Return to IT 125 Syllabus |
|
|
|
Lab 3
Due by Week 4 |
| Creating Simple and Advanced Queries |
| Return to IT 125 Syllabus |
|
|
|
Lab 4
Due by Week 5 |
| Creating Simple and Advanced Joins |
| Return to IT 125 Syllabus |
|
|
|
Lab 5
Due by Week 6 |
| Modifying Tables and Cleanup |
| Return to IT 125 Syllabus |
|
|
|
Lab 6
Due by Week 7 |
| Creating an ERD |
| Return to IT 125 Syllabus |
|
|
|
Lab 7
Due by Week 8 |
| Summary Queries, Subqueries and CTE |
| Return to IT 125 Syllabus |
|
|
|
Lab 8
Due by Week 11 |
| Database Portfolio Completion |
| Return to IT 125 Syllabus |
 |
| Extra Credit Assignments |
|
Extra Credit # 1 -- CodeCademy Learn SQL Extra Credit # 2 -- Load Sample Data Into Assignment 6 Model |
|