uhloboUqeqesho lweKlasi
ixesha5 Days
INCWADI

Qhagamshelana nathi

Iimimandla ezimakwe kunye * zifunwa

 

Ukulawula i-SQL yeSiseko seZiseko

Ukulawula i-SQL yeSiseko seZiko loQeqesho loQeqesho noQeqesho

inkcazelo

Abaphulaphuli kunye neemfuno ezifunekayo

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

Ukulawula i-SQL yeSiseko seCandelo loQeqesho loQeqesho

Le khosi ekhokelwa yi-five-day instructor inikezela abafundi abalawulayo nokugcina i-SQL Server yolwazi ngolwazi kunye nezakhono zokulawula Isiseko seenkcukacha zesiseko seSQL. Ukongezelela, kuya kuba yintsebenziswano kubantu abaza kuphuhlisa izicelo ezihambisa imixholo evela kwiSquL Server yolwazi.

Iinjongo zokulawula iSQL uLawulo lweZiseko zoQeqesho

  • Qinisekisa kwaye ugunyaze abasebenzisi
  • Nika iseva kunye nemisebenzi yolwazi
  • Ugunyaze abasebenzisi ukufikelela kwizixhobo
  • Khusela idatha ngokubethela nokuphicothwa
  • Chaza imizekelo yokubuyisela kunye neendlela zokulondoloza
  • Ugcino lweSQL Server yolwazi
  • Buyisela kwakhona i-SQL Server yolwazi
  • Ukuzenzekelayo ukuphathwa kwedatha
  • Lungiselela ukhuseleko kwi-Agent SQL Server
  • Ukulawula izilumkiso kunye nezaziso
  • Ukulawula i-SQL Server usebenzisa i-PowerShell
  • Landela ukufikelela kwiSQL Server
  • Ukujonga isiseko seSQL Server
  • Iingxaki zeziko leSQL Server
  • Ukungenisa nokuthumela idatha

Abaphulaphuli abafunyenweyo bokulawula i-SQL yeSiseko seZibonelelo seZiseko

Abaphulaphuli bephambili kule khosi ngabantu abalawulayo nokugcina i-SQL Server yolwazi. Aba bantu benza ukugcinwa kwedatha kunye nokugcinwa kwedatha njengendawo yabo ephambili yokuxanduva, okanye ukusebenza kwindawo apho Yolwazi badlale indima ephambili emsebenzini wabo oyintloko. Abaphulaphuli ababini beli khosi ngabantu abahlakulela izicelo ezihambisa umxholo kwiSquL Server yolwazi.

Ixesha loKhutshwa kweNkundla: Iintsuku ze-5

I-Module 1: Ukhuseleko lwe-SQL Server

Ukukhuselwa kwedatha ngaphakathi kweenkcukacha zakho ze-Microsoft SQL Server kubalulekile kwaye kudinga ulwazi olusebenzayo malunga nemicimbi kunye nezinto ezikhuselekileyo zeSQL Server. Le modyuli ichaza imodeli yokukhusela i-SQL Server, ukungena ngemvume, abasebenzisi, ubuncinci beenkcukacha, kunye negunya lokugqithisa. Izifundo

  • Ukuqinisekisa iiNxibelelwano kwiSQL Server
  • Ukugunyazisa iiLogins ukuXhuma kwiinkcukacha zolwazi
  • Ugunyaziso kwiNkonzo yoncedo
  • Zineenkcukacha ngokubanzi

ILab: Ukuqinisekisa abaSebenzisi

  • Yenza i-Logins
  • Yenza abasebenzisi beDatabase
  • Iingxaki zoLungiso lweZicelo
  • Qwalasela iNgcaciso yoLwazi olubuyisiweyo

Emva kokugqiba le modyuli, uya kuba:

  • Iingcamango ezisisiseko zeSQL Server.
  • Ukuqinisekiswa koxhulumaniso lweSQL Server.
  • Ugunyaziso lokungena ngemvume kumsebenzisi kwiinkcukacha zolwazi.
  • Zineenkcukacha zengxenye.
  • Ugunyaziso kumaseva.

