• 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 Data.
  3. Read Information.
  4. Read Database.
  5. Read Data integrity.
  6. Read Difference between Information and Data.

Week 2

• Class Agenda
  1. Review the Module 1 quiz in D2L
  2. Discuss Data.
  3. Discuss Information.
  4. Discuss Database.
  5. Discuss Data integrity.
  6. Discuss Difference between Information and Data.
  7. Discuss class tasks.
• Complete the following:
  1. Complete Module 2 Quiz in D2L
  2. Lab 2
  3. Lab 3
  4. Read Chapter 1 Before the Advent of Database Systems in Database Design 2nd Edition. pp 1 (9)
  5. Read Chapter 2 Fundamental Concepts in Database Design 2nd Edition. pp 6 (14)
  6. Read Chapter 3 Characteristics and Benefits of a Database in Database Design 2nd Edition. pp 9 (17)
  7. Read Chapter 4 Types of Data Models in Database Design 2nd Edition. pp 13 (21)
  8. Read Chapter 5 Data Modelling in Database Design 2nd Edition. pp 15 (23)
  9. Browse Basic MySQL Tutorial.

Week 3

• Class Agenda
  1. Review the Module 2 quiz in D2L
  2. Discuss Chapter 1 Before the Advent of Database Systems in Database Design 2nd Edition. pp 1 (9)
  3. Discuss Chapter 2 Fundamental Concepts in Database Design 2nd Edition. pp 6 (14)
  4. Discuss Chapter 3 Characteristics and Benefits of a Database in Database Design 2nd Edition. pp 9 (17)
  5. Discuss Chapter 4 Types of Data Models in Database Design 2nd Edition. pp 13 (21)
  6. Discuss Chapter 5 Data Modelling in Database Design 2nd Edition. pp 15 (23)
  7. Discuss Basic MySQL Tutorial.
  8. Discuss class tasks.
• Complete the following:
  1. Complete Module 3 Quiz in D2L
  2. Lab 4
  3. Read Chapter 6 Classification of Database Management Systems in Database Design 2nd Edition. pp 21 (29)
  4. Read Chapter 7 The Relational Data Model in Database Design 2nd Edition. pp 24 (32)
  5. Read Chapter 8 The Entity Relationship Data Model in Database Design 2nd Edition. pp 29 (37)
  6. Browse Basic MySQL Tutorial - Section 1. Getting started with MySQL.

Week 4

• Class Agenda
  1. Review the Module 1 quiz in D2L
  2. Discuss Chapter 6 Classification of Database Management Systems in Database Design 2nd Edition. pp 21 (29)
  3. Discuss Chapter 7 The Relational Data Model in Database Design 2nd Edition. pp 24 (32)
  4. Discuss Chapter 8 The Entity Relationship Data Model in Database Design 2nd Edition. pp 29 (37)
  5. Discuss Basic MySQL Tutorial - Section 1. Getting started with MySQL.
  6. Discuss the classicmodels database.
  7. Discuss class tasks.
• Complete the following:
  1. Lab 5
  2. Read Chapter 9 Integrity Rules and Constraints in Database Design 2nd Edition. pp 44 (52)
  3. Read Chapter 10 ER Modelling in Database Design 2nd Edition. pp 55 (63)
  4. Read Chapter 11 Functional Dependencies in Database Design 2nd Edition. pp 61 (69)
  5. Read Basic MySQL Tutorial Section 2 Querying data:
     1. Using MySQL SELECT Statement to Query Data.
     2. Using MySQL DISTINCT to Eliminate Duplicates.
  6. Browse w3resource MySQL Tutorial.

Week 5

• Class Agenda
  1. Discuss Chapter 9 Integrity Rules and Constraints in Database Design 2nd Edition. pp 44 (52)
  2. Discuss Chapter 10 ER Modelling in Database Design 2nd Edition. pp 55 (63)
  3. Discuss Chapter 11 Functional Dependencies in Database Design 2nd Edition. pp 61 (69)
  4. Discuss Basic MySQL Tutorial Section 2 Querying data:
     1. Using MySQL SELECT Statement to Query Data.
     2. Using MySQL DISTINCT to Eliminate Duplicates.
  5. Discuss the w3resource MySQL Tutorial.
  6. Discuss the bookinfo database.
  7. Discuss class tasks.
• Complete the following:
  1. Lab 6
  2. Read Basic MySQL Tutorial Section 3 Filtering data:
     1. MySQL WHERE.
     2. MySQL AND Operator.
     3. MySQL OR Operator.
     4. MySQL IN.
     5. MySQL BETWEEN.
     6. MySQL LIKE.
     7. MySQL LIMIT.
     8. A Comprehensive Look at MySQL IS NULL Operator.
  3. Read Basic MySQL Tutorial Section 4 Sorting data:
     1. MySQL ORDER BY: Sort a Result Set.
     2. MySQL Natural Sorting with ORDER BY Clause.
  4. Browse w3resource MySQL Tutorial:
     1. MySQL SELECT statement.
     2. MySQL FUNCTIONS and OPERATORS.

