Skip to Content
PROGRAMMING

SQL

Practical courses for the work we actually do. Pick one, finish it, and apply it.

Any category Programming1 SQL 1
Any topics Databases 1 Performance Optimization 1 Testing and Debugging 1
Any level Beginner 1 Intermediate 1 Advanced 1
SQL Databases Advanced Clear filters 1 result
0 likes
SQL Advanced: Queries That Hold Up Under Load

Read query plans, choose the right index and change live tables safely. You will read an EXPLAIN ANALYZE plan line by line, pick between B-tree, GIN, GiST and BRIN indexes, understand MVCC, locks and deadlocks, and run migrations and backups that you have proved on a copy. If you skip the plans, the locks and the restore test, your queries will pass on a small table and fail when the table is large and busy.

2h 30m 17 lessons