SQL Play — Learn SQL

Ukufunda nokuzijwayeza i-SQL bekungeke kube lula!
Sikwethulela ngohlelo lokusebenza oluhle lwe-SQL Runner lawo wonke amadivayisi akho - i-SQL Play.

Valelisa ngokufaka isofthiwe esindayo njenge-MySQL noma i-Microsoft SQL Server kumakhompyutha akho, ukuze nje wenze i-SQL isebenze.

Akumele uchithe amahora uzama ukuthola ukuthi yimiphi imiyalo ongayithayipha:
- Ukubhala nje umbuzo olula KHETHA
- Isetshenziswa kanjani isigatshana esithi LAPHO
- Idatha yeqembu kusetshenziswa isigatshana soKUBA NOKUBA
- Yiziphi izinhlobo zedatha okufanele zisetshenziswe
- Futhi abaningi abengeziwe

Qagela?
Awudingi ngisho nokwenza amathebula akho futhi ufake inqwaba yedatha uwedwa ukuze uhlole imibuzo yakho.

Sesivele sinamathebula angaphakathi angu-10+ ukuze nje ungcolise izandla zakho nge-SQL ngokushesha kunangaphambili.

Kuhlanganisa: Ama-albhamu, Abaculi, Amakhasimende, Izisebenzi, Izinhlobo, Ama-invoyisi nokuningi.

Uthola ama-syntaxes angu-45+ kanye nencazelo yawo nezibonelo okulula ukuzilandela ngokulandelana kwazo, ezizokuqondisa mathupha.

Akudingekile ukuthi uqhubeke nokuskrola ukuze uthole imiyalo, ungavele uqale ukuthayipha umyalo wakho futhi umyalo owufunayo one-syntax uzovela.

Ihlanganisa i-DDL (ulimi lwencazelo yedatha), i-DML (ulimi lokukhohlisa idatha) kanye ne-DQL (ulimi lombuzo wedatha)


Uma ukhetha imodi emnyama sikumbozile, itimu ye-SQL Play ifana netimu yesistimu yakho. Ukuze amehlo akho athole ukuphumula okufanele.

Awuboshelwe ohlelweni lwethu lokusebenza nedatha yakho, ungakhipha noma yimaphi amathebula akho ku-CSV (amanani ahlukaniswe ngokhefana) usebenzisa isici se-Export Data.

Idatha yakho ihamba nawe, kungakhathaliseki ukuthi i-Excel, i-Google AmaSpredishithi nanoma yimuphi omunye umhleli wesipredishithi noma isizindalwazi ozikhethele sona.

/// Yehla ngomzila wenkumbulo

Ngaso sonke isikhathi uma usebenzisa umbuzo wakho, ulondolozwa endaweni kudivayisi yakho engafinyelelwa ngokucindezela inkinobho yomcibisholo Waphezulu Naphansi.

Futhi uthola ukuqedela ngokuzenzakalela emlandweni njengoba uthayipha umbuzo wakho, ukuze ungahlali uziphinda.

I-TLDR; Kukongela isikhathi esiningi

Izizindalwazi ezisekelwayo ze-SQL:
• IBM DB2
• I-MySQL
• I-Oracle DB
• I-PostgreSQL
• I-SQLite
• Iseva ye-SQL
• I-Sybase
• I-OpenEdge SQL
• Ikhekheba leqhwa