🧭
SQL
O'RGANISH
XARITASI
Ma'lumotlar bazasi olamini kashf eting
✦ Boshliqdan Ustaga qadar yo'l xaritasi ✦
N
1
🏕️
BOSHLIQ
Ma'lumotlar Bazasi Asoslari
Ma'lumotlar bazasi nima?
RDBMS tushunchasi
Jadval, ustun, qator
Primary key & Foreign key
MySQL / PostgreSQL o'rnatish
⏱ 1–2 hafta
2
📜
BOSHLIQ
Asosiy SQL Buyruqlari
SELECT, FROM, WHERE
INSERT, UPDATE, DELETE
ORDER BY, LIMIT
DISTINCT va aliases
NULL bilan ishlash
⏱ 2 hafta
3
🔢
BOSHLIQ
Funksiyalar va Filtrlar
COUNT, SUM, AVG, MAX, MIN
GROUP BY va HAVING
LIKE, BETWEEN, IN
String funksiyalari
Date/Time funksiyalari
⏱ 2 hafta
4
🌉
O'RTA DARAJA
JOIN — Jadvallarni Birlashtirish
INNER JOIN
LEFT / RIGHT JOIN
FULL OUTER JOIN
CROSS JOIN
Self JOIN
⏱ 2–3 hafta
5
🏗️
O'RTA DARAJA
DDL — Struktura Yaratish
CREATE TABLE, DATABASE
ALTER TABLE
DROP va TRUNCATE
Ma'lumot turlari
Constraints (CHECK, UNIQUE)
⏱ 1–2 hafta
6
🗂️
O'RTA DARAJA
Subquery va View
Nested subquery
Correlated subquery
EXISTS / NOT EXISTS
VIEW yaratish
Materialized View
⏱ 2 hafta
7
🔮
YUQORI DARAJA
Window Funksiyalari
ROW_NUMBER, RANK, DENSE_RANK
OVER() va PARTITION BY
LAG / LEAD
FIRST_VALUE / LAST_VALUE
NTILE, CUME_DIST
⏱ 2–3 hafta
8
⚡
YUQORI DARAJA
Indeks va Optimallashtirish
B-Tree va Hash indeks
EXPLAIN / ANALYZE
Query optimallashtirish
Composite Index
Slow query profiling
⏱ 3 hafta
9
🔐
YUQORI DARAJA
Tranzaksiya va Xavfsizlik
ACID tamoyillari
BEGIN, COMMIT, ROLLBACK
Isolation levels
GRANT / REVOKE
SQL Injection himoyasi
⏱ 2 hafta
🏆
AMALIYOT LOYIHA
Ustaga Yo'l — Real Loyiha
Stored Procedures
Triggers va Events
CTE (WITH clause)
Normalization (1NF–3NF)
Real loyiha: e-commerce DB
LeetCode SQL muammolari
O'rta daraja
Boshliq daraja
Yuqori daraja
🗺️ Umumiy muddat: 4–6 oy