Learn SQL: Offline Practice

Alpha Beat Limited

Ukuthenga ngaphakathi nohlelo

Mayelana nalolu hlelo lokusebenza

I-SQL inengqondo kakhulu uma ungayizama wena.

I-Learn SQL iyisifundo esilula sabaqalayo, esingaxhunyiwe ku-inthanethi sabathuthukisi abafisayo nanoma ubani ofuna ukuqonda izizindalwazi zobudlelwano. Landela imephu ecacile, funda umqondo owodwa ngesikhathi, bese usebenzisa umqondo ngamunye ngokushesha.

FUNDA ISINYATHELO NESINYATHELO

Sebenza ngezifundo eziqondisiwe ezingu-45 ezihlokweni eziyisikhombisa ezigxile kuzo:

• Amathebula nezisekelo ze-SELECT
• Ukuhlunga idatha
• Ukuhlunga, ukuhlanganisa, nokuhlanganisa
• Ubudlelwano nokujoyina
• Imibuzo ethuthukisiwe nemisebenzi yefasitela
• Ukuklama kweskimu, imikhawulo, izinkomba, kanye nezinhlelo zemibuzo
• I-PostgreSQL, i-Oracle, i-SQL Server, i-Teradata, kanye ne-SQL ephathekayo

ZIQHEKEZE NGEMIBUZO YANGEQINISO

Bhala futhi usebenzise i-SQL ngokumelene namasethi edatha okuzijwayeza ayisishiyagalolunye ahlanganisiwe. Hlola amathebula nobudlelwano ngemidwebo ye-ER esebenzisana nayo, bese uhlola imiphumela yakho kugridi yedatha ecacile, efundekayo.

FUNDA ESINDAWENI ESIPHEPHILE

I-Playground yamukela imibuzo ye-SELECT kuphela, ukuze ukwazi ukuzama ngaphandle kokushintsha idatha. Amalebhu eskimu aqondiswayo asebenza kumakhophi edathabheyisi angasetshenziswa, akunikeza ulwazi olusebenzayo ngaphandle kokufaka engcupheni intuthuko yakho noma idatha yohlelo lokusebenza.

YAKHELWA UKUFUNDA OKUGXIBEKILE

• Amacebo nezixazululo eziqhubekayo
• Izikhathi zezifundo ezilinganiselwe namalebula obunzima
• Imidwebo yedathabheyisi esebenzisanayo
• Ireferensi esheshayo ye-SQL engaxhunyiwe ku-inthanethi engaseshekayo
• Gcina futhi uwathande amakhadi okubhekisela awusizo
• Intuthuko yendawo kanye nokulandelela imigqa yokufunda
• Izindikimba ezikhanyayo nezimnyama
• Umklamo ophendulayo wamafoni namathebulethi
• Akukho akhawunti edingekayo
• Akukho uxhumano lwe-inthanethi oludingekayo kokuqukethwe kwesifundo

Qala ngezisekelo. Qhubeka ngezihloko eziyisithupha ezisele ngokuthenga okungaphakathi kohlelo lokusebenza isikhathi esisodwa. Ukuthenga kungabuyiselwa kumadivayisi asekelwayo.

Kungakhathaliseki ukuthi ulungiselela indima yonjiniyela, uvuselela ulwazi lwakho lwedathabheyisi, noma ubhala isitatimende sakho sokuqala se-SELECT, i-Learn SQL ikusiza ukuthi uguqule i-syntax ibe ukuqonda okusebenzayo ngesivinini sakho.