6 SQL Skills Every Backend Engineer Should Know

Become a senior software engineer with a job guarantee: https://go.hayksimonyan.com/179-sql Stop letting your ORM hide performance bottlenecks and master the core SQL concepts every backend engineer needs to know. ⏱️ Timestamps: 0:00 - Why backend engineers need raw SQL 0:51 - Reading data from the database 4:46 - Writing data to the database 7:13 - 4 types of SQL joins 10:40 - SQL execution order 11:46 - Subqueries and common table expressions 14:21 - SQL window functions 16:10 - UPSERT and write patterns 16:57 - NULL is not a value 18:20 - Fixing the ORM N+1 problem 20:30 - ORM habits to have