I-2 yeModyuli: Ukunikezela ngeSeva kunye neMisebenzi yokuSebenza

Ukusebenzisa iindima kunciphisa ukulawulwa kwemvume yomsebenzisi. Ngeendima, unokulawula ukufikelela kwabasebenzisi abaqinisekisiweyo kwiinkqubo ezisekelwe kumsebenzi ngamnye womsebenzi-kunokuba unikeze imvume kumsebenzisi-ngomsebenzisi, unika iimvume kwendima, uze wenze amalungu abasebenzisi indima. I-Microsoft SQL Server iquka inkxaso yoxanduva lwezokhuseleko oluchazwe kwinqanaba lomncedisi kunye nakwizinga leenkcukacha. Izifundo

  • Ukusebenza ngeendima zeseva
  • Ukusebenza kunye neNgcaciso yoMsebenzi
  • Ukunikezela ngeeNgcaciso zomSebenzi

ULabhanki: Ukunikezela ngeeseva kunye neenkcukacha zedatha

  • Ukunikezela ngeeNkonzo zeeNkonzo
  • Ukunikezela ngeeNkcukacha zoNgcaciso
  • Ukunikezela ngeeNgcaciso zomSebenzi
  • Ukuqinisekisa ukuKhuseleko

Emva kokugqiba le modyuli, uya kuba:

  • Chaza kwaye usebenzise iindima zeseva ukulawula ukhuseleko lwezinga leseva.
  • Chaza kwaye usebenzise iindima ezigciniweyo zeenkcukacha.
  • Sebenzisa iindidi zeenkcukacha zolwazi kunye neendima zesicelo ukulawula ukhuseleko lwezinga leenkcukacha.

I-Module 3: Ukugunyazisa Abasebenzisi Ukufikelela kwiZibonelelo

Kwiimodyuli zangaphambili, ubonile indlela ukukhuseleka kweMicrosoft SQL Server kunye nendlela iisethi zeemvume ezingabelwa ngayo kwi-server nakwizinga leenkcukacha ngokusebenzisa iindidi zeseva ezinqamlekileyo, iindidi zeseva ezichazwe ngumsebenzisi, iindima ezigciniweyo zeenkcukacha, kunye neendima zohlelo lokusebenza. Isinyathelo sokugqibela ekugunyaziseni abasebenzisi ukufikelela kwizixhobo zeSQL Server kukugunyazwa kwabasebenzisi kunye neendima zokufikelela kwi-server kunye nezinto zeenkcukacha. Kule modyuli, uya kubona ukuba zeziphi iimvume ezilawulwayo. Ukongeza kwimvume yokufikelela kwizinto zeenkcukacha, iSQL Server inika amandla okuchonga ukuba yeyiphi abasebenzisi abavunyelwe ukuba benze ikhowudi, njengendlela yokugcinwa kweenkqubo kunye nemisebenzi. Kwiimeko ezininzi, ezi mvume kunye neemvume kwizinto zeenkcukacha zilungelelaniswe kwizinga le-schema kunokuba libekwe kwinqanaba lomntu ngamnye. Isibonelelo semvume esekelwe kwiSikimu sinokukwenza lula ukuzakhela ukhuseleko lwakho. Uya kuhlola ukunikezelwa kwemvume kwi-schema level kwisifundo sokugqibela sale modyuli

  • Ukugunyazisa Umsebenzisi Ukufikelela kwiiNjongo
  • Ukugunyazisa Abasebenzisi Ukuphumeza Ikhowudi
  • Ukuqwalasela iMvume kwiNqanaba leSikimu

Ibhodi: Ukugunyazisa abasebenzisi ukufikelela kwizixhobo

  • Ukunika, Ukukhanyela, kunye nokuVavanya iMvume kwizinto
  • Ukunika iIEMVUMO ZEMISEBENZI YOMTHETHO
  • Ukunika iimvume kwiNqanaba leSikimu

Emva kokugqiba le modyuli, uya kuba:

  • Ugunyaze ukufikelela komsebenzisi kwizinto.
  • Ugunyaze abasebenzisi ukuba benze ikhowudi.
  • Qwalasela iimvume kwizinga le-schema.

