This course covers learning outcomes such as understanding PostgresSQL connection pooling, building web APIs with Express and PostgreSQL, utilizing Postgres database cursors in Python, and enabling TLS/SSL on PostgreSQL. Students will also learn about database sharding, partitioning, indexing, and optimizing backend application performance with Postgres. The course teaches skills such as working with NodeJS, Express, Python, Docker, and database optimization techniques. The teaching method includes step-by-step tutorials, crash courses, and discussions on various Postgres-related topics. The intended audience for this course includes developers, database administrators, and anyone interested in enhancing their knowledge of PostgresSQL.
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
