MySQL, PostgreSQL and MongoDB Database Design Masterclass

Name: MySQL, PostgreSQL and MongoDB Database Design Masterclass
Rating: 4.6 (79 reviews)

3 in 1 SQL Course | Master Database Design and Management with MySQL, PostgreSQL, and MongoDB for Robust Applications

Created byGeorge Steve, Emenwa Global, Juliet Rona, Chris Mendes

Last updated 4/2026

English

What you'll learn

SQL Database Design | Database Setup and Fundamentals
Download, install, and configure MySQL, PostgreSQL, and MongoDB with Compass and Mongosh.
Create databases, tables, and define data constraints (Unique, NOT NULL, Primary Key, Foreign Key, etc.) in MySQL and PostgreSQL.
Use SQL statements to insert, select, update, and delete data.
Implement advanced features like JOINS (INNER, LEFT), ORDER BY, LIMIT, UNION, SELF JOIN, and VIEWS.
Apply indexing and subqueries to optimize data management.
NoSQL Database Design with MongoDB
Set up MongoDB, work with Compass and Shell, and integrate with Visual Studio Code.
Design MongoDB collections and documents, manage arrays and embedded documents, and understand relationships between documents.
Execute operations like sorting, updating, deleting, and creating one-to-one reference relations.
Advanced Database Management: Learn auto-commit, rollback, current date/time functions, logical operators, wildcards, and ordered insertions.

Course content

3 sections • 99 lectures • 12h 25m total length

Introduction to MySQL, PostgreSQL and MongoDB Database Management System1:04
Design and manage databases with MySQL, PostgreSQL, and MongoDB; install and set up these systems, master SQL fundamentals, and explore joins, indexing, and document-based operations.
Course Roadmap for Database Design Masterclass1:51
What is Database?3:34
Ask Questions, Get Support & Achieve Your Dream!0:49
Download and Installations of MySQL WorkBench10:31
How to Create a Database in MySQL8:14
How to Create a Table in MySQL13:49
How to Insert Rows into Table in MySQL11:20
How to Select Data from Table in MySQL8:37
How to Update and Delete Data from a table in MySQL8:18
COMMIT, AUTOCOMMIT AND ROLLBACK in MySQL5:58
How to get Current Date and Time in MySQL6:31
Learn to work with date, time, and datetime in MySQL by creating a table, inserting current date and time, and displaying yesterday and tomorrow with plus and minus one.
What is Unique Constraint in MySQL?10:16
NOT NULL Constraint in MySQL6:57
Master the not null constraint in MySQL, applying it to salary or first name and enforcing data presence on the employees table.
Check Constraint in MySQL11:12
Default Constraint in MySQL11:33
Learn how the default constraint in MySQL auto-fills fields like GPA to 0.0 and uses a default current date and time for employment_date via alter table.
Primary Key in MySQL11:17
Auto Increment in MySQL8:43
Foreign Key in MySQL19:28
INNER, RIGHT, LEFT JOINS in MySQL8:14
Functions in MySQL6:58
Logical Operators in MySQL13:50
Master logical operators in MySQL, including and, or, not, between, and in. Learn to apply them to filter results, update records, and build precise queries.
Wild Card Characters in MySQL12:26
ORDER BY in MySQL4:29
LIMIT Clause in MySQL5:09
UNION Clause in MySQL9:31
SELF JOIN in MySQL10:50
Explore self-join in MySQL to compare a table to itself, build hierarchical supervisor relationships, and visualize data with inner and left joins.
SELF JOIN Cont9:22
VIEWS Table in MySQL6:53
Discover how MySQL views create virtual tables that mirror real tables, enabling dynamic attendance reports like students_attendance, with selecting, ordering, and dropping views.
VIEWS Table in MySQL Cont9:24
INDEX in MySQL5:21
SUBQUERY in MySQL5:35
Explore subqueries in MySQL by calculating the average GPA from the students table and using it in a nested query to list students whose GPA exceeds the average.
SUBQUERY in MySQL Cont3:24

Why did you choose to learn PostgreSQL1:54
Download and Installation of PostgreSQL5:49
Introduction to SQL Shell and PgAdmin 48:30
How to create a Database in PostgreSQL5:04
Connect to Database in PostgreSQL3:11
How to Drop Database in PostgreSQL4:47
Learn how to drop a PostgreSQL database, a dangerous operation, using drop database and \l to list databases, and handle active connections via pgadmin or SQL shell.
How to Create Table in PostgreSQL8:37
Create Table with Constraint in PostgreSQL8:11
Create a student table with constraints in PostgreSQL, enforce not null for id, first name, last name, gp, and enroll date, make email optional, and use auto increment primary key.
How to Insert Data Into Table in PostgreSQL10:40
How to Drop Column in PostgreSQL1:51
Learn how to drop a column in PostgreSQL using either the graphical interface or SQL shell, with a step-by-step example removing the GP column from the students table.
WHERE Clause in PostgreSQL2:39
Master PostgreSQL filtering with the where clause to extract records that meet specific conditions, using examples with student_id, first name, and last name fields in pgadmin queries.
How to ADD Column in PostgreSQL2:56
How to UPDATE Table in PostgreSQL5:45
How to DELETE Record in PostgreSQL2:21
Reset ID Sequence in PostgreSQL9:56
Create Large SQL Dataset using Mockaroo11:31
How to SELECT from Table in PostgreSQL4:34
ORDER BY Clause in PostgreSQL6:09
Learn how the order by clause in PostgreSQL sorts data in ascending or descending order using columns like first name, last name, and email.
DISTINCT Clause in PostgreSQL5:48
WHERE & AND Clauses in PostgreSQL5:34
Learn to apply where and and clauses in PostgreSQL to filter a students dataset by country, gender, and first name, using multiple conditions to produce precise results.
IN Keyword Clause in PostgreSQL5:16
Master the in keyword in PostgreSQL to replace long or chains, writing cleaner queries that list multiple countries (Nigeria, Brazil, China, Mexico, Yemen) and extend this pattern to other fields.
BETWEEN Clause in PostgreSQL3:59
Explore how to use the PostgreSQL between keyword to filter date ranges and IDs, with practical examples on dates and student IDs.
How to use Wild Card in PostgreSQL8:33
GROUP BY Clause in PostgreSQL4:11
HAVING Clause in PostgreSQL4:34
Learn how to use the having clause in PostgreSQL to filter grouped country counts, applying conditions like greater than, less than, and greater than or equal to 5 or 100.
COALESCE Function in PostgreSQL6:35
AGE Function in PostgreSQL5:30
Use the age function in PostgreSQL to compute student ages from enrollment dates, address negative ages by adjusting dates, and create a new table for students' age.
PRIMARY KEY in PostgreSQL7:28
Discover how PostgreSQL enforces unique identifiers with a primary key, preventing duplicate student IDs and triggering a duplicate key value error, and how to drop constraints when needed.
Add PRIMARY KEY to Existing Table6:05
UNIQUE Constraint in PostgreSQL12:32
CHECK Constraint in PostgreSQL10:24
ON Conflict DO Nothing in PostgreSQL5:34
ON Conflict DO Update in PostgreSQL9:36
How to Create a New Table in PostgreSQL6:22
Introduction to FOREIGN KEY in PostgreSQL9:29
Create and link the student and phone tables with a foreign key that references the phone table's primary key, enforcing not null and unique constraints.
Update FOREIGN KEY in PostgreSQL8:04
JOIN in PostgreSQL8:05
LEFT JOIN in PostgreSQL5:19
How to Delete FOREIGN Key in PostgreSQL6:10
How to Export SQL file in CSV format in PostgreSQL6:43

Download and Installation of MongoDB, Compass and Mongosh11:25
Install and configure MongoDB on Windows, including the community edition, compass GUI, and mongosh shell. Learn to work with collections and documents in this non-relational database.
Basics of MongoDB Database8:10
Learn the basics of MongoDB, a non-relational database using collections and documents. Start Mongo, switch databases, create a new db and a sample collection, insert and query documents.
How to Create Collections11:18
Connect MongoDB on Visual Studio Code Editor4:33
Launch MongoDB Shell in VS Code2:49
Working with MongoDB Compass4:08
How to Create Multiple Documents in MongoDB8:09
How to insert Document Using MongoDB Compass7:15
Learn to insert single and multiple documents in MongoDB Compass, format data correctly, handle errors, and manage collections within your database.
How to use MongoDB Shell inside the Compass4:46
Enable the embedded MongoDB shell inside Compass, connect to a local host, and use autocomplete to query and insert data.
Data Types8:42
Sort and Limit Methods in MongoDB8:54
Find Method in MongoDB8:51
Update Document in MongoDB17:38
Delete Document in MongoDB5:06
Learn to delete documents in MongoDB using the mongo shell, including single deletions by field value and multi deletions by a condition, with JSON export/import for backup.
Comparison Operators in MongoDB12:47
Logical Operator in MongoDB10:08
Learn how to use the and, or, and not logical operators in MongoDB to filter data by conditions like undergraduate status and age, with practical find examples.
Indexes in MongoDB10:35
How to create a Unique ID3:12
Embedded Document Type in MongoDB7:57
Nested Document inside Embedded Document10:44
How to work with Arrays inside Embedded Document11:35
Embedded Documents vs Reference Documents9:59
One to One Reference Relation in MongoDB14:15
Lookup for One to One Reference Document7:18
Master the one-to-one reference using the lookup in an aggregation to join the student and course collections, using from, local field, foreign field, and as to populate the related data.
Ordered Insertion in MongoDB7:16
Master ordered insertion in MongoDB by using custom IDs, inserting with insertMany, and handling duplicate key errors, including the effect of the ordered option.
Congratulations! Never Stop Learning...0:15

