JOIN va Agregatsiyalar
SELECT u.name, COUNT(p.id) as total_posts
FROM users u
LEFT JOIN posts p ON p.author_id = u.id
GROUP BY u.name
ORDER BY total_posts DESC;LEFT JOIN orqali har bir foydalanuvchining jami postlari sonini hisoblash
SELECT name, salary,
DENSE_RANK() OVER (ORDER BY salary DESC) as rank
FROM employees;Window funksiyasi (DENSE_RANK) orqali maoshlar reytingini tuzish
Tranzaksiyalar (ACID)
BEGIN;
UPDATE accounts SET balance = balance - 100 WHERE id = 1;
UPDATE accounts SET balance = balance + 100 WHERE id = 2;
COMMIT;Xavfsiz pul o'tkazmasi tranzaksiyasi (agar bitta joyda xato bo'lsa ROLLBACK qilinadi)
Amaliy Maslahatlar va Xavfsizlik
WHERE shartida tez-tez ishlatiladigan ustunlarga B-Tree indeks qo'ying
Har doim so'rov tezligini EXPLAIN ANALYZE buyrug'i orqali o'lchang