I-SHI SQL Querying Fundamentals Course
Mayelana nalesi sifundo
Izinhlangano ngokuvamile zigcina ulwazi lwazo olubaluleke kakhulu - ulwazi olusetshenziselwa ukuphatha imisebenzi yansuku zonke ngaphakathi kwesizindalwazi. Ikhono lokubuyisa nokuhlaziya lolu lwazi libalulekile ekusebenzeni kwenhlangano. Ulimi Oluhlelekile Lombuzo (SQL) wulimi oluyinhloko olusetshenziselwa ukufeza imisebenzi enjalo. Empeleni, i-SQL ulimi olusebenzisayo ukuze uhlanganyele nesizindalwazi.
Ikhono lokubhala i-SQL liyikhono lomsebenzi elibalulekile lalabo abadinga ukuphatha umthamo omkhulu wedatha, ukukhiqiza imibiko, idatha yemayini, noma ukuhlanganisa idatha evela emithonjeni eminingi. Ngisho noma othile eqenjini lakho ekudalela imibiko, ukuba nokuqonda okuyisisekelo kokubuza kwe-SQL kuzokusiza ukuthi ubuze imibuzo efanele futhi wazi ukuthi yini oyifunayo kumathuluzi akho okuhlaziya idatha.
Lesi sifundo asikufundisi nje kuphela ukusebenzisa i-SQL njengethuluzi lokubuyisa ulwazi oludingayo kusizindalwazi, kodwa futhi sethula inqubo yokuhlela ngempumelelo nokuklama isizindalwazi esisebenzayo nesisebenzayo. Ukwazi ukuhlela isizindalwazi esihlobene kubalulekile empumelelweni yolwazi oludalayo. Ngaphandle kokuhlela, awukwazi ukuthi wazi ukuthi isizindalwazi sidinga ukwenzani, noma yiluphi ulwazi okufanele ulufake kusizindalwazi. Ukuhlela isizindalwazi kubalulekile futhi kuvimbela umsebenzi owengeziwe wokulungisa izinkinga zokugcinwa kwedatha kamuva.
Izithameli profile
Lesi sifundo sihloselwe abantu abanamakhono ayisisekelo ekhompyutha, abajwayelene nemiqondo ehlobene nesakhiwo sesizindalwazi kanye namagama, abadinga ukufunda okubalulekile kokwakhiwa kwesizindalwazi futhi basebenzise i-SQL ukuze babuze imininingwane yolwazi.
- Business Analysts
- Abahlaziyi bedatha
- Onjiniyela
- Labo abadinga ukwazi ukuthi bangabuza kanjani kusizindalwazi se-SQL
Lapho sekuqediwe
Ngemva kokuphothula lesi sifundo, abafundi bazokwazi:
- Landela inqubo ephumelelayo yokuklama isizindalwazi esihlobene.
- Chaza imodeli yomqondo yesizindalwazi.
- Chaza imodeli enengqondo yesizindalwazi.
- Sebenzisa izindlela zokujwayela zesizindalwazi ukuze uthuthukise ukwakheka kokuqala kwesizindalwazi.
- Qedela ukwakheka kwesizindalwazi, okuhlanganisa nezilawuli zokuqinisekisa ubuqotho bayo obuyinkomba kanye nobuqotho bedatha.
- Xhuma kusizindalwazi seseva ye-SQL futhi wenze umbuzo olula.
- Faka umbandela wokusesha embuzweni olula.
- Sebenzisa imisebenzi ehlukahlukene ukwenza izibalo kudatha.
- Hlela idatha etholwe embuzweni ngaphambi kokuthi iboniswe esikrinini.
- Buyisa idatha kumathebula amaningi.
- Khipha imiphumela yombuzo.
Uhlaka Lwezifundo
Isifundo 1: Ukuqalisa Ngedizayini Yesizindalwazi Esihlobene
- Isihloko A: Khomba Izingxenye Zesizindalwazi
- Isihloko B: Thola Izinkinga Zokuklama Isizindalwazi Esivamile
- Isihloko C: Landela Inqubo Yedizayini Yesizindalwazi
- Isihloko D: Qoqa Izidingo
Isifundo 2: Ukuchaza Imodeli Yomqondo Yesizindalwazi
- Isihloko A: Dala Imodeli Yomqondo
- Isihloko B: Khomba Ubudlelwano Bebhizinisi
Isifundo 3: Ukuchaza Imodeli Enengqondo Yesizindalwazi
- Isihloko A: Khomba Amakholomu
- Isihloko B: Thola Okhiye Abayinhloko
- Isihloko C: Khomba futhi Udwebe Ubudlelwano
Isifundo 4: Ukwenza Idatha Ejwayelekile
- Isihloko A: Gwema Amaphutha Okudizayina Kwesizindalwazi Esivamile
- Isihloko B: Ukuthobela Amafomu Ajwayelekile Aphakeme
Isifundo 5: Ukuphothula Idizayini Yesizindalwazi
- Isihloko A: Guqula Imodeli Yomzimba Yezinhlelo Ezihlukene
- Isihloko B: Qinisekisa Ubuqotho Bokubhekisela
- Isihloko C: Qinisekisa Ubuqotho Bedatha Kuzinga Lekholomu
- Isihloko D: Qinisekisa Ubuqotho Bedatha Ezingeni Lethebula
- Isihloko E: Idizayini Yefu
Isifundo 6: Ukwenza Umbuzo Olula
- Isihloko A: Xhuma Kusizindalwazi se-SQL
- Isihloko B: Buza Kusizindalwazi
- Isihloko C: Londoloza Umbuzo
- Isihloko D: Lungisa futhi Usebenzise Umbuzo Olondoloziwe
Isifundo 7: Ukwenza Ukusesha Okunemibandela
- Isihloko A: Sesha Usebenzisa Imibandela Eyodwa noma Ezingaphezulu
- Isihloko B: Cinga a Range of Values and NULL Values
- Isihloko C: Sesha Idatha Ngokusekelwe Kumaphethini Ezintambo
Isifundo 8: Ukusebenza Ngemisebenzi
- Isihloko A: Yenza Izibalo Zosuku
- Isihloko B: Bala Idatha Usebenzisa Imisebenzi Ehlanganisiwe
- Isihloko C: Lawula Amanani Ezintambo
Isifundo 9: Ukuhlela Idatha
- Isihloko A: Hlunga Idatha
- Isihloko B: Idatha Yezinga
- Isihloko C: Idatha Yeqembu
- Isihloko D: Hlunga Idatha Ehlanganisiwe
- Isihloko E: Fingqa Idatha Ehlanganisiwe
- Isihloko F: Sebenzisa i-PIVOT kanye ne-UNPIVOT Operators
Isifundo 10: Ukubuyisa Idatha Kumathebula Amaningi
- Isihloko A: Hlanganisa imiphumela yemibuzo emibili
- Isihloko B: Qhathanisa Imiphumela Yemibuzo Emibili
- Isihloko C: Buyisa Idatha Ngokujoyina Amathebula
Isifundo 11: Ukuthekelisa Imiphumela Yemibuzo
- Isihloko A: Khiqiza Umbhalo File
- Isihloko B: Khiqiza i-XML File
Amadokhumenti / Izinsiza
 |
I-SHI SQL Querying Fundamentals Course [pdf] Iziyalezo I-SQL Querying Fundamentals Course, SQL, Querying Fundamentals Course, Fundamentals Course, Course |
