🗄️ SQLite3 Darsliklar

1-dars: SQLite nima? - Ma'lumotlar bazasi tushunchasi 2-dars: SQLite o'rnatish - Linux, MacOS, Windows 3-dars: Asosiy buyruqlar - .open, .tables, .schema, .help 4-dars: SQLite CLI bilan ishlash 5-dars: Ma'lumotlar bazasi yaratish va boshqarish 6-dars: SQLite vs MySQL vs PostgreSQL taqqoslash 7-dars: SQLite afzalliklari va cheklovlari

8-dars: CREATE TABLE - Jadval yaratish 9-dars: INSERT INTO - Ma'lumot qo'shish 10-dars: SELECT - Ma'lumotlarni tanlash 11-dars: WHERE shartlari - =, <, >, !=, BETWEEN, LIKE 12-dars: UPDATE - Ma'lumotlarni yangilash 13-dars: DELETE - Ma'lumotlarni o'chirish

14-dars: Ma'lumot turlari - TEXT, INTEGER, REAL, BLOB, NULL 15-dars: Constraint-lar - PRIMARY KEY, UNIQUE, NOT NULL, DEFAULT 16-dars: Index yaratish va boshqarish 17-dars: ORDER BY - Saralash 18-dars: GROUP BY va Aggregation - COUNT, SUM, AVG, MIN, MAX

19-dars: JOIN operatsiyalari - INNER, LEFT, RIGHT, CROSS 20-dars: Subqueries - Ichki so'rovlar 21-dars: Triggers - Avtomatik ishlaydigan kod 22-dars: Views - Saqlangan so'rovlar 23-dars: Transactions - BEGIN, COMMIT, ROLLBACK

24-dars: CLI bilan ishlash - Terminal orqali test 25-dars: Python bilan ulash - sqlite3 moduli 26-dars: Django/Flask da SQLite ishlatish 27-dars: Backup va eksport - .dump, .import

28-dars: Query optimization - EXPLAIN QUERY PLAN 29-dars: Sharding va limits - Qachon boshqa DBMS ga o'tish 30-dars: Security - Parol himoyasi va fayl darajasida himoya 31-dars: Foreign Keys - PRAGMA foreign_keys = ON

32-dars: Real loyiha - Todo App yoki Contacts Manager 33-dars: Django/Flask kichik blog loyihasi 34-dars: SQL mashqlari - LeetCode va Hackerrank