Complete SQL Bootcamp using PostgreSQL.

shows you PgAdmin 4 Overview

Import Database in PostgreSQL

shows you how to query data from a single table.

guides you how to sort the result set returned from a query.

provides you a clause that removes duplicate rows in the result set.

filters rows based on a specified condition.

gets a subset of rows generated by a query.

filters data based on pattern matching.

selects data that matches any value in a list of values.

selects data that is a range of values.

checks if a value is null or not.

selects rows from one table that have the corresponding rows in other tables.

selects rows from one table that may or may not have the corresponding rows in other tables.

joins a table to itself by comparing a table to itself.

uses the full join to find a row in a table that does not have a matching row in another table.

joins two or more tables using implicit join condition based on the common column names in the joined tables.

applies the condition for groups.

combines result sets of multiple queries into a single result set.

combines the result sets of two or more queries and returns a single result set that has the rows appear in both result sets.

returns the rows in the first query that does not appear in the output of the second query.

generate multiple grouping sets in reporting.

writes a query nested inside another query.

query data by comparing a value with a list of values returned by a subquery.

retrieves data by comparing a value with a set of values returned by a subquery.

inserts data into a table.

updates existing data in a table.

updates values in a table based on values in another table.

deletes data in a table.

covers the most commonly used PostgreSQL data types.

guides you how to create a new table in the database.

changes structure of an existing table.

adds logic to check value based on a Boolean expression.

illustrates how to define a primary key when creating a table or add a primary key to an existing table.

shows you how to define foreign key constraints when creating a new table or add foreign key constraints for existing tables.

PostgreSQL date functions that allow you to manipulate date and time values more effectively.

PostgreSQL date functions that allow you to manipulate date and time values more effectively.

PostgreSQL string functions that allow you to manipulate string data effectively.

PostgreSQL string functions that allow you to manipulate string data effectively.