Monthly Subscription Starting at AED 99 + VAT

Database Structures and Management with MySQL
  • Level Foundation
  • Duration 32 hours
  • Course by Meta
  • Offered by

About

Develop a working knowledge of the MySQL database management system (DBMS). Gain DBMS skills such as data creation, querying and manipulation. You’ll gain further experience with SQL statements, clauses and data types. By the end of this course, you’ll be able to: - Utilize the MySQL DBMS to build and modify relational databases with SQL - Add records to a MySQL database - Perform intricate queries on database records with filters and groupings - Create simple joins and unions within a database - Create relationships between tables using primary and foreign keys - Demonstrate the ability to complete a database normalization project You’ll gain experience with the following tools and software: - MySQL DBMS - Joins and Unions - SQL statements, clauses and data types - Primary and foreign keys - Database normalization

Modules

Course Introduction

    • 3 Videos
    • 5 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • What do you hope to learn?

3 Videos

  • Introduction to the program
  • Introduction to the course
  • How Meta uses MySQL

5 Readings

  • 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

    • 2 Videos
    • 5 Readings
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: Filtering data using logical operators
  • Self review: Filtering data

1 Labs

  • Exercise: Filtering data

2 Videos

  • Filtering data using AND, OR and NOT logical operators
  • Filtering data using IN, BETWEEN and LIKE logical operators

5 Readings

  • 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

    • 6 Videos
    • 3 Readings
    • 1 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: JOINS
  • Knowledge check: MySQL UNION operator
  • Self review: JOINS

1 Labs

  • Exercise: Practice using JOINS

6 Videos

  • MySQL aliases
  • JOINS
  • INNER JOIN
  • LEFT and RIGHT JOIN
  • SELF-JOIN
  • MySQL UNION operator

3 Readings

  • Joining tables
  • Practice using JOINS (Exercise solution)
  • Additional resources

Grouping Data

    • 3 Videos
    • 5 Readings
    • 1 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: GROUP BY and HAVING clauses
  • Self review: Grouping data
  • Module quiz: Intro to MySQL

1 Labs

  • Exercise: Grouping data

3 Videos

  • MySQL GROUP BY
  • MySQL HAVING
  • Module summary: Intro to MySQL

5 Readings

  • Grouping data (Exercise solution)
  • Additional resources
  • Reading exercise: Operators and clauses (Optional)
  • Reading exercise: Operators and clauses (Exercise solution)
  • Reference sheet: Operators and clauses

Updating and inserting data

    • 1 Videos
    • 5 Readings
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: REPLACE
  • Self review: MySQL REPLACE statement

1 Labs

  • Exercise: MySQL REPLACE statement

1 Videos

  • MySQL REPLACE statement

5 Readings

  • 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)

Constraints

    • 2 Videos
    • 5 Readings
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: Constraints
  • Self review: Working with constraints

1 Labs

  • Exercise: Working with constraints

2 Videos

  • Constraints in MySQL
  • Constraints in practice

5 Readings

  • 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

    • 2 Videos
    • 5 Readings
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: ALTER TABLE and COPY TABLE
  • Self review: Changing table structure

1 Labs

  • Exercise: Changing table structure

2 Videos

  • MySQL ALTER TABLE
  • MySQL COPY TABLE

5 Readings

  • 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

Subqueries

    • 2 Videos
    • 5 Readings
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Knowledge check: Subqueries in MySQL
  • Self review: Working with subqueries

1 Labs

  • Exercise: Working with subqueries

2 Videos

  • Subqueries in MySQL
  • Subqueries and complex comparison operators

5 Readings

  • Working with subqueries (Exercise solution)
  • Additional resources
  • Reading exercise: Practicing subqueries (Optional)
  • Reading exercise: Practicing subqueries (Exercise solution)
  • Reference sheet: Subqueries

Virtual Tables

    • 2 Videos
    • 4 Readings
    • 1 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: Views in MySQL
  • Self review: Working with views in MySQL
  • Module quiz: Updating databases and working with views

1 Labs

  • Working with views in MySQL

2 Videos

  • MySQL CREATE VIEW
  • Module summary: Updating databases and working with views

4 Readings

  • Virtual tables in depth
  • Working with views in MySQL (Exercise solution)
  • Additional resources
  • Reference sheet: Creating virtual tables in MySQL

Functions in MySQL

    • 5 Videos
    • 5 Readings
    • 1 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: MySQL functions
  • Knowledge check: MySQL comparison and control flow functions
  • Self review: Working with MySQL functions

1 Labs

  • Exercise: Working with MySQL functions

5 Videos

  • Numeric functions
  • String functions
  • Date functions
  • Comparison functions
  • Control flow functions

5 Readings

  • 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

Procedures

    • 2 Videos
    • 3 Readings
    • 1 Lab
    • 3 Assignment
Show info about module content

3 Assignment

  • Knowledge check: MySQL stored procedures
  • Self review: Working with procedures
  • Module quiz: Functions and MySQL stored procedures

1 Labs

  • Exercise: Working with procedures

2 Videos

  • Stored procedures in MySQL
  • Module summary: Functions and MySQL stored procedures

3 Readings

  • MySQL stored procedures in depth
  • Working with procedures (Exercise solution)
  • Additional resources

Graded Assessment: Final project

    • 1 Videos
    • 2 Readings
    • 1 Discussion
    • 1 Lab
    • 2 Assignment
Show info about module content

2 Assignment

  • Self review: MySQL database project
  • Course final graded quiz

1 Discussions

  • Share some of the things you learned building the project.

1 Labs

  • MySQL database project

1 Videos

  • Course Recap

2 Readings

  • About the final graded assessment
  • MySQL database project (Exercise solution)

Course wrap up

    • 1 Videos
    • 1 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Reflect on learning

1 Videos

  • Course wrap up

1 Readings

  • Next steps

Auto Summary

Unlock the power of MySQL with this foundational course in Database Structures and Management. Perfect for IT and Computer Science enthusiasts, you'll master data creation, querying, and manipulation, along with SQL statements and database normalization. Taught by industry experts on Coursera, this 1920-minute course offers hands-on experience with MySQL DBMS, joins, unions, and key relationships. Flexible subscription options include Starter and Professional plans. Ideal for beginners aiming to build robust relational databases.

Taught by Meta Staff
Instructor

Taught by Meta Staff