Week 1

Class Agenda
1. Discuss CST Website
2. Demonstrate installing MySQL Server, MySQL Workbench.
Complete the following by Friday of this week:
1. Complete your student profile
2. Complete module 1 quiz in D2L
Complete the following:
1. Lab 1
2. Read MySQL.
3. Read MySQL Workbench.
4. Browse Intro to SQL: Querying and managing data.

Week 2

Class Agenda
1. Review the Module 1 quiz in D2L
2. Discuss MySQL.
3. Discuss MySQL Workbench.
4. Discuss Intro to SQL: Querying and managing data.
5. Discuss creating a database using a GUI and the command line.
6. Discuss creating a database table using a GUI and the command line.
Complete the following:
1. Complete the Module 2 quiz in D2L
2. Lab 2
3. Read Database engine.
4. Browse The InnoDB Storage Engine.
5. Browse Alternative Storage Engines.

Week 3

Class Agenda
1. Review the Module 2 quiz in D2L
2. Discuss Database engine.
3. Discuss The InnoDB Storage Engine.
4. Discuss Alternative Storage Engines.
5. Discuss class tasks.
Complete the following:
1. Complete the Module 3 quiz in D2L
2. Lab 3
3. Lab 4
4. Browse Chapter 4 MySQL Programs.

Week 4

Class Agenda
1. Review the Module 3 quiz in D2L
2. Discuss Chapter 4 MySQL Programs.
3. Discuss class tasks.
Complete the following:
1. Complete the Module 5 quiz in D2L
2. Lab 5
3. Browse MySQL Server Administration.

Week 5

Class Agenda
1. Review the Module 5 quiz in D2L
2. Discuss MySQL Server Administration.
3. Discuss class tasks.
Complete the following:
1. Complete the Module 6 quiz in D2L
2. Read Chapter 6 Security.
3. Read Chapter 9 Language Structure.
4. Browse MySQL Globalization.

Week 6

Class Agenda
1. Discuss Chapter 6 Security.
2. Discuss Chapter 9 Language Structure.
3. Discuss MySQL Globalization.
4. Discuss class tasks.
Complete the following:
1. Read Chapter 11 Data Types.
2. Read Chapter 12 Functions and Operators.

Week 7

Class Agenda
1. Discuss Chapter 11 Data Types.
2. Discuss Chapter 12 Functions and Operators.
3. Discuss Backup Priveleges.
4. Discuss class tasks.
Complete the following:
1. Browse Chapter 25 Stored Objects.
2. Browse MySQL Stored Procedure.
3. Browse Statement/Syntax Index.

Week 8

Class Agenda
1. Discuss Chapter 25 Stored Objects.
2. Discuss Briefly MySQL Stored Procedure.
3. Discuss Statement/Syntax Index.
4. Discuss class tasks.
Complete the following:
1. Browse the MySQL IF Statement.
2. Browse the MySQL CASE Statement.
3. Browse the MySQL Loop in Stored Procedures.

Week 9

Class Agenda
1. Discuss 25.5 Using Views
2. Discuss 25.9 Restrictions on Views
3. Discuss MySQL Stored Procedure.
4. Discuss the MySQL IF Statement.
5. Discuss the MySQL CASE Statement.
6. Discuss the MySQL Loop in Stored Procedures.
7. Discuss MySQL Stored Procedure.
8. Discuss class tasks.
Complete the following:
1. Lab 6 - Instructions are in D2L
2. Browse Listing Stored Procedures in a MySQL Database.
3. Browse MySQL Error Handling in Stored Procedures.
4. Browse Raising Error Conditions with MySQL SIGNAL / RESIGNAL Statements.
5. Browse MySQL Stored Function.

Week 10

Class Agenda
1. Discuss Listing Stored Procedures in a MySQL Database.
2. Discuss MySQL Error Handling in Stored Procedures.
3. Discuss Raising Error Conditions with MySQL SIGNAL / RESIGNAL Statements.
4. Discuss MySQL Stored Function.
5. Discuss class tasks.
Complete the following:
1. Lab 07
2. Browse MySQL Cursor.
3. Browse MySQL Triggers.
4. Browse Introduction to SQL Trigger.
5. Browse MySQL Triggers Implementation.
6. Browse Create Trigger in MySQL.
7. Browse Create Multiple Triggers For The Same Trigger Event And Action Time.
8. Browse Managing Triggers in MySQL.
9. Browse Working with MySQL Scheduled Event.
10. Browse Modifying MySQL Events.

Week 11

Class Agenda
1. Discuss MySQL Cursor.
2. Discuss MySQL Triggers.
3. Discuss Introduction to SQL Trigger.
4. Discuss MySQL Triggers Implementation.
5. Discuss Create Trigger in MySQL.
6. Discuss Create Multiple Triggers For The Same Trigger Event And Action Time.
7. Discuss Managing Triggers in MySQL.
8. Discuss Working with MySQL Scheduled Event.
9. Discuss Modifying MySQL Events.
10. Review MySQL Stored Function.
11. Discuss class tasks.
Complete the following:
1. Lab 8
2. Browse MySQL Views.
3. Browse Introduction to Database View.
4. Browse Views in MySQL.
5. Browse Creating Views in MySQL.
6. Browse Creating MySQL Updatable Views.
7. Browse Ensuring Views Consistency Using WITH CHECK OPTION Clause.
8. Browse Understanding LOCAL & CASCADED in WITH CHECK OPTION Clause.
9. Browse Managing Views in MySQL.

Week 12

Class Agenda
1. No Class - Veterans Day
Complete the following:
1. No Class - Veterans Day

Week 13

Class Agenda
1. Discuss MySQL Views.
2. Discuss Introduction to Database View.
3. Discuss Views in MySQL.
4. Discuss Creating Views in MySQL.
5. Discuss Creating MySQL Updatable Views.
6. Discuss Ensuring Views Consistency Using WITH CHECK OPTION Clause.
7. Discuss Understanding LOCAL & CASCADED in WITH CHECK OPTION Clause.
8. Discuss Managing Views in MySQL.
9. Discuss class tasks.
Complete the following:
1. Browse MySQL Administration.
2. Read Upgrading MySQL.
3. Read Upgrading MySQL on Windows.
4. Read Tips for Upgrading to from MySQL 5.7 to MySQL 8.

Week 14

Class Agenda
1. Discuss MySQL Administration.
2. Discuss Upgrading MySQL.
3. Discuss Upgrading MySQL on Windows.
4. Discuss Tips for Upgrading to from MySQL 5.7 to MySQL 8.
Complete the following:
1. TBD

Week 15

Class Agenda
1. TBD
Complete the following:
1. TBD

Week 16

Class Agenda
1. TBD
Complete the following:
1. TBD

Week 17

Class Agenda
1. No classes this week - finals week!!!
Complete the following: