Ukulawula isakhiwo se-Infrastructure ye-SQL

Ukulawula i-SQL Database I-Infrastructure Training Course & Certification

Incazelo

Izilaleli & Izidingo Zokuqala

Uhlaka Lokufunda

Uhlelo noHlelo

Certification

Ukuphatha i-SQL Database Database Infrastructure Training Course

Leli khosi eliholwa yi-instructor-day lihlinzeka abafundi abaphatha nokugcina ulwazi lwe-SQL Server ngolwazi namakhono okuphatha Ingqalasizinda yesisekelo sedatha ye-SQL. Ukwengeza, kuzoba usizo kubantu abakha izinhlelo zokusebenza eziletha okuqukethwe kusuka ku-SQL Server yolwazi.

Izinhloso zokulawula iSQL Database Infrastructure Training

  • Qinisekisa futhi ugunyaze abasebenzisi
  • Nika umsebenzi we-server ne-database
  • Vumela abasebenzisi ukufinyelela izinsiza
  • Vikela idatha ngokubethela nokuhlola
  • Chaza izindlela zokutakula nezindlela zokulondoloza
  • Backup SQL Server yolwazi
  • Buyisela ulwazi lwe-SQL Server
  • Yenza ngokuzenzakalelayo ukuphathwa kwedatha
  • Lungiselela ukuvikeleka kwe-Agent SQL Server
  • Phatha izaziso kanye nezaziso
  • Ukuphatha i-SQL Server usebenzisa i-PowerShell
  • Landelela ukufinyelela ku-SQL Server
  • Hlola ingqalasizinda ye-SQL Server
  • Ukuxazulula ingqalasizinda ye-SQL Server
  • Ngenisa futhi uthumele idatha

Izilaleli ezihlosiwe zokulawula inkambo ye-Infrastructure Database ye-SQL

Izilaleli eziyinhloko kule nkambo ngabanye abaphatha futhi balondoloze ulwazi lweSQL Server. Laba bantu benza ukuphathwa nokugcinwa kwedatha njengendawo yabo eyinhloko yomthwalo wemfanelo, noma ukusebenza ezindaweni lapho Yolwazi badlala indima ebalulekile emsebenzini wabo oyinhloko. Izilaleli zesibili zalesi sifundo ngabantu abahlakulela izicelo eziletha okuqukethwe okuvela kulwazi lwe-SQL Server.

Isikhathi sokuphuma kwesikhathi sezinkathi: Izinsuku ze-5

I-Module 1: Ukuphepha kwe-SQL Server

Ukuvikelwa kwedatha ngaphakathi kwemininingwane yakho ye-Microsoft SQL Server kubalulekile futhi kudinga ulwazi olusebenzayo lwezinkinga kanye nezici zokuphepha ze-SQL Server. Le moduli ichaza onobuhle bezokuvikela be-SQL Server, ukungena ngemvume, abasebenzisi, ulwazi olunezinkampani ezincane, nokugunyazwa kwe-cross-server. Izifundo

  • Ukuqinisekisa ukuxhumana ku-SQL Server
  • Ukugunyaza ama-logins ukuxhuma kuma-yolwazi
  • Ukugunyazwa Kuzo zonke amaseva
  • Izingxenye ezigcinwe ngokwengxenye

I-Lab: Abasebenzisi bokuqinisekisa

  • Dala ukungena
  • Dala abasebenzisi be-Database
  • Izixazululo Zokungena ngemvume Zokufaka Isicelo
  • Lungiselela Ukuvikeleka Kwamafayela Okubuyiselwe

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Imiqondo eyisisekelo ye-SQL Server.
  • Ukuqinisekiswa kokuxhumanisa kwe-SQL Server.
  • Ukugunyazwa kokungena ngemvume komsebenzisi kuma-yolwazi.
  • Iqukethe imininingwane yolwazi.
  • Ukugunyazwa kuwo wonke amaseva.

I-Module 2: Ukunika i-Server kanye Nemisebenzi Yedatha

