Complete Database Course: SQL, MySQL, PostgreSQL & MongoDB

Create PostgreSQL tables with the create table statement, defining columns, data types, primary keys, and not null constraints, with examples like company and department tables.

Explore using the PostgreSQL insert into statement to add rows with explicit columns, use default values, and perform multiple inserts in employee and product tables.

Learn how to fetch data from PostgreSQL tables using multiple queries, including selecting top rows with order by and offset, and display results from article and employee tables.

Learn how to drop single and multiple columns in PostgreSQL tables using drop column, with practical examples on the employees table, removing email, department ID, and manager ID.

Learn how to drop tables in PostgreSQL using the drop table statement, removing one or multiple tables to free up resources, verify with selects, and read confirmation messages.

Explore PostgreSQL operators (comparison, arithmetic, and logical) applied to the employees table, including greater-than filters, salary adjustments, and combining conditions.

Learn how to use the PostgreSQL select statement to query data from one or more tables, retrieve all or specific columns, and apply filtering with where conditions.

Sort PostgreSQL query results with the order by clause, applying ascending or descending order on one or more columns, including last name, age, department, and salary.

Learn how PostgreSQL limit and offset control query results, fetch subsets of rows, and apply order by salary descending to retrieve specific records.

Explore the PostgreSQL minimum and maximum functions to find the smallest and largest values in a salary column from the employee table, including filtering by the HR department.

Explore PostgreSQL aggregate functions count, sum, and avg to count rows, total salaries, and the average salary, with filtering by IT department.

Group rows in PostgreSQL with group by, apply aggregate functions like count and average, and refine results using having on single and multi-column groupings (employee_id and age) to analyze salary.

Explore the PostgreSQL exists operator, use it with correlated subqueries to drive conditional logic, and apply it in select and update statements involving customers and cars tables.

Learn how to create a MongoDB database using the use command and compass, create collections, manage test databases, and perform basic database operations including drop, index, and validation.

Learn how to create and manage MongoDB collections using the shell and MongoDB compass, including naming databases and collections, and performing export, update, and delete operations.

Learn how to insert data into MongoDB collections using the insert document approach, select a database like testdb, and add multiple documents with fields such as name, age, and email.

Explore MongoDB find queries in the shell, retrieving documents from the students collection with conditions and nested fields, including address subdocuments and city filters.

Learn to update MongoDB documents in the students collection using update one and update many in the MongoDB shell, setting fields such as name, age, and status to active.

Explore MongoDB delete operations in the shell, including delete one, delete many, and conditional deletions on the students collection using fields like name, city, and age.

Explore MongoDB query operators in the shell, performing advanced queries with find and $gt for ages, and using $set, illustrated by a Los Angeles example.

Explore MongoDB update operators using the MongoDB shell to modify documents in a collection, including $set, $unset, $inc, and $push, with practical examples.

Explore MongoDB aggregations in the shell using the aggregation framework, filtering documents with match, grouping by fields, and computing sums to reveal totals by category.

Explore how to enforce data integrity in MongoDB by configuring validation rules on collections, and practice creating collections, inserting documents, and verifying results.