Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering MySQL: Build and Manage Databases Like a Pro
Rating: 4.2 out of 5(59 ratings)
8,659 students

Mastering MySQL: Build and Manage Databases Like a Pro

Become a MySQL expert by learning how to build, query, and optimize relational databases.
Created byBrighter Futures Hub
Last updated 8/2025
English

What you'll learn

  • What is MySQL? Overview and Use Cases
  • Installing MySQL: Windows, MacOS, and Linux
  • Using MySQL Workbench and Command Line
  • Overview of Relational Database Concepts
  • Introduction to Databases, Tables, and Relationships
  • Basic SQL Commands: SELECT, INSERT, UPDATE, DELETE
  • Filtering Data with WHERE Clause
  • Sorting and Limiting Results: ORDER BY, LIMIT
  • Using Aggregate Functions: COUNT, SUM, AVG, MIN, MAX
  • Grouping Data with GROUP BY and HAVING
  • Working with Dates and Time in MySQL
  • Designing a Database Schema From Scratch
  • Primary and Foreign Keys: Establishing Relationships
  • Understanding and Using JOINs: INNER, LEFT, RIGHT, and FULL JOIN
  • Using UNION and UNION ALL
  • Creating, Modifying, and Deleting Databases and Tables
  • Adding Constraints: NOT NULL, UNIQUE, CHECK, DEFAULT
  • Database Backups and Restoration
  • Triggers and Events: Automating Database Tasks
  • Connecting MySQL with Programming Languages (Python, PHP, Java)
  • Exporting and Importing Data: CSV, JSON, and XML

Course content

8 sections • 26 lectures • 4h 17m total length

  • What is MySQL? Overview and Use Cases6:50

    Understand how MySQL, an open source relational database management system, stores, manages, and retrieves data with speed and reliability, and explore its use cases in web apps and cloud platforms.

  • Installing MySQL: Windows, MacOS, and Linux12:27

    Install and configure MySQL on Windows, macOS, and Linux by downloading the MySQL community edition, running the installer, setting up the server and MySQL Workbench, and securing the root password.

  • Using MySQL Workbench and Command Line9:29
  • Overview of Relational Database Concepts6:00

    Explore relational databases, including tables with rows and columns, primary and foreign keys, and how relationships link data. Understand normalization with 1NF to 3NF and junction tables for many-to-many links.

Requirements

  • A basic understanding of SQL is helpful but not required; we cover the fundamentals

Description

Are you ready to take your database skills to the next level? This comprehensive course is designed for aspiring developers, database administrators, and anyone who wants to master MySQL, the world's most popular open source database. I'll go beyond basic queries to give you the skills needed to design, build, and manage powerful, scalable, and secure databases just like a professional.


MySQL is the backbone of countless applications, from small blogs to massive enterprise systems. While knowing how to write a simple SELECT statement is a good start, becoming proficient requires understanding database architecture, performance optimization, and robust security practices. This course will give you that professional edge.


What You’ll Learn:

  • The fundamentals of relational databases and how MySQL works

  • How to install and use MySQL and MySQL Workbench

  • Writing SQL queries using SELECT, WHERE, ORDER BY, GROUP BY, JOIN, and more

  • Creating, modifying, and deleting tables, databases, and relationships

  • How to use primary keys, foreign keys, indexes, and constraints

  • Implementing stored procedures, views, and triggers

  • Database normalization and best practices in schema design

  • Optimizing queries and improving performance

  • Backing up and restoring databases safely


By the end of this course, you will not only be proficient in MySQL but also possess the strategic thinking of a database professional. You will have the confidence to design and manage databases for any application, big or small.

Who this course is for:

  • Anyone preparing for jobs involving databases, SQL, or backend systems
  • Beginners who want to learn MySQL from scratch
  • Web developers looking to build data driven applications
  • Data analysts and business professionals working with structured data

Report abuse