Ukusebenzisa izindima kunciphisa ukuphathwa kwemvume yomsebenzisi. Ngendima, ungakwazi ukulawula ukufinyelela kwabasebenzisi abaqinisekisiwe kwimithombo yesistimu ngokusekelwe emsebenzini womsebenzisi ngamunye-kunokuba unikeze izimvume umsebenzisi-ngomsebenzisi, unganika izimvume kwindima, bese wenza amalungu abasebenzisi izindima. Iseva ye-Microsoft SQL isebenzisa ukusekelwa kwezindima zokuphepha ezichazwe ezingeni leseva nasesiteji sedatha. Izifundo

  • Ukusebenza nezindima ze-server
  • Ukusebenza nge-Fixed Database Roles
  • Ukubeka Izinyathelo Zezintandokazi Ezichaza Umsebenzisi

I-Lab: Ukubeka iseva nezindima zemininingwane

  • Ukubeka izinkambiso zeseva
  • Ukubeka Imisebenzi Yedatha Elihleliwe
  • Ukubeka Izinyathelo Zezintandokazi Ezichaza Umsebenzisi
  • Ukuqinisekisa ukuphepha

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza futhi usebenzise izindima zeseva ukuphatha ukuphepha kwezinga leseva.
  • Chaza futhi usebenzise izindima ezihleliwe ezigciniwe.
  • Sebenzisa izindima zesisekelo sedatha kanye nezindima zohlelo lokusebenza ukuphatha ukuphepha kwezinga lesisekelo.

I-Module 3: Ukugunyaza Abasebenzisi Ukufinyelela Izinsiza

Kumamojula wangaphambilini, ubone indlela ukuphepha kwe-Microsoft SQL Server ehlelwe ngayo nokuthi iqoqo lezimvume lingabelwa kanjani kwizinga leseva nesedatha ngokusebenzisa izindima ezihleliwe zeseva, izindima zeseva ezichazwe ngumsebenzisi, izindima ezihleliwe ezigciniwe, nezindima zokusebenza. Isinyathelo sokugcina ekugunyazeni abasebenzisi ukufinyelela imithombo ye-SQL Server yisigunyaziso sabasebenzisi kanye nezindima zokufinyelela izinto ze-server ne-database. Kulesi module, uzobona ukuthi izimvume zento zilawulwa kanjani. Ngaphezu kokufinyelela izimvume ezintweni zezinqolobane, iSQL Server inikeza ikhono lokunquma ukuthi yiziphi abasebenzisi abavunyelwe ukwenza ikhodi, njengezinqubo ezigcinwe nemisebenzi. Ezimweni eziningi, lezi zimvume kanye nezimvume ezisezintweni zezinqolobane zihlelwe kahle ezingeni le-schema kunokuba zisezingeni lento ngayinye. Izibonelelo zemvume esekelwe kwisimiso zingenza kube lula ukwakha izakhiwo zakho zokuphepha. Uzohlola ukunikezwa kwezimvume ezingeni le-schema esifundweni sokugcina sale module.Izici

  • Ukugunyaza Umsebenzisi Ukufinyelela Ezintweni
  • Ukugunyaza Abasebenzisi Ukusebenza Ikhodi
  • Ukulungisa Izimvume eSikwini SeSikimu

I-Lab: Ukugunyaza abasebenzisi ukufinyelela izinsiza

  • Ukunika, Ukuphika, nokuphikisa Izimvume kwizinhloso
  • Ukunika imvume ye-EXECUTE Izimvume ngekhodi
  • Ukunikeza Izimvume ezingeni leSikimu

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Vumela ukufinyelela komsebenzisi ezintweni.
  • Vumela abasebenzisi ukuthi benze ikhodi.
  • Lungiselela izimvume ezingeni le-schema.

I-Module 4: Ukuvikela Idatha ngokuBhala nokuCwaninga

Uma ulungisa ukulondeka kwezinhlelo zakho ze-Microsoft SQL Server, kufanele uqinisekise ukuthi uhlangabezana nanoma yiziphi izimfuneko zokuhambisana nomhlangano wakho zokuvikela idatha. Izinhlangano ngokuvamile zidinga ukunamathela ezinkambisweni ezithile zokuhambisana nezimboni, ezigunyaza ukuhlola yonke imininingwane yokufinyelela kwedatha. Ukulungisa le mfuneko, i-SQL Server inikeza ububanzi bezinketho zokuqalisa ukuhlola. Esinye isidingo esivumelanisiwe sokuhambisana nomthetho ukubhalwa kwedatha ukuvikela ekufinyeleleni okungagunyaziwe uma kwenzeka ukuthi ukufinyelela kumafayili egciniwe kwedokhumenti. I-SQL Server isekela le mfuneko ngokunikeza ukubethela kwedatha ebonakalayo (TDE). Ukuze unciphise ingozi yokuvuleka kolwazi ngabasebenzisi abanokufinyelela kokuqondisa ku-database, amakholomu aqukethe idatha ebucayi-njengezinombolo zekhadi lesikweletu noma izinombolo zesazisi-zingabhalwa nge-slide ngokusebenzisa isici esivele sikhethiwe. Le module ichaza izinketho ezitholakalayo zokucwaninga ku-SQL Server, indlela yokusebenzisa nokuphatha isici se-SQL Server Audit, nendlela yokusebenzisa ukubethela.Izici

  • Izinketho zokufinyelela ukutholakala kwedatha ku-SQL Server
  • Ukuqalisa ukusebenza kwe-SQL Server Audit
  • Ukuphatha i-SQL Server Audit
  • Ukuvikela idatha ngokubethela

I-Lab: Ukusebenzisa ukuCwaninga nokuBhala

  • Ukusebenza nge-SQL Server Audit
  • Bhala ikholomu njengobe kukhonjwe njalo
  • Bhala i-Database usebenzisa i-TDE

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza izinketho zokuhlola ukutholakala kwedatha.
  • Qalisa ukuhlolwa kwe-SQL Server.
  • Phatha i-SQL Server Audit.
  • Chaza futhi usebenzise izindlela zokubethela idatha ku-SQL Server.
  • Qalisa ukubethela

I-Module 5: Amamodeli Wokubuyisela kanye Namasu Okusekelayo

Esinye sezici ezibaluleke kakhulu indima yomqondisi wedatha ukuqinisekisa ukuthi idatha yenhlangano ixhaswe ngokuthembekile ukuze, uma kwenzeka ukwehluleka, ungabuyisa idatha. Ngisho noma imboni yekhompyutha ikwazi ngesidingo samasu okusekela okuthenjelwa amashumi eminyaka-futhi ixoxwe ngalokhu ngobude-izindaba ezimbi ngokuphathelene nokulahleka kwedatha zisendaweni evamile. Enye inkinga yukuthi, ngisho noma amasu asebenzayo njengoba ayenziwe, imiphumela isalokhu ihluleka ukuhlangabezana nezidingo zomsebenzi wenhlangano. Kule modyuli, uzocabangela ukuthi ungakha kanjani isu elihambisana nezidingo zenhlangano, ngokusekelwe ezinhlobonhlobo zokulondoloza ezitholakalayo, kanye nendima yezitolo zokuthengiselana ekulondolozeni ukuvumelana kwemibhalo.

  • Ukuqonda amasu wokusekela
  • I-SQL Server Transaction Logs
  • Amasu Amasu Wokusekela

Ilabhu: Ukuqonda amamodeli wokutakula we-SQL Server

  • Hlela Isu Lokusekelayo
  • Lungiselela amamodeli wokubuyiswa kwedatha

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza amasu ahlukahlukene wokusekela.
  • Chaza ukuthi izitolo zokuthengiswa kwedatha zisebenza kanjani.
  • Hlela amasu wokusekelayo we-SQL Server.

I-Module 6: Ukusekela I-SQL Server yolwazi

Kwimodeli yangaphambilini, ufunde indlela yokuhlela isu lokusekela uhlelo lweSQL Server. Manje ungafunda ukuthi ungenza kanjani ama-backups we-SQL Server, kufaka phakathi izipele ezigciniwe ezigcwele futhi ezihlukile, izipele zokungena ngemvume, kanye nokusekela okuyingxenye. Kulesi module, uzofunda ukuthi ungasebenzisa kanjani amasu okusekela okuhlukile

  • Ukusekela Ukwaziswa Kwamafayela kanye Nezinkampani Zokungena
  • Ukuphatha izipele ze-Database
  • Izinketho Ze-Advanced Database

I-Lab: Ukusekela Ama-database

  • Ukusekela Ama-database
  • Ukwenza i-Database, Differential, and Transaction Log Backups
  • Ukwenza Isipele Esiyingxenye

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Yenza okulondoloziwe kwe-SQL Server yolwazi nolwazi lokuthengiselana.
  • Phatha ama-backups egciniwe.
  • Chaza izinketho zokulondoloza eziphambili.

