SQL and PostgreSQL using pgAdmin4 : Beginner to Expert

Explore PgAdmin 4 to interact with Postgres databases, manage schemas and tables, run sql queries via the query tool, and export results to csv or excel.

load a sample data set into Postgres using pgAdmin 4 by creating a table and importing data from CSV, either via the UI or via a copy command.

Explore select and from basics in sql with pgadmin4, retrieving fields from a table, using star, aliasing tables, and applying limit and aggregate functions like count and sum.

Learn to create tables and insert data in PostgreSQL, define schemas with primary key, not null, unique, and foreign key constraints, and copy schemas with as and where 1=2.

Learn to use where keyword to filter data on the sales order table with conditions such as greater than 1000, between 1000 and 2000, not null, like, and not in.

Sort query results with order by and control rows using limit, offset, or fetch, demonstrated by sorting on gross sales and platform across the sales data.

Learn how to use group by and having in PostgreSQL to perform aggregations, such as total gross sales by platform, with filtered results.

Explore how to determine a table's granularity by examining the schema, forming hypotheses about the grain, and validating with group by and having counts using a sales order example.

Explore joins in Postgres, including inner, left, right, full outer, self, and cross joins, with practical syntax and examples using pgAdmin4.

Learn how union, union all, intersect, and except combine query results by appending rows, deduplicating outputs, finding intersections, and computing differences across data snapshots.

Understand the writing and execution sequence of SQL queries in pgAdmin4, mastering the keyword order from select to limit and how the server processes joins and filters.

Explore case when statements in Postgres to implement if-else logic within a single query. Learn syntax with when-then-else, nested cases, multiple conditions, optional else, and aggregation using group by.

Learn to use where with left, right, or full outer joins in PostgreSQL, compute 2014 first purchases, and determine the 30-day repeat rate while preserving nulls.

Explore subqueries in Postgres for data analytics, learning to nest queries, filter orders by average sales, and use exists, any, and all in where clauses and joins.

Learn a practical cross join workflow to identify sister subcategories across furniture, technology, and office supplies by computing Euclidean distances and ranking nearest matches.

Explore self join and natural join in Postgres, using inner joins on the same table and joins without an on condition, with examples from demographics by state.