SQL, MYSQL, POSTGRESQL & MONGODB: All-in-One Database Course

Name: SQL, MYSQL, POSTGRESQL & MONGODB: All-in-One Database Course
Rating: 3.9 (393 reviews)

Master the Fundamentals and Advanced Techniques of SQL, MySQL, PostgreSQL, and MongoDB with This All-in-One Course..

Created bySara Academy

Last updated 5/2025

English

What you'll learn

SQL Syntax
SQL Where, Order By, AND, OR, NOT
SQL Insert, Update, Delete
MYSQL Create Database
MYSQL Create Table
MYSQL Primary Key & Foreign Key
MYSQL Date & View
PostgreSQL Create, Update & Delete Table
PostgreSQL Operator, Select, Limit, MIN & MAX
PostgreSQL COUNT, SUM, AVG, Exit
MongoDB Create DataBase
MongoDB Find, Update & Delete
MongoDB Indexing, Validation
MongoDB Data API & Chart

Course content

4 sections • 58 lectures • 6h 7m total length

SQL Syntax7:03
Master sql syntax to create tables, insert data, and perform select and update operations on an employees table, with columns like employee id, first name, last name, age, and department.
SQL Where6:25
Learn how the SQL where clause filters records using conditions like department = IT and age > 30, combines criteria with and/or, and uses like for names starting with J.
SQL Order By6:37
SQL AND, OR and NOT7:10
Learn how to use SQL and, or, and not to build complex query conditions with practical examples filtering by department and age in the employees table.
SQL Insert Into10:09
SQL Null Values6:59
SQL Update7:05
explain how the sql update statement modifies existing records, demonstrating single and multiple row updates using set and where clauses, including updates to age and department fields.
SQL Delete4:45
SQL Min and Max6:32
Master the min and max functions in SQL by calculating the smallest and largest values in the employees table, such as minimum age and maximum salary, with conditions.
SQL Count, Sum, Avg6:26
Explore the SQL aggregate functions count, sum, and average with practical examples on the employees table, including total employees, total salary, and average age on groups of records.
SQL Union6:32
SQL Group By6:10
SQL Operator6:03
NULL Values9:33
Create tables with nullable and non-nullable columns, insert records, and practice querying null values using SQL Server Management Studio with is null and isnull.
SELECT TOP7:15

Create DataBase6:44
Create MySQL databases using the create database statement, set default character sets, and verify creation with if not exists.
Drop DataBase5:25
Create Table6:30
Drop Table4:39
Alter Table7:38
Learn how to alter tables in MySQL to add, modify, and drop columns, with practical examples on employees and products tables to manage phone numbers and price.
Not Null8:10
Unique Key5:33
Primary Key7:32
Foreign Key6:58
Default Key6:27
Explore how MySQL's default constraint assigns automatic values to table columns, with practical examples creating and altering a students table, inserting and updating records using inactive as the default.
Date5:49
Discover how to use the MySQL date data type to store and compare dates, with an events table (event_id, event_name, event_date), inserting correctly formatted data and querying by date.
Views6:49
Adding & Dropping Columns7:03

Create Table6:31
Insert Into6:55
Fetch Data6:20
Add Column6:06
Update5:56
Learn to use the update statement in MySQL and PostgreSQL to modify existing records, update specific columns like salary and address, and apply conditions with where clauses.
Alter Column6:03
Drop Column6:11
Delete6:51
Drop Table5:11
Operators6:44
Select5:32
Order By5:39
Sorts query results with the order by clause in PostgreSQL, demonstrating ascending and descending orders by last name, department, and salary across multiple columns.
Limit6:09
Min and Max4:57
Count, Sum, Avg5:06
Explore PostgreSQL aggregate functions with count, sum, and average applied to the employees table, showing row counts, total salary from the salary column, and the IT department filter.
Cross Join5:21
Group By5:07
Explore the group by clause in PostgreSQL to group rows by one or more columns and apply aggregate functions such as count and average, including having filters.
Exists6:19
Discover how the exist operator in PostgreSQL checks if a subquery returns any row, using a correlated subquery to drive conditional logic between customers and cars by price.

MongoDB Create DB5:09
MongoDB Collection5:11
MongoDB Insert5:28
MongoDB Find7:09
MongoDB Update5:52
MongoDB Delete5:41
Learn how to delete documents in MongoDB using the shell, including deleting a single document, deleting multiple documents by city or age, and conditional deletions in the students collection.
MongoDB Query Opertors5:28
MongoDB Aggregations4:59
MongoDB Indexing6:00
MongoDB Validation7:07
MongoDB Data API5:55
MongoDB Chart6:46
Learn to create MongoDB charts from the shell by aggregating the students collection, grouping by city, counting documents, and rendering bar and pie charts.

Requirements

No prior knowledge is required!

Description

Master the art of database management and development with this comprehensive course that covers SQL, MySQL, PostgreSQL, and MongoDB. Whether you're a beginner looking to understand the basics or an experienced developer aiming to expand your database expertise, this course provides everything you need to manage, optimize, and secure databases across multiple platforms.

Starting with SQL, you’ll learn the fundamentals of database querying and data manipulation. You’ll then dive into MySQL and PostgreSQL, exploring advanced features, performance optimization, and complex data structures. Finally, you’ll explore MongoDB, the leading NoSQL database, to understand how to manage unstructured data and create flexible, scalable applications.

This all-in-one course is packed with hands-on exercises, real-world projects, and expert guidance, ensuring you gain practical experience and the confidence to work with databases in any environment. By the end, you'll have a strong command of both relational and non-relational databases, making you a versatile and in-demand professional in the field of data management.

What You'll Learn:

SQL Fundamentals: Master the basics of SQL, including data querying, manipulation, and complex joins.
MySQL: Learn to design, implement, and optimize databases using one of the most popular relational database management systems.
PostgreSQL: Dive into advanced features like indexing, triggers, and stored procedures, and learn to manage large-scale databases efficiently.
MongoDB: Explore NoSQL concepts, work with JSON-like documents, and develop scalable, flexible database solutions.
Real-World Projects: Apply your skills in practical scenarios, including database design, optimization, and migration across different platforms.
Best Practices: Understand industry standards for database security, backup, and recovery.

Who This Course is For:

Aspiring database administrators and developers looking to gain a strong foundation in both relational and NoSQL databases.
Software developers who want to enhance their database management skills across multiple platforms.
Data analysts and engineers seeking to understand database architectures and improve data handling efficiency.
Anyone interested in mastering a versatile set of tools for database management, from SQL to modern NoSQL technologies.

By enrolling in this course, you’ll gain the skills to manage and optimize databases across different platforms, making you a valuable asset in any data-driven environment. Whether you're looking to start a new career or upgrade your existing skills, this course offers everything you need to become a database expert. Start your journey to mastering databases today!

Who this course is for:

Anyone interested in mastering a versatile set of tools for database management

SQL, MYSQL, POSTGRESQL & MONGODB: All-in-One Database Course

What you'll learn

Explore related topics

Course content

SQL15 lectures • 1hr 45min

MYSQL13 lectures • 1hr 25min

PostgreSQL18 lectures • 1hr 47min

MongoDB12 lectures • 1hr 11min

Requirements

Description

Who this course is for: