0 views
Read
#0
Learn SQL with PostgreSQL - Prerequisite Skills & Environment Setup
Before diving deeper into SQL and PostgreSQL, there are several basic skills and tools you need to prepare first, ranging from your ability to operate a terminal, installing the PostgreSQL server, to getting to know psql and GUI clients to make exploring your database easier.
August 3, 2026
00
Read
#1
Learn SQL with PostgreSQL - History, RDBMS Concepts & Why Choose PostgreSQL
This episode covers the birth of the relational data model from Edgar F. Codd in 1970, PostgreSQL's evolution from the Ingres project at UC Berkeley to its official name, the reasons why PostgreSQL has become the database of choice in the modern world, as well as its comparison with MySQL, MariaDB, and SQLite.
August 3, 2026
00
Read
#2
Learn SQL with PostgreSQL - Relational Design Concepts, Normalization & DDL
This episode covers the foundations of relational database design: Entity Relationship Diagrams, Primary Keys and Foreign Keys, data normalization principles from 1NF to BCNF, as well as hands-on practice with Data Definition Language (DDL) for creating, altering, and dropping databases and tables.
August 3, 2026
00
Read
#3
Learn SQL with PostgreSQL - Data Types & Constraints Management
This episode covers PostgreSQL's main data types: numeric, character, date and time, boolean, and UUID. It also covers constraint management such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY with referential actions, and CHECK to maintain data integrity.
August 3, 2026
00
Read
#4
Learn SQL with PostgreSQL - Data Manipulation Language (DML) & Basic Querying
This episode covers Data Manipulation Language (DML): INSERT to insert data, UPDATE to modify it, and DELETE to remove it. It also covers PostgreSQL's signature feature, the RETURNING clause, for directly retrieving data that was just manipulated.
August 3, 2026
00
Read
#5
Learn SQL with PostgreSQL - Filtering, Sorting, Paging & Aggregation Queries
This episode covers reading and processing data: SELECT with aliases and DISTINCT, filtering with comparison and logical operators, sorting with ORDER BY, paging with LIMIT OFFSET, and data aggregation using GROUP BY and HAVING.
August 3, 2026
00
Read
#6
Learn SQL with PostgreSQL - Advanced Table Joins (Relationships Between Tables)
This episode covers the concept of joins in relational databases: INNER JOIN, LEFT RIGHT and FULL OUTER JOIN, CROSS JOIN, as well as SELF JOIN for hierarchical data, including techniques for combining three or more tables in a single query.
August 3, 2026
00
Read
#7
Learn SQL with PostgreSQL - Subqueries, Set Operations & Expressions
This episode covers subqueries in the WHERE FROM and SELECT clauses, the CASE WHEN branching logic, the NULL-handling functions COALESCE and NULLIF, and the set operations UNION, INTERSECT, and EXCEPT for combining the results of multiple queries.
August 3, 2026
00
Read
#8
Learn SQL with PostgreSQL - Advanced Data Types: JSONB & Array Support
This episode covers PostgreSQL's hybrid side as an RDBMS and document store at the same time: the difference between JSON and JSONB, JSONB query operators such as the arrow operators and @>, the jsonb_set manipulation function, and the array data type with the ANY, @>, and UNNEST operators.
August 3, 2026
00
Read
#9
Learn SQL with PostgreSQL - Window Functions (Advanced Data Analytics)
This episode covers window functions for advanced data analysis: the difference from GROUP BY, the anatomy of the OVER clause with PARTITION BY and window framing, the ranking functions ROW_NUMBER RANK DENSE_RANK NTILE, and the value functions LAG LEAD FIRST_VALUE and LAST_VALUE.
August 3, 2026
00