I-Module 7: Ukubuyisela imininingwane ye-SQL Server 2016

Esikhathini samamodeli angaphambilini, ufunde ukuthi ungadala kanjani ukusekela okulondoloziwe kwemininingwane yolwazi lwe-Microsoft SQL Server 2016. Isu lokusekelayo lingase libandakanye izinhlobo eziningi ezahlukene zokulondoloza, ngakho-ke kubalulekile ukuthi ungakwazi ukuyibuyisela ngempumelelo. Uzovame ukubuyisela i-database kwisimo esiphuthumayo. Kodwa-ke, kufanele uqinisekise ukuthi unesimo esicacile sokuthi ungaqhubeka kanjani futhi uphinde uphinde uthola ngokugcwele i-database kwisimo esidingekayo. Uhlelo oluhle nokuqonda kwenqubo yokubuyisela kungasiza ekugwemeni ukwenza isimo sibe sibi nakakhulu. Ezinye ukubuyiselwa kwedatha zihlobene nokuhluleka kwesistimu. Kulezi zimo, uzofuna ukubuyisela isistimu esiseduze ngangokunokwenzeka esimweni esasiyiyo ngaphambi kokuhluleka. Kodwa ezinye izinhluleka zihlobene nesiphambeko somuntu futhi ungase ufise ukubuyisela uhlelo kuze kube iphuzu ngaphambi kwephutha. Izici zokubuyiselwa kwe-point-in-time ye-SQL Server 2016 zingakusiza ukuba ufeze lokhu. Ngenxa yokuthi ngokuvamile zikhudlwana kakhulu, imininingwane yolwazi yomsebenzisi ingase ithinteke kakhulu ekuhlulekeni kwesistimu kunamininingwane yolwazi. Noma kunjalo, yolwazi lwesistimu lungathinteka ukuhluleka, futhi ukunakekelwa okukhethekile kufanele kuthathwe uma uthola kabusha. Ngokuyinhloko, udinga ukuqonda ukuthi ungabuyisela kanjani idatha yesistimu ngayinye ngoba awukwazi ukusebenzisa inqubo efanayo kuwo wonke amasistimu e-system. Kulesi module, uzobona ukuthi ubuyisela kanjani imininingwane yolwazi lomsebenzisi kanye nesistimu nokuthi ungayisebenzisa kanjani ukubuyiswa kwe-point-in-time. Izifundo

  • Ukuqonda Ukubuyisela Inqubo
  • Ukubuyisela imininingwane
  • Okubukeziwe Buyisela izimo ze-Scenarios
  • Ukubuyiselwa kwe-Point-in-Time

I-Lab: Ukubuyisela imininingwane ye-SQL Server

  • Ukubuyisela Isipele Se-Database
  • Ukubuyisela ukugcinwa kwedatha, Ukuhluka, nokuThuthukiswa kokuLondoloza
  • Ukwenza ukubuyiselwa kwe-Piecemeal

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza inqubo yokubuyisela.
  • Buyisela imininingwane yolwazi.
  • Yenza imisebenzi yokubuyisela ethuthukisiwe.
  • Yenza ukutholwa kwe-point-in-time.

I-Module 8: Ukuzenzekelayo ukuphathwa kwe-SQL Server

Amathuluzi anikezwa yi-Microsoft SQL Server enza ukuphathwa okulula uma kuqhathaniswa nezinye izinjini zedatha. Kodwa-ke, ngisho noma imisebenzi ilula ukwenza, kuvamile ukuthi uphinde wenze umsebenzi izikhathi eziningi. Abaphathi be-database abaphumelelayo bafunda ukwenza umsebenzi wokuphindaphinda. Lokhu kungasiza ekugwemeni izimo lapho umphathi ukhohlwa ukwenza umsebenzi ngesikhathi esifanele. Mhlawumbe okubaluleke nakakhulu, ukuzenzakalela kwemisebenzi kusiza ukuqinisekisa ukuthi kwenziwa njalo, njalo lapho bebulawa. Le module ichaza indlela yokusebenzisa i-SQL Server Agent ukuzenzelela imisebenzi, indlela yokulungisa izimo zokuphepha kwemisebenzi, nendlela yokusebenzisa imisebenzi ye-multiserver. Izifundo

  • Ukuzenzakalela ukuphathwa kwe-SQL Server
  • Ukusebenza nge-Agent SQL Server
  • Ukuphatha Imisebenzi ye-Agent SQL Server
  • Ukuphathwa kwe-Multi-server

I-Lab: Ukuzenzekelayo ukuphathwa kwe-SQL Server

  • Dala isenzo se-SQL Server Agent
  • Hlola umsebenzi
  • Hlela uJobe
  • Lungiselela amaseva we-Master ne Target

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza izindlela zokuzenzekelayo ukuphathwa kwe-SQL Server.
  • Lungiselela imisebenzi, izinhlobo zezinyathelo zomsebenzi, nezinhlelo.
  • Lawula imisebenzi ye-SQL Server Agent.
  • Lungiselela amaseva namathebhu axhunyiwe.

I-Module 9: Ilungiselela ukuvikeleka kwe-Agent SQL Server

Amanye amamojula kulesi sifundo abonise isidingo sokunciphisa izimvume ezinikezwa kubasebenzisi, ngokulandela isimiso esithi "okungenani ilungelo." Lokhu kusho ukuthi abasebenzisi banemvume kuphela abayidingayo ukuze benze imisebenzi yabo. I-logic efanayo isebenza ekunikezeni izimvume ku-Agent SQL Server. Nakuba kulula ukukhipha yonke imisebenzi kumongo we-akhawunti yesevisi ye-SQL Server Agent, futhi ukulungisa i-akhawunti njenge-akhawunti yokuphatha, imvelo yokuvikeleka empofu ingabangela ukwenza lokhu. Kubalulekile ukuqonda indlela yokwakha indawo encane yokuvikela amalungelo emisebenzi egijima ku-Agent SQL Server.Izici

  • Ukuqonda ukuphepha kwe-Agent SQL Server
  • Ilungiselela ukuqinisekiswa
  • Ilungiselela ama-Akhawunti wama-Proxy

I-Lab: Ukulungisa Ukuphepha kwe-SQL Server Agent

  • Ukuhlaziya Izinkinga ku-Agent SQL Server
  • Ilungiselela i-Credential
  • Ilungiselela i-Akhawunti ye-Proxy
  • Ilungiselela futhi ihlolisise Umqondo Wokuphepha we-Job

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza ukuphepha kwe-Agent SQL Server.
  • Lungiselela iziqinisekiso.
  • Lungiselela ama-akhawunti we-proxy.

I-Module 10: Ukuqapha iSQL Server ngezaziso nezaziso

Esinye isici esiyinhloko sokuphatha i-Microsoft SQL Server ngendlela enomsebenzi ukuqinisekisa ukuthi uyazi izinkinga nezenzakalo ezenzeka kuseva, njengoba kwenzeka. I-SQL Server ibamba ingcebo yolwazi mayelana nezindaba. Ungayilungisa ukuze ikululeze ngokuzenzekelayo uma lezi zinkinga zenzeka, ngokusebenzisa izaziso kanye nezaziso. Indlela ejwayelekile kunazo zonke abaphathi besizinda se-SQL Server bathola imininingwane yezenzakalo ezithakazelisayo ngumyalezo we-imeyili. Le module ihlanganisa ukumiswa kwe-Database Mail, izaziso, kanye nezaziso zesibonelo se-SQL Server, nokuhlela kwezaziso ze-Microsoft Azure SQL Database. Izifundo

  • Ukuqapha Amaphutha we-SQL Server
  • Ilungiselela i-Database Database
  • Abasebenzisi, Izaziso, nezaziso
  • Izaziso ku-Azure SQL Database

Lab: Ukuqapha iSQL Server ngezaziso nezaziso

  • Ilungiselela i-Database Database
  • Ilungiselela abaSebenzi
  • Ilungiselela Izaziso Nezaziso
  • Izaziso zokuhlola kanye nezaziso

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Hlola amaphutha we-SQL Server.
  • Lungiselela iposi le-database.
  • Lungiselela opharetha, izaziso, kanye nezaziso.
  • Sebenza ngezixwayiso ku-Database ye-Azure SQL.

I-module 11: Isingeniso sokuphatha i-SQL Server ngokusebenzisa i-PowerShell

Le module ibuka indlela yokusebenzisa iWindows PowerShell ne-Microsoft SQL Server. Amabhizinisi ahlale ekhulisa ukusebenza kahle nokuthembeka kokugcina ingqalasizinda yabo ye-IT; ne-PowerShell, ungathuthukisa lokhu ukusebenza kahle nokuthembeka ngokudala izikripthi ukwenza imisebenzi. Ama-scripts we-PowerShell angahlolwa futhi asetshenziswe izikhathi eziningi kumaseva amaningi, alondoloze inhlangano yakho kokubili isikhathi nemali.Izici

  • Ukuqalisa ngeWindows PowerShell
  • Lungiselela i-SQL Server usebenzisa i-PowerShell
  • Ukuphatha nokugcina i-SQL Server nge-PowerShell
  • Ukuphatha i-Azure yolwazi lwe-SQL yolwazi usebenzisa i-PowerShell

I-Lab: Ukusebenzisa i-PowerShell yokuphatha i-SQL Server

  • Ukuqala nge-PowerShell
  • Ukusebenzisa i-PowerShell ukuze ushintshe izilungiselelo ze-SQL Server

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza izinzuzo ze-PowerShell nemicabango yayo eyisisekelo.
  • Lungiselela i-SQL Server ngokusebenzisa i-PowerShell.
  • Lawula futhi ulondoloze i-SQL Server ngokusebenzisa i-PowerShell.
  • Lawula i-Database ye-Azure SQL ngokusebenzisa i-PowerShell.

I-Module 12: Ukufinyelela Ukufinyelela ku-SQL Server ngezehlakalo ezandisiwe

Ukuqapha amamethrikhi wokusebenza kunikeza indlela enhle yokuhlola ukusebenza jikelele kwesisombululo se-database. Noma kunjalo, kunezikhathi lapho kudingeka khona ukuhlaziywa okuningiliziwe komsebenzi okwenzeka ngaphakathi kwesikhungiso se-Microsoft SQL Server-ezinkingeni zokuxazulula izinkinga futhi ubone izindlela zokwenza umsebenzi wokulayisha umsebenzi ulungiswe. Imicimbi ye-SQL Server Extended is a flexible, lightweight event-handling system system eyakhelwe kwi-Microsoft SQL Server Database Engine. Le modamu igxile emibonweni yezakhiwo, amasu okuxazulula izinkinga kanye nezimo zokusetshenziswa zezehlakalo ezandisiwe. Izifundo

  • Imikhawulo ejwayelekile yokwenza imicimbi
  • Ukusebenza Ngezehlakalo Ezibekiwe

Ilabhu: Izenzakalo ezandisiwe

  • Ukusebenzisa iSession_Health Extended Events Session
  • I-Splits Page Yokulandelela Ukusebenzisa Imicimbi Elandisiwe

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza Izintandokazi Zezenzakalo Eziyinhloko.
  • Yakha kanye nombuzo weseshini yezehlakalo ezongeziwe.

I-Module 13: Ukuqapha iSQL Server

Injini ye-Microsoft SQL Server Database ingasebenza isikhathi eside ngaphandle kwesidingo sokunakekelwa kokuphatha. Noma kunjalo, uma uqapha njalo umsebenzi okwenzeka kwisiphakeli sedatha, ungakwazi ukubhekana nezinkinga ezingenzeka ngaphambi kokuba zivuke. I-SQL Server inikeza ngamathuluzi amaningi ongawasebenzisa ukuqapha umsebenzi wamanje kanye nemininingwane yokurekhoda yomsebenzi wangaphambilini. Udinga ukujwayele ukuthi yikuphi amathuluzi akwenzayo nokuthi ungayisebenzisa kanjani. Kulula ukukhungatheka umthamo wokukhipha ukuthi amathuluzi wokuqapha anganikeza, ngakho-ke kudingeka futhi ufunde amasu wokuhlaziya okukhiphayo.Izici

  • Umsebenzi wokuqapha
  • Ukubamba nokuphatha idatha yokusebenza
  • Ukuhlaziya Idatha Yokusebenza Eqoqwe
  • Usizo lwe-SQL Server

Lab: Ukuqapha iSQL Server

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Qapha umsebenzi wamanje.
  • Thatha futhi uphathe idatha yokusebenza.
  • Hlola idatha yokusebenza eqoqwe.
  • Lungiselela isevisi ye-SQL Server.

I-Module 14: Ukuxazulula izinkinga ze-SQL Server

Abaqondisi be-Database basebenza ne-Microsoft SQL Server kudingeka badlale indima ebalulekile yokuxazulula inkinga lapho kuphakama izinkinga-ikakhulukazi uma abasebenzisi bezicelo ezibucayi zebhizinisi abathembela ku-database ye-SQL Server bavinjelwe ukusebenza. Kubalulekile ukuba nenqubo eqinile yokuxazulula izinkinga ngokujwayelekile, nokujwayela izinkinga ezivame ukuvela lapho usebenza nezinhlelo ze-SQL Server. Izifundo

  • Indlela Yokudubula Yezinkinga ze-SQL Server
  • Ukuxazulula Izinkinga Ezihlobene Nesevisi
  • Ukuxazulula Ukuxhumana kanye nezindaba zokungena ngemvume

I-Lab: Ukuxazulula Izinkinga Ezivamile

  • Troubleshoot bese uxazulula inkinga yokungena ngemvume ye-SQL
  • Ukuxazulula izinkinga bese uxazulula inkinga yesevisi
  • Troubleshoot bese Uxazulula Isingeniso se-Windows Login
  • Ukuxazulula izinkinga nokuxazululwa kwe-Job Execution Issue
  • Troubleshoot bese Uxazululwa Inkinga Yokusebenza

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza indlela yokuxazulula inkinga ye-SQL Server.
  • Hlela izinkinga ezihlobene nensizakalo.
  • Hlela izinkinga zokungena ngemvume nokuxhumeka.

I-Module 15: Ukungenisa nokuthumela idatha

Ngenkathi idatha enkulu ehlala ohlelweni lwe-Microsoft SQL Server efakwe ngqo ngabasebenzisi abaqhuba uhlelo lokusebenza, ngokuvamile kuvame ukuhambisa idatha kwezinye izindawo, nakuSQL Server. I-SQL Server inikeza isethi yamathuluzi ongawasebenzisa ukudlulisa idatha ngaphakathi nangaphandle. Amanye alawa mathuluzi, njenge-bcp (Bulk Copy Program) kanye nezinsizakusebenza ze-SQL Server Integration, zingaphandle kwe-inthanethi yedatha. Amanye amathuluzi, njengesitatimende se-BULK INSERT nomsebenzi OPENROWSET, asetshenziselwa injini yedatha. Nge-SQL Server, ungaphinda udale izinhlelo zokusebenza-zokuhlanganisa ezihlanganisa wonke amatafula, ukubukwa, kanye nokuhlola izinto ezihlobene nedatha yomsebenzisi kwiyunithi eyodwa yokuthunyelwa. Kulesi module, uzohlola lezi mathuluzi namasu ukuze ungenise futhi uthumele idatha ku-SQL Server. Izifundo

  • Kudluliselwa Idatha kuya nakuyi-SQL Server
  • Ukungenisa nokuthumela idatha yethebula
  • Ukusebenzisa i-bcp ne-BULK INSERT ukungenisa idatha
  • Ukuthumela nokuthuthukiswa kwe-Data-Tier Application

Ilabhu: Ukungenisa nokuthumela idatha

  • Idatha yokungenisa kanye ne-Excel usebenzisa i-Wizard yokungenisa
  • Ngenisa Ifayela Lombhalo Olinganiselwe Usebenzisa i-bcp
  • Ngenisa iFayili Yombhalo Olinganiselwe usebenzisa i-BULK INSERT
  • Dala futhi uhlole Iphakheji le-SSIS ukuze ukhiphe idatha
  • Sebenzisa i-Data-Tier Application

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza amathuluzi namasu wokudlulisa idatha.
  • Idatha yokufaka ngaphakathi nokuthekelisa.
  • Sebenzisa i-bcp ne-BULK INSERT ukungenisa idatha.
  • Sebenzisa izinhlelo zokusebenza zokufaka idatha ukuze ungenise futhi uthumele izinhlelo zokusebenza ze-database.

Ukuqeqeshwa Okuzayo

Ayikho imicimbi ezayo ngalesi sikhathi.

Sicela ubhalele ku- info@itstechschool.com & uxhumane nathi ku-91-9870480053 ngezindleko zemali & isitifikedi, isimiso & indawo

Siphonsa Umbuzo

Ukuze uthole olunye ulwazi ngomusa Xhumana nathi.


Izibuyekezo