I-Module 4: Ukukhusela iDatha ngokuBhala nokuChengisisa

Xa uqwalasela ukhuseleko kwiinkqubo zakho ze-Microsoft SQL Server, kufuneka uqinisekise ukuba uhlangabezana nayo nayiphi na imfuneko yokuthobela umyalelo wakho wokukhusela idatha. Imibutho idla ngokufuneka ihambelane nemigaqo-nkqubo yokuthobela imigaqo-nkqubo, okuyigunya lokuphicothwa kwayo yonke idatha yokufikelela. Ukujongana nale mfuno, i-SQL Server inikeza uluhlu lwezinto zokukhetha ukuphumeza ukuphicothwa. Enye imfuneko yokuthotyelwa kwesiqhelo yinkcazo yedatha ukukhusela ekufikeleleni kokungagunyaziswanga kwimeko apho ukufikeleleka kwiifayile zeenkcukacha ezigciniweyo zonakaliswe. I-SQL Server isekela le mfuneko ngokubonelela nge-encryption yedatha ebonakalayo (TDE). Ukunciphisa umngcipheko wolwazi lokuvuza ngenxa yabasebenzisi abanokufikelela kwi-database, iikholomu ezineenkcukacha ezibukhali-njengamanani ekhadi-khredithi okanye iinombolo zesazisi kazwelonke-zingabhalwa ngokuchanekileyo isebenzisa inkalo ebhalwe rhoqo. Le modyuli ichaza iindlela ezikhoyo zokuphicothwa kwi-SQL Server, indlela yokusebenzisa nokulawula isici se-SQL Server Audit, kunye nendlela yokuphumeza ukubethela.

  • Izinketho zokuphicothwa kwedatha yokufikelela kwi SQL Server
  • Ukuphunyezwa kwe-SQL Server Audit
  • Ukulawula i-SQL Server Audit
  • Ukukhusela iDatha ngokuBhala

ULebhu: Ukusebenzisa uVavanyo kunye nokuBhala

  • Ukusebenza ne-SQL Server Audit
  • Bhalisa iKholamli njengeSikhathi sonke
  • Bhalisa i-Databases usebenzisa i-TDE

Emva kokugqiba le modyuli, uya kuba:

  • Chaza ukhetho lokuphicothwa kwedatha yokufikelela.
  • Ukuphumeza uVavanyo lweSQL Server.
  • Lawula i-SQL Server Audit.
  • Chaza kwaye usebenzise iindlela zokubethela idatha kwiSQL Server.
  • Qalisa ukubethela

I-Module 5: Iimodeli zokubuyisela kunye namacebo okugcina

Enye yezona zinto zibaluleke kakhulu kwendima yomlawuli wedatha ukuqinisekisa ukuba idatha yeququzelelo ixhaswa ngokuqinisekileyo ukwenzela ukuba, ukuba kukho ukungaphumeleli, unokufumana kwakhona idatha. Nangona i-computing icandelo liyazi malunga nesidingo seendlela zokulondoloza ezinokuthenjwa ngokumashumi eminyaka-kwaye ixubushe ngoku ngobude-amabali amnandi malunga nokulahlekelwa kwedatha kusekhona kwindawo eqhelekileyo. Enye ingxaki kukuba, nangona izicwangciso ezisebenza kwindawo njengoko zenziwe, iziphumo zihlala zihluleka ukuhlangabezana neemfuno zomsebenzi. Kule modyuli, uya kuqwalasela indlela yokwenza isicwangciso esilungelelaniswe neemfuno zentlangano, ngokusekelwe kumanqaku okulondoloza okukhoyo, kunye nendima yemigodi yokuthengiselana ekugcineni ukugcinwa kwedatha.

  • Ukuqonda amacebo okuBala
  • SQL Server Transaction Logs
  • Amacandelo okulondoloza amacebo

Ibhodi: Ukuqonda imodeli yokubuyisela i-SQL Server

  • Cwangcisa iSicwangciso soKhuseleko
  • Qulunqa i Models Recovery Models