Week 6

• Class Agenda
  1. Discuss Basic MySQL Tutorial Section 3 Filtering data:
     1. MySQL WHERE.
     2. MySQL AND Operator.
     3. MySQL OR Operator.
     4. MySQL IN.
     5. MySQL BETWEEN.
     6. MySQL LIKE.
     7. MySQL LIMIT.
     8. A Comprehensive Look at MySQL IS NULL Operator.
  2. Discuss Basic MySQL Tutorial Section 4 Sorting data:
     1. MySQL ORDER BY: Sort a Result Set.
     2. MySQL Natural Sorting with ORDER BY Clause.
  3. Discuss w3resource MySQL Tutorial:
     1. MySQL SELECT statement.
     2. MySQL FUNCTIONS and OPERATORS.
  4. Discuss class tasks.
• Complete the following:
  1. Lab 7
  2. Read Basic MySQL Tutorial Section 5 Joining tables:
     1. Read MySQL Alias.
     2. Read MySQL Join Made Easy For Beginners.
     3. Read MySQL INNER JOIN.
     4. Read MySQL LEFT JOIN.
     5. Read MySQL RIGHT JOIN.
     6. Read A Practical Use of MySQL CROSS JOIN Clause.
     7. Read MySQL Self Join.
  3. Read Basic MySQL Tutorial Section 7 MySQL subquery, derived table, and CTE:
     1. Read MySQL Subquery.
     2. Read An Essential Guide to MySQL Derived Tables.
     3. Read An Introduction to MySQL CTE.
     4. Read A Definitive Guide To MySQL Recursive CTE.
  4. Browse w3resource MySQL Tutorial: MySQL Subqueries.

Week 7

• Class Agenda
  1. Discuss SQL code formatting.
  2. Discuss w3resource MySQL Tutorial:
     1. MySQL SELECT statement.
     2. MySQL FUNCTIONS and OPERATORS.
  3. Discuss Basic MySQL Tutorial Section 5 Joining tables:
     1. Discuss MySQL Alias.
     2. Discuss MySQL Join Made Easy For Beginners.
     3. Discuss MySQL INNER JOIN.
     4. Discuss MySQL LEFT JOIN.
     5. Discuss MySQL RIGHT JOIN.
     6. Discuss A Practical Use of MySQL CROSS JOIN Clause.
     7. Discuss MySQL Self Join.
  4. Discuss Basic MySQL Tutorial Section 7 MySQL subquery, derived table, and CTE:
     1. Discuss MySQL Subquery.
     2. Discuss An Essential Guide to MySQL Derived Tables.
     3. Discuss An Introduction to MySQL CTE.>
     4. Discuss A Definitive Guide To MySQL Recursive CTE.
  5. Discuss w3resource MySQL Tutorial: MySQL Subqueries (If time permits).
• Complete the following:
  1. Lab 8 - Instructions are in D2L
  2. Lab 9 - Instructions are in D2L
  3. Read Basic MySQL Tutorial Section 6 Grouping data:
     1. Read MySQL GROUP BY.
     2. Read MySQL HAVING.
     3. Read MySQL ROLLUP.
  4. Read 13.2.11.8 Derived Tables.
  5. Read What is the concept of a derived table concerned with MySQL subquery?.
  6. Read When and How to Apply SQL Server Derived Tables.
  7. Read LATERAL Derived Tables in MySQL 8.0.
  8. Read Use Derived Tables in Your MySQL Queries to Improve Database Performance.
  9. View SQL JOINS and SQL JOINS.
  10. Read w3resource MySQL Tutorial: MySQL JOINS.

Week 8

• Class Agenda
  1. No class meetings this week. (Teacher Conventions)
• Complete the following:
  1. No class meetings this week. (Teacher Conventions)

Week 9

• Class Agenda
  1. Discuss Basic MySQL Tutorial Section 6 Grouping data:
     1. Discuss MySQL GROUP BY.
     2. Discuss MySQL HAVING.
     3. Discuss MySQL ROLLUP.
  2. Discuss 13.2.11.8 Derived Tables.
  3. Discuss What is the concept of a derived table concerned with MySQL subquery?.
  4. Discuss When and How to Apply SQL Server Derived Tables.
  5. Discuss LATERAL Derived Tables in MySQL 8.0.
  6. Discuss Use Derived Tables in Your MySQL Queries to Improve Database Performance.
  7. Discuss SQL JOINS and SQL JOINS.
  8. Discuss w3resource MySQL Tutorial: MySQL JOINS.
  9. Discuss w3resource MySQL Tutorial: MySQL Advance Query.
  10. Discuss SQL JOINS and SQL JOINS.
  11. Discuss w3resource MySQL Tutorial: MySQL JOINS.
  12. Discuss class tasks.
