Learn MySQL Database Online
Explore our MySQL Database course online with engaging video tutorials and practical guides to boost your skills and knowledge.
Start Learning
Learn MySQL Database Online
Learn everything you need to know to get started with MySQL Database
Get StartedWatch Step-by-Step MySQL Database Video Tutorials Online
Enhance your MySQL skills with step-by-step video tutorials and expert-guided lessons, designed to take you from beginner to advanced Java developer at your own pace.
Beginners
WITH FLASHCARDSDiscover the world of MySQL and enhance your data management skills with this comprehensive guide. Don't miss out on the opportunity to level up your database expertise. Start learning now!
Lesson 1
What is MySQL
Lesson 2
Installing MySQL (Windows, macOS, Linux)
Lesson 3
Introduction to MySQL Workbench
Lesson 4
Understanding Relational Databases
Lesson 5
Connecting to MySQL using VS Code
Lesson 6
Creating Tables and Defining Columns
Lesson 7
Understanding Data Types
Lesson 8
Writing Simple SELECT Queries
Lesson 9
Filtering Results with WHERE
Lesson 10
Sorting Results Using ORDER BY
Lesson 11
Using LIMIT for Result Pagination
Lesson 12
Primary Keys and Foreign Keys
Lesson 13
Using JOIN to Combine Data from Multiple Tables
Lesson 14
Basic Use of INNER JOIN, LEFT JOIN, and RIGHT JOIN
Lesson 15
Exporting Data from a Database
Lesson 16
Importing Data into a Database
Lesson 17
Using mysqldump for Backups
Lesson 18
Restoring Databases from SQL Dumps
Intermediate
WITH FLASHCARDSDiscover the world of MySQL and enhance your data management skills with this comprehensive guide. Don't miss out on the opportunity to level up your database expertise. Start learning now!
Lesson 19
Using Aggregate Functions
Lesson 20
Grouping Data with GROUP BY
Lesson 21
Filtering Grouped Data with HAVING
Lesson 22
Writing Subqueries and Nested Queries
Lesson 23
Normalization and Denormalization
Lesson 24
Understanding 1NF, 2NF, 3NF, and Beyond
Lesson 25
Designing Efficient Schema for Real-World Applications
Lesson 26
Understanding Indexes and Their Impact on Performance
Lesson 27
Creating and Managing Indexes
Lesson 28
Using the EXPLAIN Statement to Analyze Query Performance
Lesson 29
Understanding Transactions and ACID
Lesson 30
Using START TRANSACTION, COMMIT, and ROLLBACK
Lesson 31
Isolation Levels
Lesson 32
Writing and Executing Stored Procedures
Lesson 33
Creating and Using Stored Functions
Lesson 34
Understanding Input and Output Parameters
Lesson 35
Using Procedural SQL (Loops, Conditions, Cursors)
Advanced
WITH FLASHCARDSMaster complex MySQL operations such as stored procedures, triggers, indexing strategies, and real-world optimization. Ideal for professionals aiming to build high-performance database systems.
Lesson 36
Creating and Managing Triggers
Lesson 37
Using Triggers
Lesson 38
Creating Scheduled Events
Lesson 39
Managing User Accounts and Permissions
Lesson 40
Understanding Roles and Privileges
Lesson 41
Encrypting Data
Lesson 42
Best Practices for Database Security
Lesson 43
Setting Up Master-Slave Replication
Lesson 44
Replication in SQL Server
Lesson 45
Using MySQL InnoDB Cluster for High Availability
Lesson 46
Partitioning Tables for Large Datasets
Lesson 47
Query Caching and Tuning
Lesson 48
Managing Server Configurations for Performance
Lesson 49
Profiling Queries
HNG PREMIUM NETWORK —
Join HNG Premium Network!
Gain access to internships, job opportunities, and certifications. Enjoy free courses, networking events, tech collaborations, interview prep training, and CV reviews. Connect with mentors, past interns, and fellow tech enthusiasts while working on real-world projects.
Join the Network for ₦7 000
Explore Courses Beyond MySQL Database Online
Discover new learning paths.
Learn HTML online
Explore our HTML course online with engaging video tutorials and practical guides to boost your skills and knowledge.
Learn JavaScript Programming online
Explore our JavaScript Programming course online with engaging video tutorials and practical guides to boost your skills and knowledge.
Learn CSS Programming online
Learn the basics of CSS with this free tutorial video that breaks down the role of CSS in web design. Discover how CSS affects the look and feel of your website.
Learn NodeJs Programming online
Explore this free course on running servers with JavaScript using Node.js. Understand the benefits of Node.js for front-end developers and how it streamlines server-side application development.
Learn C++ Programming online
Begin learning C++ today with our comprehensive guide. Dive into the world of programming with C++ and unlock endless possibilities in software development.
Learn Java Programming online
Explore our Java Programming course online with engaging video tutorials and practical guides to boost your skills and knowledge.
Learn Typescript Programming online
Learn the fundamentals of TypeScript for web development in this free tutorial. Discover how type annotations, strong typing, and tooling can streamline your coding process and catch bugs early on.
Learn Python Programming online
Learn how to use Python for general programming, automation, and problem-solving.
Trusted by Tech Talents in MySQL Database and Other Fields
HNG Learn is chosen by Tech Talents to to learn beginner to advanced concepts across all tech tracks, ensuring they stay at the forefront of innovation and success. Here's what a few of them have to say...
Superb!
I am proud to say that after a few months of taking this course...I passed my exam and am now an AWS Certified Cloud Practitioner!
John Webster
Completed New Docker Course
Superb!
The course content was incredibly detailed and practical. I've already applied several concepts to my work projects.
Sarah Johnson
Completed Advanced React Patterns
Superb!
As a beginner in ML, this course provided an excellent foundation. The hands-on projects were particularly helpful.
Michael Chen
Completed Machine Learning Fundamentals
Superb!
I feel much more confident in my ability to protect digital assets after completing this comprehensive course.
Emily Rodriguez
Completed Cybersecurity Essentials
Superb!
The course covered both front-end and back-end technologies thoroughly. I now feel ready to take on full-stack roles.
David Kim
Completed Full-Stack Web Development
Superb!
I am proud to say that after a few months of taking this course...I passed my exam and am now an AWS Certified Cloud Practitioner!
John Webster
Completed New Docker Course
Superb!
The course content was incredibly detailed and practical. I've already applied several concepts to my work projects.
Sarah Johnson
Completed Advanced React Patterns
Superb!
As a beginner in ML, this course provided an excellent foundation. The hands-on projects were particularly helpful.
Michael Chen
Completed Machine Learning Fundamentals
Superb!
I feel much more confident in my ability to protect digital assets after completing this comprehensive course.
Emily Rodriguez
Completed Cybersecurity Essentials
Superb!
The course covered both front-end and back-end technologies thoroughly. I now feel ready to take on full-stack roles.
David Kim
Completed Full-Stack Web Development
More Categories
Learn additional skills that can help you grow in your tech journey.
Software Development
Web Development
Mobile Development
Python
Docker
Design
Figma
Adobe Photoshop
UI/UX Design
Graphic Design
Marketing
SEO
Content Marketing
Social Media Marketing
Email Marketing
Video Editing
Adobe Premiere
Final Cut Pro
After Effects
Storyboarding
Product Management
Jira
Agile Methodologies
Product Roadmapping
User Stories