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

Create MySQL databases using the create database statement, set default character sets, and verify creation with if not exists.

Learn how to delete an existing database in MySQL with drop database and drop database if exists, illustrated by company and sales databases, including confirmation checks.

Learn to create tables in MySQL by defining an employees table (id, first_name, last_name, email, hire_date) and a products table (id, name, price, stock quantity).

Learn how to use the MySQL drop table statement to delete existing tables, handle if exists cases, and manage foreign key relationships across employees, products, and orders with practical examples.

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.

Set not null constraints in MySQL to enforce data integrity by ensuring columns like title and start date and end date always have values.

Learn how the MySQL unique constraint enforces data integrity by creating a student table with a unique email, then altering the table to add the constraint and insert unique records.

Learn how the primary key constraint in MySQL uniquely identifies each record, prevents duplicates, and is demonstrated through student and employee tables.

Establish relational links in MySQL by creating a foreign key constraint between customers.id and orders.customer_id, enforcing referential integrity and demonstrating creation, alteration, verification, and removal.

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.

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.

Explore MySQL views as virtual tables derived from underlying tables, create and replace views, query via select from a customer table, verify results, and apply check option.

Master adding and dropping columns in MySQL by altering the students table, adding email, dropping age, and positioning new columns with after, plus basic create and insert operations.

Create a PostgreSQL table by defining columns, data types, and constraints like primary key and not null; explore practical examples with company and department tables and table verification.

Learn to insert data into a PostgreSQL table using insert into, with explicit column lists and values, including default values and verification via select.

Fetch data from PostgreSQL using select queries, order by article_id in ascending order; retrieve the first three rows, use offset for pages, and view id, first_name, and last_name from employees.

Learn how to add columns to an employees table with alter table in PostgreSQL, including creating a status column with a default value and enforcing not null constraints on department_id.

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.

Modify existing columns in a PostgreSQL table using the alter column statement and alter table commands, adding new columns like gender and department, then drop the department column.

Drop columns in PostgreSQL using alter table drop column to remove single or multiple columns from the employees table, such as email, department_id, and manager_id.

Explore deleting data in PostgreSQL with the delete statement, using where clauses to remove specific rows, delete all rows, and verify changes in articles and company tables.

Learn how to use the PostgreSQL drop table statement to remove one or more tables, free resources, and verify deletions with practical examples.

Explore PostgreSQL operators for comparison, arithmetic updates, and logical conditionals using and, or, and not on an employees table.

Explore how the where clause filters rows in SQL using simple and multiple conditions, such as department, salary, and age, plus pattern matching with like in PostgreSQL.

Sorts query results with the order by clause in PostgreSQL, demonstrating ascending and descending orders by last name, department, and salary across multiple columns.

Learn how the limit clause in PostgreSQL controls the number of rows returned by a select, with offset for paging and order by salary to fetch the first three records.

Explore the PostgreSQL min and max functions to find the smallest and largest salaries in the employee table, with examples using where clauses for HR and CRM departments.

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.

Master cross join in PostgreSQL to generate the cartesian product of two tables, showing practical examples with employee and contractors data.

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.

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.

Explore how to create a database in MongoDB using the use command in the shell and the Compass GUI, then create collections and drop databases via the connect button.

Learn how to create collections in MongoDB using shell and Compass, organize data into databases and collections, and perform basic operations such as export, update, delete documents, and drop databases.

Learn how to insert data into a MongoDB collection using insert and insert many, with examples of single and multiple documents via shell or compass.

Use the MongoDB shell to execute find queries on the students collection, retrieve all documents, and filter by age greater than or equal to 30 or nested fields like address.city.

Learn to update MongoDB documents using the shell, performing single and multiple updates in the students collection with fields like name, age, city, and status.

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.

Explore MongoDB query operators in the shell, including equality, greater-than, and in-array queries, with practical examples using age, city, and document retrieval.

Discover how to perform complex data manipulation with the MongoDB aggregation framework in the shell, using match filters, group operations, and sums.

Learn to create MongoDB indexes with the shell to boost query performance. Build single-field, compound, unique, and text indexes on name, city, email, and description.

Learn to enforce data integrity and consistency in MongoDB by writing validation rules with the MongoDB shell, creating collections, and inserting documents such as name and price in nonfiction.

Learn how to interact with MongoDB data programmatically through a data API and the MongoDB shell, performing find, insert, update, and delete operations on the students collection.

Learn to create MongoDB charts from the shell by aggregating the students collection, grouping by city, counting documents, and rendering bar and pie charts.