Requirements

Basic knowledge of programming concepts is helpful but not required.
A computer with an internet connection to download necessary software and tools.
Willingness to learn and explore the world of database management.

Description

Become a successful Database Analyst or Back-end developer by unlocking the power of database management and design with the MySQL, PostgreSQL, and MongoDB Database Design Masterclass! This comprehensive, three-in-one course is meticulously crafted to turn you into a database expert across three popular platforms—MySQL, PostgreSQL, and MongoDB. From installation and setup to advanced data management techniques, you'll gain the skills needed to design, maintain, and optimize databases, supporting dynamic applications and driving real-world solutions.

Starting with the fundamentals, you'll learn how to set up MySQL Workbench, PostgreSQL, MongoDB, Compass, and Mongosh. Dive into creating databases and tables, inserting and retrieving data, updating records, and managing constraints like Unique, NOT NULL, Primary Key, and Foreign Key in MySQL and PostgreSQL. You’ll also master SQL operations like JOINS, UNIONs, subqueries, indexes, and more.

Transitioning to MongoDB, the course provides essential skills for NoSQL databases. You'll discover how to create collections, insert and manage documents, use MongoDB Compass and Shell, and execute operations like sorting, limiting, updating, and deleting. Additionally, you’ll explore advanced MongoDB features, including embedded documents, array handling, one-to-one references, ordered insertions, and lookup operations.

Whether you’re aspiring to be a database administrator, backend developer, or data analyst, this course provides invaluable, hands-on expertise to handle SQL and NoSQL databases with confidence.

What You'll Learn:

Database Setup and Fundamentals: Download, install, and configure MySQL, PostgreSQL, and MongoDB with Compass and Mongosh.
SQL Database Design:
- Create databases, tables, and define data constraints (Unique, NOT NULL, Primary Key, Foreign Key, etc.) in MySQL and PostgreSQL.
- Use SQL statements to insert, select, update, and delete data.
- Implement advanced features like JOINS (INNER, LEFT), ORDER BY, LIMIT, UNION, SELF JOIN, and VIEWS.
- Apply indexing and subqueries to optimize data management.
NoSQL Database Design with MongoDB:
- Set up MongoDB, work with Compass and Shell, and integrate with Visual Studio Code.
- Design MongoDB collections and documents, manage arrays and embedded documents, and understand relationships between documents.
- Execute operations like sorting, updating, deleting, and creating one-to-one reference relations.
Advanced Database Management: Learn auto-commit, rollback, current date/time functions, logical operators, wildcards, and ordered insertions.

Course Benefits:

Comprehensive Learning: Master database management on three major platforms to become a versatile database professional.
Hands-on Practice: Apply what you learn with practical exercises and real-world scenarios to solidify your skills.
Career-Enhancing Skills: Develop a robust foundation in MySQL, PostgreSQL, and MongoDB, enhancing your appeal to potential employers.
Adaptability: Gain the ability to work across both SQL and NoSQL databases, making you indispensable in data-driven industries.

Real-World Applications:

Web and Mobile Applications: Design scalable databases for applications in e-commerce, social media, finance, and healthcare.
Data Analytics: Leverage SQL and NoSQL databases to store, manage, and analyze large datasets for data-driven decision-making.
Backend Development: Build efficient and high-performance backend systems for web and cloud applications using advanced database techniques.

Requirements:

Basic knowledge of programming concepts is helpful but not required.
A computer with an internet connection to download necessary software and tools.
Willingness to learn and explore the world of database management.

Who Should Take This Course?

Aspiring Database Administrators
Backend Developers
Data Analysts and Engineers
Students and Tech Enthusiasts interested in database management and design
Professionals looking to expand their knowledge of SQL and NoSQL databases

Who this course is for:

Aspiring Database Administrators
Backend Developers
Data Analysts and Engineers
Students and Tech Enthusiasts interested in database management and design
Professionals looking to expand their knowledge of SQL and NoSQL databases

MySQL, PostgreSQL and MongoDB Database Design Masterclass

What you'll learn

Explore related topics

Course content

Complete MySQL Database Management for Beginners33 lectures • 4hr 31min

Complete PostgreSQL Database Design Management System for Beginners40 lectures • 4hr 16min

Complete MongoDB Database Design Management System for Beginners26 lectures • 3hr 38min

Requirements

Description

Who this course is for: