Asosiy mazmunga o'tish

SQL va PostgreSQL asoslari

Beginner Bepul

SELECT'dan GROUP BY va HAVING'gacha — ma'lumotlar bazasidan kerakli ma'lumotni olish san'ati.

Hali baholanmagan (1 talaba)
23 dars 5 soat Yangilandi: 27.08.2026
O'qituvchi Islomjon Ikromov

Kurs haqida

  • 23 video dars
  • 5 soatlik kontent
  • Beginner darajasi
  • Doimiy ruxsat
  • Mobil va desktop
  • Yakuniy sertifikat

Har qanday dasturchi uchun SQL majburiy ko'nikma. Kursda PostgreSQL va pgAdmin o'rnatiladi, so'ng SELECT, DISTINCT, WHERE, ORDER BY, LIMIT, BETWEEN, IN, LIKE kabi so'rovlar amaliy misollar va mustaqil topshiriqlar bilan o'rganiladi. Yakunida agregat funksiyalar, GROUP BY va HAVING orqali hisobotlar tayyorlashni bilib olasiz.

Manba: ushbu kurs PostgreSQL Tutorial for Beginners video darsligi asosida tuzilgan (muallif: freeCodeCamp.org). Har bir dars videoning aynan kerakli daqiqasidan boshlanadi.

Kurs tarkibi

23 dars · 5 soat
Boshlash 2 dars
SELECT so'rovlari 5 dars
  • SELECT operatori 10 min
  • Amaliyot: SELECT 4 min
  • SELECT DISTINCT 8 min
  • Amaliyot: DISTINCT 2 min
  • COUNT funksiyasi 13 min
Filtrlash va tartiblash 9 dars
  • WHERE sharti 8 min
  • WHERE: amaliy misollar 9 min
  • Amaliyot: WHERE 17 min
  • ORDER BY 7 min
  • LIMIT 7 min
  • BETWEEN 7 min
  • IN operatori 6 min
  • LIKE va ILIKE 17 min
  • Umumiy amaliyot 3 min
Guruhlash va hisobotlar 6 dars
  • Agregat funksiyalar 6 min
  • GROUP BY 6 min
  • GROUP BY: amaliy misol 11 min
  • Amaliyot: GROUP BY 1 min
  • HAVING 10 min
  • AS — ustunga nom berish 5 min
Yakuniy loyiha 1 dars
  • Mustaqil loyiha: savdo hisoboti 120 min

O'qituvchi

Islomjon Ikromov

Islomjon Ikromov

mcxacker7@gmail.com 998913595069