SQL va PostgreSQL asoslari

Beginner Free

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

Hali baholanmagan (1 student)

23 lessons 5 h Updated: 27.08.2026

Instructor Islomjon Ikromov

About the Course

23 video lesson
5 hours of content
Beginner level
Permanent access
Mobile and desktop
Final certificate

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.

Course contents

23 lessons · 5 h

Boshlash 2 lessons

PostgreSQL bilan tanishuv View 2 min
O'rnatish va namuna bazani ulash 15 min

SELECT so'rovlari 5 lessons

SELECT operatori 10 min
Amaliyot: SELECT 4 min
SELECT DISTINCT 8 min
Amaliyot: DISTINCT 2 min
COUNT funksiyasi 13 min

Filtrlash va tartiblash 9 lessons

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 lessons

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 lessons

Mustaqil loyiha: savdo hisoboti 120 min

Instructor

Islomjon Ikromov

mcxacker7@gmail.com 998913595069