IIRF Online > Development > Database Design & Development > MySQL > Database Structures and Management with MySQL
Database Structures and Management with MySQL by Coursera
Course Highlights
- Utilize the MySQL DBMS to build and modify relational databases with SQL.
- Create relationships between tables using primary and foreign keys.
Skills you will learn!
Curriculum
44 Topics
Introduction to the program
Introduction to the course
How Meta uses MySQL
Filtering data using AND OR and NOT logical operators
Filtering data using IN BETWEEN and LIKE logical operators
MySQL aliases
JOINS
INNER JOIN
LEFT and RIGHT JOIN
SELF-JOIN
MySQL UNION operator
MySQL GROUP BY
MySQL HAVING
Module summary: Intro to 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
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
Joining tables
Practice using JOINS (Exercise solution)
Additional resources
Grouping data (Exercise solution)
Additional resources
Reading exercise: Operators and clauses (Optional)
Reading exercise: Operators and clauses (Exercise solution)
Reference sheet: Operators and clauses
Knowledge check: Filtering data using logical operators
Self review: Filtering data
Knowledge check: JOINS
Knowledge check: MySQL UNION operator
Self review: JOINS
Knowledge check: GROUP BY and HAVING clauses
Self review: Grouping data
Module quiz: Intro to MySQL
What do you hope to learn?
Exercise: Filtering data
Exercise: Practice using JOINS
Exercise: Grouping data
49 Topics
MySQL REPLACE statement
Constraints in MySQL
Constraints in practice
MySQL ALTER TABLE
MySQL COPY TABLE
Subqueries in MySQL
Subqueries and complex comparison operators
MySQL CREATE VIEW
Module summary: Updating databases and working with views
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)
Types of MySQL constraints
Working with constraints (Exercise solution)
Additional resources
Reading exercise: MySQL constraints (Optional)
Reading exercise: MySQL constraints (Exercise solution)
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
Working with subqueries (Exercise solution)
Additional resources
Reading exercise: Practicing subqueries (Optional)
Reading exercise: Practicing subqueries (Exercise solution)
Reference sheet: Subqueries
Virtual tables in depth
Working with views in MySQL (Exercise solution)
Additional resources
Reference sheet: Creating virtual tables in MySQL
Knowledge check: REPLACE
Self review: MySQL REPLACE statement
Knowledge check: Constraints
Self review: Working with constraints
Knowledge check: ALTER TABLE and COPY TABLE
Self review: Changing table structure
Knowledge check: Subqueries in MySQL
Self review: Working with subqueries
Knowledge check: Views in MySQL
Self review: Working with views in MySQL
Module quiz: Updating databases and working with views
Exercise: MySQL REPLACE statement
Exercise: Working with constraints
Exercise: Changing table structure
Exercise: Working with subqueries
Working with views in MySQL
23 Topics
Numeric functions
String functions
Date functions
Comparison functions
Control flow functions
Stored procedures in MySQL
Module summary: Functions and MySQL stored procedures
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
MySQL stored procedures in depth
Working with procedures (Exercise solution)
Additional resources
Knowledge check: MySQL functions
Knowledge check: MySQL comparison and control flow functions
Self review: Working with MySQL functions
Knowledge check: MySQL stored procedures
Self review: Working with procedures
Module quiz: Functions and MySQL stored procedures
Exercise: Working with MySQL functions
Exercise: Working with procedures
10 Topics
Course Recap
Course wrap up
About the final graded assessment
MySQL database project (Exercise solution)
Next steps
Self review: MySQL database project
Course final graded quiz
Share some of the things you learned building the project.
Reflect on learning
MySQL database project
Database Structures and Management with MySQL
Related MySQL Courses
Thank You!
Your review has been submitted successfully.