Explore a comprehensive 8-hour video series on PostgreSQL databases by Hussein Nasser. Dive into advanced topics such as connection pooling, building web APIs, database cursors, sharding, partitioning, and performance optimization. Learn to work with PostgreSQL using various programming languages like JavaScript, Python, and Node.js. Discover how to set up PostgreSQL instances using Docker, enable TLS/SSL, and understand the intricacies of indexing. Gain insights into database security, performance tuning, and best practices for handling large datasets. Compare PostgreSQL with MySQL, explore new features in PostgreSQL 13 and 14, and understand complex concepts like isolation levels and query plan optimization. Perfect for backend developers looking to enhance their database management skills and optimize application performance.
Overview
Syllabus
Connection Pooling in PostgresSQL with NodeJS (Performance Numbers).
Building a Web API with Express and PostgreSQL to Consume from Browser.
Postgres Database Cursors in Python with psycopg2.
Step by Step Javascript and Postgres Tutorial using node-postgres.
Step-by-Step Python and Postgres Tutorial with psycopg2.
Spinning multiple Postgres instances and PGAdmin with Docker.
Database Sharding Crash Course (with Postgres examples).
Spinning a lightweight Postgres instance and Consume it with NodeJS.
Enabling TLS/SSL on PostgreSQL with Docker.
Database Partitioning Crash Course (with Postgres).
PostgreSQL 13 Has Some Performance Boosts! Let us discuss it!.
Indexing in PostgreSQL vs MySQL.
Be careful while working with large text fields in Postgres - TOAST.
Postgres Instances hacked and used to mine crypto - Let us discuss how is that possible.
Combining Database Indexes for Better Performance in Your Backend Applications (with PostgreSQL).
don’t use “offset” in your SQL.
Burned by Docker and it was my fault.
Bitmap Index Scan in Postgres Explained with Examples (Members only).
Create Postgres Table with a MILLION Rows (from scratch).
Create Index Blocking Production Database Writes? Postgres Solves this with this trick.
Is SELECT * Expensive?.
SELECT COUNT (*) can impact your Backend Application Performance, here is why.
70GB of Unused Bloated Index Space Freed on Postgres, Here is how they did it.
Serializable vs Repeatable Read Isolation Level - When to use one over the other in Database Systems.
Explain Explained in PostgreSQL - How Databases Prepare Optimal Query Plans to Execute SQL.
The New Postgres 14 Looks Promising - The Backend Engineering Show with Hussein Nasser.
backend leaking Postgres database connections - what I did to fix it.
The cost rolling back transactions (postgres/mysql).
Taught by
Hussein Nasser
