Ma'lumotlar bazalari (PostgreSQL) — DevOps Study | HackNow

arrow_backDevOps Study

Module 20Intermediatemenu_book10 lessonsschedule~30 hbolt1200 XP

Ma'lumotlar bazalari (PostgreSQL)

PostgreSQL 16 ni noldan ishlab chiqarish darajasigacha: SQL asoslari, sxema dizayni, indekslar va EXPLAIN, tranzaksiyalar va poyga, oyna funksiyalari, JSONB, rollar va RLS, zaxira va PITR, sekin so'rov tashxisi hamda real migratsiya vazifalari. 100 ta interaktiv lab — har biri sandbox ichida HAQIQIY PostgreSQL ustida ishlaydi.

0/10 · 0%

0%

Progress

ContinuePostgreSQL asoslari: SELECT, JOIN va agregatlarmenu_book Theory · +120 XP

Lessons

0/10

pending01menu_bookPostgreSQL asoslari: SELECT, JOIN va agregatlarContinueterminal0/1+120 XPchevron_right radio_button_unchecked02menu_bookSxema dizayni va butunlik: constraint'larterminal0/1+120 XPchevron_right radio_button_unchecked03menu_bookIndekslar va EXPLAIN: so'rovni tezlashtirishterminal0/1+120 XPchevron_right radio_button_unchecked04menu_bookTranzaksiyalar, qulflar va poyga (race condition)terminal0/1+120 XPchevron_right radio_button_unchecked05menu_bookAgregatsiya va oyna funksiyalariterminal0/1+120 XPchevron_right radio_button_unchecked06menu_bookJSONB: yarim-strukturali ma'lumotterminal0/1+120 XPchevron_right radio_button_unchecked07menu_bookRollar, huquqlar va Row Level Securityterminal0/1+120 XPchevron_right radio_button_unchecked08menu_bookZaxira, tiklash va WALterminal0/1+120 XPchevron_right radio_button_unchecked09menu_bookSekin so'rov tashxisi va texnik xizmatterminal0/1+120 XPchevron_right radio_button_unchecked10menu_bookReal vazifalar: migratsiya, arxivlash, auditterminal0/1+120 XPchevron_right