SQL & Data Analitika

5 ta darslik • 4 ta modul

4.9(150 baho)505o‘quvchi750ko‘rishIzohlar

0 / 5 tugatildi

0% bajarildi

O‘qishni davom ettirish

#1. 1-Dars: Relyatsion Ma'lumotlar Bazasi & SQL SELECT Asoslari

1-Modul: SQL Asoslari & Filtrlash • Relyatsion baza nima (PostgreSQL, MySQL), jadvallar tuzilishi, SELECT, WHERE, ORDER BY va LIMIT.

(1 dars)

Relyatsion baza nima (PostgreSQL, MySQL), jadvallar tuzilishi, SELECT, WHERE, ORDER BY va LIMIT.

(1 dars)

Bir nechta jadvallarni foreign key orqali birlashtirish, xaridorlar va ularning buyurtmalarini tahlil qilish.

(1 dars)

COUNT, SUM, AVG, MIN, MAX orqali daromad, foydalanuvchilar soni va o'rtacha chekni hisoblash.

(2 dars)

OVER(PARTITION BY ... ORDER BY ...) yordamida qatorlarni guruh ichida reytinglash va o'suvchi jami (Running Total).

Common Table Expressions (WITH), kohort tahlili (Cohort Retention) va mijozlarning qaytish dinamikasi.

Izoh qoldirish uchun iltimos tizimga kiring.

Izohlar yuklanmoqda...