Emva kokugqiba le modyuli, uya kuba:

  • Chaza iindlela ezahlukeneyo zokulondoloza.
  • Chaza indlela i-log log loggs esebenza ngayo.
  • Cwangcisa amasu okulondoloza iSQL Server.

I-Module 6: Ukuxhasa i-SQL Server yolwazi

Kwimodyuli yangaphambili, ufunde indlela yokucwangcisa isicwangciso sokugcina isistim seSQL Server. Ngoku unokufunda indlela yokwenza izilungelelwano ze-SQL Server, kubandakanya iifayile ezigciniweyo ezipheleleyo kunye nezihlukeneyo, i-backups ye-transaction log, kunye ne-backups. Kule modyuli, uya kufunda indlela yokusebenzisa iindlela ezahlukeneyo zokulondoloza

  • Ukuxhaswa kweeNgcaciso kunye neNgxelo yokuThengisa
  • Ukulawula iCape Database Backups
  • Izinketho zeDatha zeDatha eziPhambili

ULebhu: Ukulondolozwa kweenkcukacha zolwazi

  • Ukuxhaswa kweenkcukacha
  • Ukwenza iData yeData, u-Differential, kunye ne-Transaction Log Backups
  • Ukwenza iSeckup Backup

Emva kokugqiba le modyuli, uya kuba:

  • Ukwenza izilungiso ze-SQL Server yolwazi kunye neengxelo zokuthengisa.
  • Ukulawula izixhobo zokugcina iinkcukacha.
  • Chaza iindlela zokugcina eziphambili.

I-Module 7: Ukubuyisela i-SQL Server 2016 yolwazi

Kwimodyuli yangaphambili, ufunde indlela yokudala iifayile zokugcina iinkcukacha ze-Microsoft SQL Server 2016 yolwazi. Isicwangciso sokulondoloza singabandakanya iintlobo ezininzi ezahlukeneyo zokulondoloza, ngoko kubalulekile ukuba ubenokubuyisela ngokufanelekileyo. Ngokuqhelekileyo uza kubuyiselwa kwisiseko seenkcukacha kwiimeko eziphuthumayo. Kodwa ke kufuneka uqinisekise ukuba unesicwangciso esicacileyo sokuthi uqhubeke njani kwaye uphumelele ukubuyisela isiseko kwiziko elifunekayo. Isicwangciso esihle nokuqonda kwenkqubo yokubuyisela inokukunceda ukuphepha ukwenza imeko ibe yimbi. Olunye ulwazi olulondoloziweyo lwentlupheko luhlobene nokusilela komsebenzi. Kule meko, uya kufuna ukubuyisela inkqubo ngokusondeleyo kwimeko ebekuyo kuyo phambi kokungaphumeleli. Ezinye iziphene, nangona kunjalo, zihambelana nephutha lomntu kwaye unokuba unqwenela ukubuyisela inkqubo kwinqanaba ngaphambi kwelo mpazamo. Izixhobo zokubuyisela ixesha-nge-SQL Server 2016 zingakunceda ukuba ufezekise oku. Ngenxa yokuba zixhaphake kakhulu, iinkcukacha zolwazi ziyakwazi ukuchaphazeleka yenkqubo yokungaphumeleli kunokwinkcazelo yolwazi. Nangona kunjalo, iinkcukacha zolwazi zichaphazelekayo, kwaye unonophelo oluthile lufanele kuthathwe xa luwafumana. Ngokukodwa, kufuneka uqonde indlela yokufumana idatha nganye yesiseko kuba awukwazi ukusebenzisa inkqubo efanayo kuzo zonke iinkcukacha zolwazi. Kule modyuli, uya kubona indlela yokubuyiselwa yolwazi lomsebenzisi kunye nenkqubo nendlela yokuqalisa ukubuyiswa kwexesha. Izifundo

  • Ukuqonda Ukubuyisela Inkqubo
  • Ukubuyiselwa kweenkcukacha
  • Ukubuyiselwa okuPhambili kweMifanekiso
  • Ukubuyiswa Kwexesha-kwixesha

