Intro to MySQL-Course Introduction
Introduction to the program
()
Introduction to the course
()
How Meta uses MySQL
()
Course syllabus: Database structures and management with MySQL
How to be successful in this course
Recap of Course 1 concepts
How to access MySQL Environment
Additional resources
Intro to MySQL-Filtering data
Filtering data using AND, OR and NOT logical operators
()
Filtering data using IN, BETWEEN and LIKE logical operators
()
Filtering data (Exercise solution)
Additional resources
Reading exercise: Filtering data examples (Optional)
Reading exercise: Filtering data examples (Exercise solution)
Reference sheet: Using operators and the WHERE clause
Intro to MySQL-Joining Tables
MySQL aliases
()
Joining tables
JOINS
()
INNER JOIN
()
LEFT and RIGHT JOIN
()
SELF-JOIN
()
MySQL UNION operator
()
Practice using JOINS (Exercise solution)
Additional resources
Intro to MySQL-Grouping Data
MySQL GROUP BY
()
MySQL HAVING
()
Grouping data (Exercise solution)
Module summary: Intro to MySQL
()
Additional resources
Reading exercise: Operators and clauses (Optional)
Reading exercise: Operators and clauses (Exercise solution)
Reference sheet: Operators and clauses
Updating databases and working with views-Updating and inserting data
MySQL REPLACE statement
()
MySQL REPLACE statement in depth
MySQL REPLACE statement (Exercise solution)
Additional resources
Reading exercise: REPLACE INTO statement (Optional)
Reading exercise: REPLACE INTO statement (Exercise solution)
Updating databases and working with views-Constraints
Constraints in MySQL
()
Constraints in practice
()
Types of MySQL constraints
Working with constraints (Exercise solution)
Additional resources
Reading exercise: MySQL constraints (Optional)
Reading exercise: MySQL constraints (Exercise solution)
Updating databases and working with views-Changing table structure
MySQL ALTER TABLE
()
MySQL COPY TABLE
()
Changing table structure (Exercise solution)
Additional resources
Reading exercise: ALTER TABLE statement (Optional)
Reading exercise: ALTER TABLE statement (Exercise solution)
Reference sheet: ALTER TABLE statement and its uses
Updating databases and working with views-Subqueries
Subqueries in MySQL
()
Subqueries and complex comparison operators
()
Working with subqueries (Exercise solution)
Additional resources
Reading exercise: Practicing subqueries (Optional)
Reading exercise: Practicing subqueries (Exercise solution)
Reference sheet: Subqueries
Updating databases and working with views-Virtual Tables
MySQL CREATE VIEW
()
Virtual tables in depth
Working with views in MySQL (Exercise solution)
Module summary: Updating databases and working with views
()
Additional resources
Reference sheet: Creating virtual tables in MySQL
Functions and MySQL stored procedures-Functions in MySQL
Numeric functions
()
String functions
()
Date functions
()
Comparison functions
()
Control flow functions
()
Working with MySQL functions (Exercise solution)
Additional resources
Reading exercise: Practicing with functions (Optional)
Reading exercise: Practicing with functions (Exercise solution)
Reference sheet: Functions in MySQL
Functions and MySQL stored procedures-Procedures
Stored procedures in MySQL
()
MySQL stored procedures in depth
Working with procedures (Exercise solution)
Module summary: Functions and MySQL stored procedures
()
Additional resources
Graded assessment-Graded Assessment: Final project
Course Recap
()
About the final graded assessment
MySQL database project (Exercise solution)
Graded assessment-Course wrap up
Course wrap up
()
Next steps