SQL asoslari

Kerakli ustun va qatorlarni tanlash. Nazariya: select, where, distinct, like, null-values.

ORDER BY, LIMIT, CASE va ifodalar. Nazariya: order-by, limit, case-when, string-functions.

GROUP BY, COUNT, AVG va HAVING. Nazariya: group-by, aggregation, having, date-functions.

Bir nechta jadvalni bog‘lash: JOIN va LEFT JOIN. Nazariya: join, left-join.

Ichki so‘rovlar va oyna funksiyalari. Nazariya: subquery, window-functions.