Information Management

• 0. Tools
• 1. Introduction to MySQL
• 2. MySQL Tables
• 3. MySQL CRUD
• 4. MySQL Operators
• 5. MySQL Joins
• 6. MySQL Advanced Statements and Clauses
• 7. MySQL Functions

0. Tools

• 0.0. Enrollment
• 0.1. Webinar
• 0.2. Gradebook

1. Introduction to MySQL

• 1.1. Introduction to MySQL
• 1.2. Understanding Normalization
• 1.3. MySQL Data Types
• 1.4. MySQL Basics

2. MySQL Tables

• 2.1. MySQL Keys and Relationships
• 2.2. MySQL Constraints
• 2.3. MySQL Table Manipulation
• 2.4. MySQL ON DELETE Clause

3. MySQL CRUD

• 3.1. MySQL Operators
• 3.2. MySQL SELECT Statement
• 3.3. MySQL INSERT Statement
• 3.4. MySQL UPDATE Statement
• 3.5. MySQL DELETE Statement
• 3.6. MySQL LIMIT Clause
• 3.7. MySQL ORDER BY Clause
• 3.8. Assessment 1

4. MySQL Operators

• 4.1. MySQL LIKE Operator
• 4.2. MySQL IN Operator
• 4.3. MySQL BETWEEN Operator
• 4.4. MySQL UNION Operator
• 4.5. MySQL EXISTS Operator

5. MySQL Joins

• 5.1. MySQL Aliases
• 5.2. MySQL INNER JOIN
• 5.3. MySQL LEFT JOIN
• 5.4. MySQL RIGHT JOIN
• 5.5. MySQL CROSS JOIN
• 5.6. Assessment 2

6. MySQL Advanced Statements and Clauses

• 6.1. MySQL GROUP BY Clause
• 6.2. MySQL HAVING Clause
• 6.3. MySQL CASE Statement
• 6.4. MySQL INSERT INTO SELECT Statement

7. MySQL Functions

• 7.1. MySQL String Functions
• 7.2. MySQL Numeric Functions
• 7.3. MySQL Date Functions
• 7.4. Assessment 3
• 7.5. Certificate