SQL Practice: Learn Database

Marton Greber

Ukuthenga ngaphakathi nohlelo

Mayelana nalolu hlelo lokusebenza

Funda i-SQL ngezikhathi zansuku zonke zemizuzu eyi-15 — efonini yakho, noma kuphi.

Ukuzijwayeza kwe-SQL kuguqula izikhathi zokungenzi lutho zibe amakhono edatha asebenzayo. Ngokuzijwayeza okusebenzisanayo, amasethi edatha angokoqobo, kanye nempendulo esheshayo, uzokwakha ukuzethemba kwe-SQL kusukela ezisekelweni zabaqalayo kuya kumakhono alungele ukuxoxisana.

Kungobani:
- Abashintshi bemisebenzi abangena kwezobuchwepheshe
- Ochwepheshe abafaka i-SQL kuthuluzi labo lamathuluzi
- Abafundi abalungiselela izingxoxo zobuchwepheshe
- Noma ubani ofisa ukwazi ngedatha kanye nezizindalwazi

Kungani kuhlukile:
- Funda ngokwenza: bhala futhi usebenzise imibuzo yangempela ye-SQL
- Amaphethini e-SQL (Pro): qonda izindlela ezingasetshenziswa kabusha esikhundleni sokukhumbula izimpendulo
- Ama-Database Bits (Pro): yakha umuzwa ngezifundo ezimfushane, ezibonakalayo
- Impendulo ehlakaniphile (Pro): bona ukuthi kungani umphumela wakho uhlukile kumphumela olindelekile
- Ikharikhulamu eqhubekayo: qala ngezisekelo bese uthuthuka ngejubane lakho
- Umklamo weselula-kuqala: prakthiza noma nini lapho unemizuzu embalwa engeziwe

Uma ubhajwa:
Nge-Pro, Ukuzijwayeza kwe-SQL kukusiza ukuthi uqhubekele phambili ngaphandle kokunikeza impendulo ngokushesha. Sebenzisa amacebo aqhubekayo, qhathanisa imiphumela yakho nomphumela olindelekile, bese uhlola izincazelo ze-SQL X-Ray ezihlukanisa imibuzo ibe yizinyathelo eziqondakalayo.

Lokho ozokufunda:
- KHETHA, KUPHI, ONGA NGE-, kanye nokuhlunga
- JOINs kanye nobudlelwano phakathi kwamathebula
- COUNT, SUM, AVG, GROUP BY, kanye ne-HAVING
- Imibuzo engezansi kanye namasu emibuzo athuthukile
- Amaphethini e-SQL angasetshenziswa kabusha (Pro)
- Imiqondo yesizindalwazi esiyinhloko, ama-index, kanye nomklamo wedatha (Pro)

Zijwayeze ngendlela yakho:
- Izifundo ze-SQL eziqondiswayo
- Ukuzivocavoca okulula, okuphakathi, kanye nokunzima
- Ukuzivocavoca okusheshayo
- Izifundo zesizindalwazi esibonakalayo esifushane (Pro)
- Izinselele zokuzijwayeza zansuku zonke
- Ukulandelana, i-XP, impumelelo, kanye nokulandelela inqubekela phambili
- Imodi ye-Hardcore: vala ikhibhodi ye-SQL ethuthukisiwe bese uxazulula izinselelo ezinzima ngaphandle kosizo—izinga eliphakeme kakhulu lokuzijwayeza kwe-SQL.

Imahhala kanye ne-Pro:
Izifundo ze-SQL esiyinhloko, izivivinyo, ukujima, imigqa, kanye nokulandelela inqubekela phambili okuyisisekelo kumahhala.

Ukubhalisela i-Pro okuzenzakalelayo okuvuselelayo kuvula amaphethini e-SQL, ama-Database Bits, amacebo aqhubekayo, ukuqhathanisa imiphumela okuningiliziwe, kanye nezincazelo zesinyathelo ngesinyathelo ze-SQL X-Ray. Amapulani atholakalayo, izikhathi zokukhokha, ukufaneleka kwesilingo, kanye namanani asendaweni aboniswa ngaphambi kokuthenga. Akukho ukuthenga okudingekayo ukuze usebenzise izici zokufunda eziyinhloko kanye nokuzijwayeza.

Qala uhambo lwakho lwedatha namuhla - akukho sipiliyoni sokubhala ikhodi sangaphambilini esidingekayo, imizuzu eyi-15 nje yelukuluku.

Inqubomgomo Yobumfihlo: https://martongreber.github.io/mvp/privacy.html
Imigomo Yokusebenzisa: https://martongreber.github.io/mvp/terms.html

Yini entsha

SQL Practice 2.0 is here—our biggest learning update yet!

New with an optional Pro subscription:
- Practice reusable queries with SQL Patterns
- Explore database concepts with visual Database Bits
- Get progressive hints and clearer result comparisons
- Break down queries step by step with SQL X-Ray

Core SQL lessons, exercises, and drills remain free.