• Complete the following:
  1. Lab 10
  2. Lab 11
  3. Read Basic MySQL Tutorial Section 8 Using Set operators:
     1. Read MySQL UNION.
     2. Read MySQL INTERSECT.
     3. Read MySQL MINUS.
  4. Read Basic MySQL Tutorial Section 12 MySQL data types:
     1. MySQL Data Types.
     2. MySQL INT Data Type Explained With Examples.
     3. MySQL DECIMAL Data Type.
     4. Pramatic Uses of MySQL BIT Data Type.
     5. An Introduction to MySQL BOOLEAN Data Type.
     6. MySQL CHAR Data Type.
     7. The Essential Guide to MySQL VARCHAR Data Type.
     8. The Basics Of MySQL TEXT Data Type.
     9. The Ultimate Guide To MySQL DATE and Date Functions.
     10. Mastering MySQL TIME Data Type.
     11. A Complete Guide To MySQL DATETIME Data Type.
     12. MySQL TIMESTAMP.
     13. A Practical Guide to MySQL JSON Data Type By Example.
     14. A Comprehensive Guide to Using MySQL ENUM.
  5. Browse w3resource MySQL Tutorial: MySQL Data Types.

Week 10

• Class Agenda
  1. Discuss Basic MySQL Tutorial Section 8 Using Set operators:
     1. Discuss MySQL UNION.
     2. Discuss MySQL INTERSECT.
     3. Discuss MySQL MINUS.
  2. Discuss Basic MySQL Tutorial Section 12 MySQL data types:
     1. MySQL Data Types.
     2. MySQL INT Data Type Explained With Examples.
     3. MySQL DECIMAL Data Type.
     4. Pramatic Uses of MySQL BIT Data Type.
     5. An Introduction to MySQL BOOLEAN Data Type.
     6. MySQL CHAR Data Type.
     7. The Essential Guide to MySQL VARCHAR Data Type.
     8. The Basics Of MySQL TEXT Data Type.
     9. The Ultimate Guide To MySQL DATE and Date Functions.
     10. Mastering MySQL TIME Data Type.
     11. A Complete Guide To MySQL DATETIME Data Type.
     12. MySQL TIMESTAMP.
     13. A Practical Guide to MySQL JSON Data Type By Example.
     14. A Comprehensive Guide to Using MySQL ENUM.
  3. Discuss w3resource MySQL Tutorial: MySQL Data Types.
  4. Discuss class tasks.
• Complete the following:
  1. Read Chapter 12 Normalization in Database Design 2nd Edition. pp 66 (74).
  2. Browse Database normalization https://en.wikipedia.org.
  3. Browse Normalization of Database http://www.studytonight.com.
  4. Browse Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database http://beginnersbook.com.
  5. Browse Database Normalization http://holowczak.com.

Week 11

• Class Agenda
  1. Discuss Chapter 12 Normalization in Database Design 2nd Edition. pp 66 (74).
  2. Discuss Database normalization https://en.wikipedia.org.
  3. Discuss Normalization of Database http://www.studytonight.com. Moved to next week.
  4. Discuss Normalization in DBMS: 1NF, 2NF, 3NF and BCNF in Database http://beginnersbook.com. Moved to next week.
  5. Discuss Database Normalization http://holowczak.com. Moved to next week.
  6. Discuss class tasks.
• Complete the following:
  1. Read Mother Celko's Heuristics.
  2. View Normalization by Marc Rettig.
  3. Read Database normalization is good and bad.
  4. Browse Database Normalization.
  5. Browse Database Normalization Explained in Simple English.

Week 12

• Class Agenda
  1. Discuss Mother Celko's Heuristics.
  2. Discuss Normalization by Marc Rettig.
  3. Discuss Database normalization is good and bad.
  4. Discuss Database Normalization.
  5. Discuss Database Normalization Explained in Simple English.
  6. Discuss class tasks.
• Complete the following:
  1. Lab 12
  2. Browse Practical Database Design for Relational Database Management Systems.
  3. Browse What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples.
  4. Browse Designing a Normalized Database.
  5. Browse Description of the database normalization basics.
  6. Browse Database Normalization Examples.

Week 13

• Class Agenda
  1. Discuss Practical Database Design for Relational Database Management Systems.
  2. Discuss What is Normalization? 1NF, 2NF, 3NF & BCNF with Examples.
  3. Discuss Designing a Normalized Database.
  4. Discuss Description of the database normalization basics.
  5. Discuss Database Normalization Examples.
  6. Discuss Ridgewater College, Hutchinson Campus Fall Semester 2023 Class Schedule and Ridgewater College, Willmar Campus Fall Semester 2023 Class Schedule with an eye towards normilization.
  7. Discuss class tasks.
• Complete the following:
  1. Lab 13

Week 14

• Class Agenda
  1. No Class - Thanksgiving
• Complete the following:
  1. No Class - Thanksgiving

Week 15

• Class Agenda
  1. TBD
• Complete the following:
  1. Lab 14
  2. 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:
  Complete all unfinished labs.