SQL Quest: Learn SQL & Code

ZA Tech Labs

Iqukethe izikhangiso

Mayelana nale geyimu

I-SQL Kahle, ukuphathwa kwedatha, kanye nokwenza ngcono imibuzo ngokusebenzisa ulwazi lokubhala ikhodi oluhehayo nolunemidlalo! I-SQL Quest iguqula imibuzo yokufunda idatha ibe yi-adventure esebenzisanayo, ikusiza ukuthi uzijwayeze imiyalo yangempela ye-SQL kusukela ekubuyiselweni kwedatha eyisisekelo kuya ekwakhiweni kwedatha yobudlelwano okuthuthukisiwe.

Kungakhathaliseki ukuthi ungumqali othatha izinyathelo zakho zokuqala ekuhleleni, umfundi olungiselela izivivinyo zedatha, noma unjiniyela olungiselela izingxoxo zobuchwepheshe, i-SQL Quest inikeza i-sandbox esebenzayo kanye nomhlahlandlela wokubhekisela owenzelwe ukwakha ukuzethemba kokubhala imibuzo okusebenzayo.

⚔️ UMDLALO WOMDLALO OMKHULU NEZICI

Inqubekela phambili Yombuzo Osebenzisanayo: Xazulula izinselelo zokubhala ikhodi ngokubhala imibuzo yangempela ye-SQL ukuze uqedele izinhloso, uvule amazinga, futhi uthole amabheji obuciko.

Izimo ze-SQL Ezingokoqobo: Sebenza ngama-schema obudlelwano angokoqobo afaka abasebenzisi, ama-oda e-e-commerce, isitokwe, kanye namathebula okuhlaziya.

Impendulo Yombuzo Osheshayo: Hlola i-syntax yakho, buka amasethi edatha abuyiselwe, futhi ufunde kumathiphu okuthola amaphutha awusizo kanye namathiphu okulungisa amaphutha.

Izinselele Ze-Checkpoint Boss: Beka amakhono akho esivivinyweni ngezinselelo eziphelele, zezinyathelo eziningi ezihlanganisa imiqondo eminingi ye-SQL ekuxazululeni izinkinga zangempela.

📖 I-CODEX YE-SYNTAX EPHELELE

Finyelela umhlahlandlela wokubhekisela we-SQL ne-MySQL owakhelwe ngaphakathi, oxhumeke ku-inthanethi ohlanganisa imiyalo engaphezu kwe-100, amagama angukhiye, kanye namaphethini ombuzo asebenzayo:

Izinhlobo Zedatha Nezithiyo Zethebula: INT, VARCHAR, DECIMAL, ENUM, JSON, TIMESTAMP, PRIMARY KEY, FOREIGN KEY, kanye nemikhawulo ye-CHECK.

Ulimi Lokuchaza Idatha (DDL): DALA ITHEBHULE, ALTER TABLE, Drop TABLE, DALA UKUBONWA, SHINTSHA ITHEBHULE, kanye nokufuduka kweskimu.

Ulimi Lombuzo Wedatha (DQL): KHETHA, LAPHO, ODA NGO, QOQA NGO, HAVING, subqueries, CTEs (Common Table Expressions), kanye nemisebenzi yewindi.

Joins & Setha Imisebenzi: INNER JOIN, LEFT JOIN, Right JOIN, CROSS JOIN, self-joins, UNION, kanye ne-INTERSECT.

Ulimi Lokulawula Idatha (i-DML): FAKA, BUYISA, SUSA, imisebenzi yemigqa eminingi, i-UPSERT (ON DUPLICATE KEY UPDATE), kanye nokulayisha idatha ye-batch.

Ukusebenza Nokwenza Kahle: Izinkomba ze-B-Tree, izinkomba ezihlanganisiwe, ezihlanganisa izinkomba, usesho lombhalo ogcwele, kanye nokuhlaziywa kohlelo lombuzo we-EXPLAIN.

Izimiso Zokuthengiselana Ne-ACID: QALA UKUTHENGISA, UKUZIBOPHEZELA, UKUQOQA, I-SAVEPOINT, kanye namazinga okuhlukaniswa kokuthengiselana.

🎯 NGUBANI I-SQLQUEST?

Abaqalayo Nabafundi: Funda izisekelo ze-SQL ngaphandle kwesidingo sokulungiselela amaseva edatha ayinkimbinkimbi noma izindawo zasendaweni.

Abathuthukisi Besofthiwe Nabahlaziyi Bedatha: Lola isivinini sakho sokubhala umbuzo futhi uhlole amacala asezingeni eliphezulu njenge-CTEs ephindaphindayo, ukufaka izinkomba, kanye nemisebenzi yewindi.

Abazongenela Ingxoxo: Zijwayeze imibuzo yangempela yengxoxo ye-SQL namaphethini avame ukubuzwa kubunjiniyela bedatha, isayensi yedatha, kanye nezindima zokuthuthukiswa kwe-backend.

Yini entsha

Official Release:
- Learn SQL and database architecture through real terminal challenges.
- 12 comprehensive campaign stages spanning DDL, DQL, indexing, and transactions.
- Integrated SQL sandbox for custom table schema creation and query practice.