SQL Code Play: Learn Practice!

Code Play

Iqukethe izikhangisoUkuthenga ngaphakathi nohlelo

Mayelana nalolu hlelo lokusebenza

Funda i-SQL, uzijwayeze imibuzo ye-SQL, bese usebenzisa ikhodi ye-SQLite ngqo kudivayisi yakho yeselula nge-SQL Code Play. Hlola izifundo eziqondisiwe, uxazulule izinselele zokuzijwayeza ezisebenzisanayo, bese uhlola imibuzo yangempela endaweni yokusebenza engaxhunyiwe ku-inthanethi eyakhelwe ukufunda usohambeni.

Kungakhathaliseki ukuthi ungumqali ofunda izisekelo ze-SQL noma unjiniyela oqabula amakhono edathabheyisi, i-SQL Code Play ikunikeza indlela ewusizo yokufunda, ukuzijwayeza, kanye nokuzama ngaphandle kokudinga uxhumano lwefu.
Funda i-SQL ngama-Tutorials Aqondisiwe
Dlulisa amehlo ezifundweni eziqondisiwe ezingu-103 ezichaza imibono yangempela ye-SQL isinyathelo ngesinyathelo. Ikhathalogi yezifundo ifaka izihloko ezingaseshwa ngokulandelela inqubekela phambili, ukuze ukwazi ukuvula kabusha izifundo, ulandele incazelo, futhi uqhubeke nesifundo ngesivinini sakho. Thepha noma yisiphi isifundo ukuze ufunde ukuhlukaniswa okucacile kombuzo, uqonde ukuthi ingxenye ngayinye yenzani, futhi ubone amathiphu asebenzayo okuzama ukuhlukahluka kwakho.

Umtapo wezifundo uhlanganisa izihloko eziyinhloko ze-SQL kanye ne-SQLite kusukela eziyisisekelo ngokusebenzisa amaphethini athuthukile, okuhlanganisa ukuhlunga, ukuhlunga, ukuhlanganisa, ukujoyina, imibuzo engaphansi, i-CASE, ukuthengiselana, ukubukwa, izinkomba, imikhawulo, ama-CTE aphindaphindayo, imisebenzi yewindi, imisebenzi ye-JSON, imibuzo ye-PRAGMA, i-EXPLAIN QUERY PLAN, kanye nemisebenzi yedethi nesikhathi se-SQLite.
Prakthiza endaweni yokusebenza ye-SQL yendawo
Vula indawo yokusebenza ye-SQL bese usebenzisa imibuzo ngaphakathi kweseshini ye-SQLite yendawo. Bhala, hlela, hlehlisa, phinda wenze, thola umbhalo, gxuma uye emgqeni, vula amafayela agciniwe, londoloza umsebenzi wakho, bese ulondoloza njengefayela elisha uma ufuna ukugcina inguqulo. Indawo yokusebenza ifaka nokubuka kweskimu sedathabheyisi, inketho yokubuyisela, kanye nokwakheka kwamathebhu amabili kwekhodi nokukhipha, okwenza kube lula ukuhlola umbuzo bese ubuyekeza umphumela endaweni eyodwa.
Uhlelo lokusebenza lwenzelwe ukuzijwayeza kwangempela. Ungalayisha ikhodi yesifundo kumhleli, uhlele umbuzo okhona, uwusebenzise, ​​​​bese ubona umphumela ngokushesha. Lokho kwenza i-SQL Code Play ibe usizo kokubili ekufundeni nasekukwenzeni, okuyindlela enamandla yokwakha ukuzethemba ngemiyalo yedathabheyisi.
Izindlela Zokufunda Ezisebenzisanayo
Dlula ukufunda ngezindlela zokuzijwayeza eziklanyelwe ukwakha ukuzethemba:
- Umhlahlandlela we-SQL Lab onemisebenzi engavuleka
- Khetha izinselelo zempendulo engcono kakhulu ze-SQL syntax kanye ne-clause order
- Gcwalisa izivivinyo ze-Blanks zamagama angukhiye, ama-opharetha, kanye nesakhiwo semibuzo
- Imidlalo ye-Output Detective ekuqeqesha ukubikezela isimo semiphumela
- Imibuzo ye-Syntax Builder yokwakha izitatimende ezivumelekile
Le misebenzi ikusiza ukuthi uzijwayeze UKUKHETHA, UKUPHI, UKU-ODELA NGO-, UKULINGANISA, UKUQHUBA NGOKU-, UKUBE, UKUJOYINA, UKUHLANGANISA, UKUBUYEKEZA, UKUSUSA, UKUHLUKANISA, UKUNGENA, UKUTHANDA, UKUPHAKATHI, UKUHLOLA, UKUHLOLA PHAKATHI, UKUHLOLA ... Izici Eziwusizo Zokusetshenziswa Kwansuku Zonke
- Okuqukethwe kwesifundo se-SQL Okungaxhunyiwe Ku-inthanethi
- Sesha futhi uhlunge izifundo ngesihloko
- Ukulandelela inqubekela phambili yezifundo nezindlela zokuzijwayeza
- Ukusekelwa kwetimu ekhanyayo nemnyama
- Izilimi eziningi kanye nokwenza kwasendaweni
- Yabelana ngohlelo lokusebenza nabanye
- Impendulo yangaphakathi nohlelo lokusebenza kanye nokubika amaphutha
- Ukuthuthukiswa kwe-Pro okungenazikhangiso okungakhethwa
Kwakhelwe Ukufunda Ngokwenza
Uma ufuna ukufunda i-SQL ungaxhunyiwe ku-inthanethi, ukuzijwayeza imibuzo ye-SQLite, noma ukufunda imiqondo yesizindalwazi ngezibonelo kanye nempendulo esheshayo, i-SQL Code Play yenza inqubo ibe lula futhi igxile. Funda isifundo, zama umbuzo, hlola umphumela, futhi uqhubeke nokuthuthukisa isihloko esisodwa ngesikhathi.
Sebenzisa i-SQL Code Play ukuze ufunde i-SQL, ukuzijwayeza imibuzo ye-SQL, futhi wakhe ukuzethemba nge-SQLite endaweni yokusebenza yeselula ehlelekile efanela abaqalayo, abafundi, nanoma ubani olungiselela izingxoxo noma izisekelo zesizindalwazi ezivuselelayo.
Zijwayeze ngezindawo zokufunda zohlelo lokusebenza.

Yini entsha

Refreshed app design and improved user experience.
Added many new SQL tutorials and learning content.
Updated SQL compiler with improved syntax support.
Added support for CREATE TABLE and more SQL statements.
Improved the “Try It” coding experience.
Added the new Practice Hub for hands-on SQL practice.
Improved SQL result viewing, navigation, and landscape support.
Fixed bugs and improved overall app stability.