MySQL, PostgreSQL and MongoDB Database Design Masterclass
3 in 1 SQL Course | Master Database Design and Management with MySQL, PostgreSQL, and MongoDB for Robust Applications
4.85 (36 reviews)
2,239
students
12.5 hours
content
Mar 2025
last update
$94.99
regular price
What you will 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.
6214927
udemy ID
10/2/2024
course created date
11/12/2024
course indexed date
Bot
course submited by