ULebhu: Ukubuyisela i-SQL Server yolwazi

  • Ukubuyisela i-Backup Database
  • Ukubuyisela i-Database, i-Differential, ne-Transaction Log Backups
  • Ukwenza i-Piecemeal Buyisela

Emva kokugqiba le modyuli, uya kuba:

  • Cacisa inkqubo yokubuyisela.
  • Buyisela kwakhona iinkcukacha.
  • Yenza imisebenzi yokubuyisela phambili.
  • Yenza i-point-in-time recovery.

I-Module 8: Ukuzenzekelayo ukuLawula iSquL Server

Izixhobo ezinikezwa yi-Microsoft SQL Server zenza lula ukulawula xa kuthelekiswa nezinye iinjongo zeenkcukacha. Nangona kunjalo, nangona imisebenzi ilula ukwenza, kuyaqhelekile ukuba uphinde uphinde uphinde usebenze. Abalawuli beenkcukacha ezifanelekileyo bafunda ukuzenzekelayo imisebenzi ephindaphindayo. Oku kunokukunceda ukuphepha iimeko apho umlawuli alibale ukuqhuba umsebenzi ngexesha elifunekayo. Mhlawumbi kubaluleke ngakumbi, ukuzenzekelayo kwemisebenzi kunceda ukuqinisekisa ukuba zenziwa ngokuqhubekayo, rhoqo xa zibulawa. Le modyuli ichaza indlela yokusebenzisa ummeli we-SQL Server ukuzenzekelayo imisebenzi, indlela yokuqwalasela imimiselo yokhuseleko yemisebenzi, nendlela yokuqalisa imisebenzi ye-multiserver. Izifundo

  • Ukuzenzekelayo ulawulo lweSQL Server
  • Ukusebenza ne-Agent SQL Server
  • Ukulawula imisebenzi ye-Agent SQL Server
  • Management Multi-server

ULebhu: Ukuzenzekelayo ukulawula iService Server

  • Yakha i-Job Agent Job
  • Vavanya u msebenzi
  • Hlela uYobhi
  • Qwalasela i-Master and Target Servers

Emva kokugqiba le modyuli, uya kuba:

  • Chaza iindlela zokwenza i-SQL Server Management.
  • Qwalasela imisebenzi, iindidi zengqesho, kunye nee shedyuli.
  • Lawula imisebenzi ye-SQL Server Agent.
  • Qwalasela iinkonzo zamaseva kunye nejolisi.

I-Module 9: Ukuqwalasela ukhuseleko kwi-SQL Server Agent

Ezinye iimodyuli kule khosi zibonise imfuneko yokunciphisa iimvume ezinikezelwa kubasebenzisi, ngokulandela umgaqo "ilungelo elincinci." Oku kuthetha ukuba abasebenzisi baneemvume kuphela ezifunekayo ukwenza imisebenzi yabo. Ingcamango efanayo iyasebenza ekunikweni kwemvume kwi-Agent SQL Server. Nangona kulula ukwenza yonke imisebenzi kumxholo we-akhawunti yeenkonzo ze-Agent SQL Server, kunye nokuqwalasela i-akhawunti njengengxelo yezolawulo, indawo ekhuselekileyo yokhuseleko iya kubangelwa ukwenza oku. Kubalulekile ukuqonda indlela yokwakha indawo enqabileyo yokhuseleko kwimisebenzi eqhuba kwi-Agent SQL Server

  • Ukuqonda ukukhuselwa kwe-SQL Server Agent Security
  • Ukuqwalasela iCredentientials
  • Ukuqwalasela iAxy Accounts

ULebhu: Ukuqwalasela ukhuseleko kwi-SQL Server Agent

  • Ukuhlalutya iingxaki kwi-Agent SQL Server
  • Ukuqwalasela iCredential
  • Ukuqwalasela iAkhawunti yeProxy
  • Ukuqwalasela nokuvavanya iNkcazo yoKhuseleko yeJob

Emva kokugqiba le modyuli, uya kuba:

  • Cacisa ukhuseleko lwe-SQL Server Agent.
  • Qwalasela iinkcukacha.
  • Cwangcisa i-akhawunti yommeleli.

I-Module 10: Ukubeka iliso kwiSQL Server kunye neZaziso kunye neZaziso

Enye into ebalulekileyo yokulawula iMicrosoft SQL Server ngendlela efanelekileyo yokuqinisekisa ukuba uyazi iingxaki neziganeko ezenzeka kumncedisi, njengoko kwenzeka. I-SQL Server igawula ubutyebi beenkcukacha malunga nemiba. Ungayilungisa ukuba ikucebise ngokuzenzekelayo xa le micimbi ivela, ngokusebenzisa izaziso kunye nezaziso. Indlela eqhelekileyo yokuba abalawuli beenkcukacha zeSQL Server bafumana iinkcukacha zeziganeko zentshisekelo ngumyalezo we-imeyile. Le modyuli ibandakanya ukulungiswa kweMeyili yeDatabase, izilumkiso, kunye nezaziso ze-SQL Server umzekelo, kunye nokucwangciswa kwezilumkiso zeDiskripthi ye-Microsoft Azure yeSQL. Izifundo

  • Ukujonga Iimpazamo zeSQL Server
  • Ukuqwalasela i-Mail Database
  • Abaqhubi, iiNkcukacha kunye neAziso
  • Izaziso kwi-Azure yeSquL Database

ILab: Ukubeka iliso kwiSQL Server kunye neZaziso kunye neZaziso

  • Ukuqwalasela i-Mail Database
  • Ukuqwalasela abaSebenzi
  • Ukuqwalasela iZaziso kunye neZaziso
  • Izaziso zoVavanyo kunye neZaziso

Emva kokugqiba le modyuli, uya kuba:

  • Gcina iimpazamo zeSQL Server.
  • Lungiselela iposi leposi.
  • Qwalasela abasebenzisi, izaziso kunye neesaziso.
  • Sebenza ngezilumkiso kwiData ye-Azure yeSQL.

I-Module 11: Isingeniso kuLawulo lweSQL Server ngokusebenzisa i-PowerShell

Le modyuli ijonge indlela yokusebenzisa iWindows PowerShell kunye ne-Microsoft SQL Server. Amashishini asoloko efuna ukwandisa ukusebenza kunye nokuthembeka kokugcina iziseko zabo ze-IT; nge PowerShell, unokuphucula lo msebenzi kunye nokuthembeka ngokudala i-scripts ukwenza imisebenzi. Izikripthi ze-PowerShell zi novavanyo kunye nokusetyenziswa kwamaxesha amaninzi kumaseva amaninzi, ukugcina inhlangano yakho kokubili ixesha nemali

  • Ukuqalisa ngeWindows PowerShell
  • Qwalasela iSQL Server usebenzisa i-PowerShell
  • Ukulawula nokugcina i-SQL Server nge-PowerShell
  • Ukulawula i-SQL yolwazi lweeNkcukacha zoBuchule usebenzisa i-PowerShell

Ibhodi: Sebenzisa i-PowerShell ukuLawula i-SQL Server

  • Ukuqalisa nge PowerShell
  • Ukusebenzisa i-PowerShell ukutshintsha izilungiselelo zeSquL Server

Emva kokugqiba le modyuli, uya kuba:

  • Chaza i-PowerShell kunye neengcamango zayo ezisisiseko.
  • Qwalasela iSQL Server ngokusebenzisa i-PowerShell.
  • Ukulawula nokugcina iSQL Server ngokusebenzisa i-PowerShell.
  • Ukulawula i-Database ye-Azure yeSQL ngokusebenzisa i-PowerShell.

I-12 yeModyuli: UkuFumana Ukufikelela kwiSQL Server kunye neemeko ezongezelelweyo

Ukubeka esweni inkqubo yamatriki kunika indlela enkulu yokuvavanya ukusebenza ngokubanzi kwesisombululo sedatha. Nangona kunjalo, kukho izihlandlo xa kufuneka ukuba wenze uhlalutyo oluthe lucacisiwe lomsebenzi okwenzeka ngaphakathi kwimeko ye-Microsoft SQL Server-kwiingxaki zeengxaki kwaye ubone iindlela zokuphucula ukusebenza komthwalo wokusebenza. Iziganeko ezongeziweyo ze-SQL Server yi-flexible, lightweight-handling system system eyakhelwe kwiInjini ye-Microsoft yeSQL Server. Le modyuli ijolise kwiingcamango zokwakha, izicwangciso zokujongana neengxaki kunye nemiba yokusetyenziswa kweziganeko ezongezelelweyo. Izifundo

  • Iziganeko ezongezelelweyo Iingcamango ezingundoqo
  • Ukusebenza ngeZenzo ezongezelelweyo

Ibhab: Izehlakalo ezongezelelweyo

  • Ukusebenzisa iseshoni seNkqubo yeeNkqubo zoHlelo lweNkqubo
  • I-Tracking Page Splits usebenzisa iziganeko ezongezelelweyo

Emva kokugqiba le modyuli, uya kuba:

  • Chaza iziganeko ezongezelelweyo eziphambili.
  • Yakha kunye neenkomfa zeseshoni ezongeziweyo.

I-Module 13: Ukujonga iSQL Server

Injini yeDiski yeeNgcaciso yeMicrosoft ye-Microsoft SQL ingaqhuba ixesha elide ngaphandle kokufuna ukunakwa. Nangona kunjalo, ukuba ubeka iliso rhoqo umsebenzi owenzeka kwi-server yomnatha, unokukwazi ukujongana nemiba enokwenzeka ngaphambi kokuba ivele. I-SQL Server inikezela ngeenombolo zezixhobo onokuzisebenzisa ukubeka esweni umsebenzi okhoyo kunye nokurekhoda iinkcukacha zomsebenzi wangaphambili. Kufuneka ujwayelane nento nganye yezixhobo kunye nendlela yokusebenzisa ngayo. Kulula ukuphazamiseka ngumlinganiselo wokuveliswa kwezixhobo zokubeka iliso, ngoko kufuneka ukuba ufunde ubuchule bokuhlalutya iziphumo zazo.

  • Umsebenzi wokubeka esweni
  • Ukuthabatha nokuLawula iDatha yeNtsebenzo
  • Ukuhlalutya Idatha yokuSebenza eqokelelelweyo
  • SQL Server Utility

ULebhu: Ukubeka iliso kwiSQL Server

Emva kokugqiba le modyuli, uya kuba:

  • Ukubeka esweni imisebenzi yangoku.
  • Ukuthwala nokulawula idatha yokusebenza.
  • Hlaziya idatha eqokelelweyo yentsebenzo.
  • Qwalasela i-SQL Server Utility.

I-Module 14: Iingxaki zeSQL Server

Abalawuli beDatabase basebenzisana ne-Microsoft SQL Server kufuneka badlale indima ebalulekileyo ye-troubleshooter xa kuphakama imiba-ngakumbi ukuba abasebenzisi bezicelo ezibalulekileyo zoshishino ezithembele kwiziko leenkcukacha ze-SQL Server zithintela ukusebenza. Kubalulekile ukuba neendlela eziqinileyo zokusombulula imiba ngokubanzi, kwaye uqhelane nemiba eqhelekileyo enokuvela xa usebenza neenkqubo zeSQL Server. Izifundo

  • Indlela yokuThuthuka kweengxaki kwiSQL Server
  • UkuCombulula iiNdaba eziNxulumene neNkonzo
  • Ukuxazulula uxhulumano kunye nemiba yokungena

ULebhu: Inkxalabo yeeNgxaki eziqhelekileyo

  • Iingxaki ze-Troubleshoot kunye nokuSombulula i-SQL yokungena
  • Iingxaki kunye neSombululo seNkonzo yeNkonzo
  • Iingxaki ze-Troubleshoot kwaye Qoxa kwi-Windows Login Issue
  • Iingxaki kunye neSombululo seNkundla yokuSebenza
  • Iingxaki kunye neSombululo seNtsebenzo

