Advanced PostgreSQL: complex queries, window functions, full-text search, JSON operations, and performance tuning.