SQL Practice - Learn SQL

Halim Box Dev

Ukuthenga ngaphakathi nohlelo

Mayelana nalolu hlelo lokusebenza

Funda i-SQL ngokuyibhala ngempela. Yonke imisebenzi isebenza kusizindalwazi sangempela se-SQLite ngaphakathi kwefoni yakho, ngakho-ke uthayipha imibuzo yangempela, ubone amathebula emiphumela yangempela bese uthola impendulo esheshayo, ngaphandle kokuxhumeka kwe-inthanethi okudingekayo.

INJINI YANGEQINISO YE-SQL ESIKHWAMENI SAKHO
• I-SQLite yangempela isebenza kudivayisi yakho: KHETHA, JOYINA, IQEMBU NGOKUKHETHA, imibuzo engezansi, ama-CTE, imisebenzi yefasitela, FAKA, BUYEKEZA futhi USUSE
• Izizindalwazi ezine zokuzijwayeza (inkampani, isitolo, ama-movie, isikole) ukuze uzihlole ngokukhululeka
• Umhleli wekhodi onegama elingukhiye kanye nama-chip esiphakamiso sethebula/ikholomu
• Umphumela wakho uqhathaniswa nempendulo elindelekile umugqa ngomugqa, ukuze ubone kahle ukuthi yini ehlukile
• Izincazelo zesiNgisi esicacile zamaphutha avamile njengokuthi "akukho kholomu enjalo" noma "igama lekholomu elingacacile"
• Idrowa leskimu kanye nomdwebo wethebula ukuze uhlale wazi ukuthi yimaphi amakholomu akhona

IZIFUNDO EZINGU-60 KUMAYUNITHI AYI-10
Amakhadi omqondo amafushane anezibonelo ezisetshenzisiwe, alandelwa izivivinyo zokusebenza ngezandla:
• Ukukhetha nokuhlunga idatha (LAPHO, NGOKUKHETHA, PHAKATHI, LIKE, NULL)
• Ukuhlunga kanye nokufaka amakhasi (ODA NGOKUKHETHA, UMKHAWULO, OKUPHELELE)
• Ukuhlanganisa kanye nokuhlanganisa (COUNT, SUM, AVG, GROUP BY, HAVING)
• Ukujoyina yazo zonke izinhlobo, ukujoyina kanye nemibuzo enamathebula amaningi
• Imibuzo engezansi, ama-CTE kanye nokuvezwa kwe-CASE
• Imisebenzi yefasitela (ROW_NUMBER, RANK, ukusebenzisa inani eliphelele)
• Ukushintsha idatha nokudala amathebula

IZINSELELE EZINGU-150 + I-PUZZLE YANSUKU ZONKE
• Izinselele ezilula ezingu-50, eziphakathi nezingu-50 kanye nezinzima ezingu-50
• Inselele entsha yansuku zonke nsuku zonke
• Izinselele ezinzima zivulwa ngevidiyo emfushane yokuzikhethela noma nge-Pro

UKULUNGISELELA INGXOXO YE-SQL
• Imibuzo yengxoxo engu-120 enezimpendulo ezicacile
• Ingxoxo yokuzilolonga ehleliwe ukuze uzijwayeze ukuphendula ngaphansi kwengcindezi
• Maka imibuzo ofuna ukuyibuyekeza futhi

AMAPHROJEKTHI EZIPHOTHIFOLIYO angu-20
Amaphrojekthi anezinyathelo eziningi kudatha yebhizinisi engokoqobo, njengokuhlaziywa kwemali engenayo kanye nokulinganisa iholo, kuvulwe ngemuva kwe-Unit 5 noma nge-Pro.

YAKHA UMKHUBA WANSUKU ZONKE
• Khetha umgomo wansuku zonke wezifundo noma izinselelo
• Imigqa emile ngokuphindaphindeka ukuze usuku olulodwa olumatasa lungayisethi kabusha intuthuko yakho
• Isikhumbuzi sansuku zonke ongazikhethela ngesikhathi osikhethayo

OKUYIMFIHLO NOKUNGENAKHO KU-inthanethi
Imibuzo yakho kanye nenqubekela phambili kuhlala kudivayisi yakho. Akukho akhawunti edingekayo.

Kumahhala ngezikhangiso. Ukuthenga kanye kuphela kwe-Pro kususa izikhangiso futhi kuvula zonke izinselelo ezinzima namaphrojekthi. Akukho ukubhalisa.