Emva kokugqiba le modyuli, uya kuba:

  • Chaza indlela yokukhathazeka kweSQL Server.
  • Ukulungiswa kwemiba enxulumene nenkonzo.
  • Sombulula ukungena ngemvume kunye nemiba yokuxhuma.

I-Module 15: Ukungenisa nokuThumela idatha

Nangona idilesi enkulu yedatha ehlala kwiSmart Microsoft SQL Server ifakwe ngqo ngabasebenzisi abaqhuba iinkqubo zesicelo, kukho imfuneko yokuhambisa idatha kwezinye iindawo, ukuya kwi-SQL Server. I-SQL Server inikeza isethi yezixhobo ongazisebenzisayo ukuhambisa idatha ngaphakathi nangaphandle. Ezinye zezi zixhobo, ezifana ne-bcp (i-Bulk Copy Program) kunye ne-SQL Server Integration Services, zingaphandle kwikhojini yeenkcukacha. Ezinye izixhobo, ezifana ne-BULK INSTERT statement kunye nomsebenzi OPENROWSET, ziphunyezwa kwi-injini yedatha. Nge-SQL Server, unokwenza iiferenti-zicelo ezinxulumene neefayile ezipakisha zonke iitheyibhile, ukubukwa, kunye nokubonisa izinto ezihambelanayo nedatha yomsebenzisi kwiyunithi enye yokuthunyelwa. Kule modyuli, uya kuhlolisisa ezi zixhobo kunye nobuchule ukuze ungenise kwaye uthumele idatha kwiSQL Server kunye nakuyo. Izifundo

  • Ukudlulisa idatha kwiSQL Server
  • Ukungenisa nokuThengisa iDatha yeDatha
  • Ukusebenzisa i-bcp kunye ne-BULK INKQUBELA kwi-Import Data
  • Ukuhambisa nokuPhuculo lweSicelo -Nxulumene neNkqubo

ULebhu: Ukungenisa nokuThengisa iDatha

  • Idatha yokungenisa kunye ne-Excel usebenzisa i-Wizard yokungenisa
  • Ngenisa iFayile yeTekethi engapheliyo usebenzisa ibcp
  • Ngenisa iFayile yeTekethi engapheliyo usebenzisa i-BULK INSERT
  • Yakha uphinde uvivinye iPhakheji ye-SSIS ukuze ukhishwe kwiDatha
  • Sebenzisa i-Data-Tier Application

Emva kokugqiba le modyuli, uya kuba:

  • Chaza izixhobo kunye nobuchule bokudlulisa idatha.
  • Idatha yokuthumela nokuthumela ngaphandle.
  • Sebenzisa i-bcp kunye ne-BULK INSERT ukufaka idatha.
  • Sebenzisa izixhobo zokugcina iinkcukacha zokungenisa nokuthumela izicelo ze-database.

Uqeqesho oluzayo

Akukho ziganeko ezizayo ngeli xesha.

Nceda ubhalele apha info@itstechschool.com & xhumana nathi kwi-91-9870480053 kwixabiso lekhosi kunye neendleko zokuqinisekisa, ishedyuli kunye nendawo

Usilahle Umbuzo

Ukufumana ulwazi olungakumbi Qhagamshelana nathi.


Reviews




IINKCUKACHA ZEZICWANGCISO SEKOTA

  • Ukulawula uqeqesho lwe-SQL lweZiseko zoLwazi kwi-gurgaon
  • Ukulawula i-SQL yeSiseko seSiseko seZibonelelo seNkxaso-mali kwiGurgaon
  • ISikole sokuLawula i-SQL yeZiseko zoLwazi kwi-gurgaon
  • Ukulawula i-SQL i-Infrastructure Database kwiGurgaon
  • Ukulawula isatifikethi seZiseko seZiseko seSQL kwi-gurgaon
  • Ukulawula i-SQL yeZiko loLwazi lweZibonelelo kwiGurgaon
  • Ukulawula ngokugqibeleleyo iSQL yeSiseko seZiseko zoLwazi lwe-Infrastructure Online
  • Ukulawula uqeqesho lweZiko loLwazi lweZiseko zeSQL