SQL inoshandiswa kugoverana nekutarisa data, kunyanya deta inowanikwa muhurongwa hwekodzero dzekuchengetedza databases - data yakarongwa mumatafura, uye dzakawanda mafaira, imwe neimwe ine matata epa data, inogona kuwirirana pamwechete nemunda wakajairika.
Uchishandisa SQL, unogona kubvunza (kukumbira ruzivo kubva kune databases), kuronga nekugadzirisazve data, pamwe nekusika uye kugadzirisa schema (sarudzo) yedhesi yekodhidhi, uye kudzora kupinda kune data. Svondo rekushandisa rinoshandiswa kweSQL sevhavha rinosanganisira Microsoft Access, MySQL, uye Oracle.
Nhoroondo yeSQL
Muna 1969, mutsvakurudzi weBIM Edgar F. Codd akatsanangura chirevo chekodzero yezvinyorwa, izvo zvakava chikonzero chekusimbisa sQL mutauro. Taura zvakajeka, muenzaniso wezveshumo hwekutsvaga huri nehuwandu hwemashoko (kana kuti "kiyi") inosanganiswa nedhidhiyo dzakasiyana-siyana. Muenzaniso ibasa rekushandisa rinosanganiswa nezvose zita rako chaiyo uye nhamba yefoni.
Makore mashomanana gare gare, IBM yakatanga kushanda pamutauro mutsva wekodzero dzehupfumi hwekuchengetedza dhepfenyuro dzakabva paCodd zvakawanikwa. Mutauro wacho pakutanga wainzi SEQUEL, kana Structured English Query Mutauro. Iri purogiramu, rainzi System / R, rakapfuura kuburikidza kushandiswa kwemashoma uye kuongororwa, uye zita remutauro rakashandurwa nguva shomanana risati rasvika rainzi SQL.
Mushure mokunge vatanga kuedzwa paSQL muna 1978, IBM yakatanga kusimbisa zvekutengeserana, kusanganisira SQL / DS (1981) uye DB2 (1983). Vamwe vatengesi vaitevera zvakakodzera, vachizivisa avo vekutengesa SQL-based offerings. Izvi zvaisanganisira Oracle, uyo akabudisa chigadzirwa chayo chekutanga muna 1979, uye Sybase naIngres.
Kudzidza SQL
SQL iri nyore kune vanotanga kudzidza kudzidza kupfuura kuti ndeyekuti vatore mapurogiramu emitauro yakafanana naJava, C ++, PHP kana C #.
Kana iwe uchida kudzidza SQL, asi uine zvishoma zvishoma zviripo programming background, iwe unogona kubatsirwa nokuzviedza uchishandisa imwe yezvinhu zviri pasi apa, zvino wotora dive yakadzika neyunivhesiti chaiyo kana yekoroji yekorosi. Kana zvisina kudaro, iwe unogona kushandisa zvinyorwa zvakawanda zvekudzidza kwemajw.org kana zvekubhadhara-kudzidza zvidzidzo.
Heano mimwe mienzaniso yezvidzidzo zvisingabhadhari:
W3Schools SQL Tutorial
SQLcourse.com (shanduro yeSQL tutorial)
Codecademy ine Learn SQL program, pamwe chete nedzidzo yepamusoro pakuongorora SQL business metrics
Kana iwe uchida kubhadharwa-kudzidzira zvidzidzo, tinokurudzira International Webmasters Association (IWA) Kutanga ku SQL (Kushandisa Access) kana Kutanga ku SQL (Kushandisa MySQL).
Ndakatora zvidzidzo zveIWA zvisati zvaitika. SQL iyo inongova masvondo mana chete, asi yakanyatsorongeka pane kudzidzira kudzidzira-dzidzo nokuti zvidzidzo zvinotungamirirwa nevadzidzisi uye zvinosanganisira kupedzisa mamwe mabasa rimwechete pavhiki. Iwe unotanga kushamisika kuti unogona kudzidza zvakawanda sei munguva shoma shoma.
Mabhuku anobatsira paSQL yevatangi vekutanga anosanganisira:
SQL: Mutungamiri weMutangi
SQL muNutshell
Tarisa reraibhurari yako yemunharaunda kuti uone kana vakatakura aya kana mamwe mabhuku ekutanga eSQL.
SQL Skills Ndezvidiwa
Sezvambotaurwa kare, anenge munhu wose anoda mumwe munhu ane zivo yeSQL musangano ravo.
Maererano neGooroo, mabasa 50 705 akatengeswa muna 2015 izvo zvaida SQL ruzivo, uye mubhadharo wepakati pemahofisi anoda SQL ruzivo $ 81,632.
Heano mamwe emhando dzemhando dzinoshandisa unyanzvi hweSQL: