Play all

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)

Description:

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.

PostgreSQL

Hussein Nasser

Add to list

#Programming #Databases #Relational Databases #PostgreSQL #Programming Languages #Python #Computer Science #DevOps #Docker #Javascript #Node.Js