uhloboUqeqesho lweKlasi
ixesha5 Days
INCWADI

Qhagamshelana nathi

Iimimandla ezimakwe kunye * zifunwa

 

Ukubonelela ngeSQL yolwazi

Ukubonelela ngeSQL Iinkcukacha zoQeqesho noQeqesho

inkcazelo

Abaphulaphuli kunye neemfuno ezifunekayo

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

Ukubonelela ngeSQL Iinkcukacha zoQeqesho loQeqesho

Le khosi yenzelwe ukufundisa abafundi indlela yokubonelela ngeenkcukacha zeSQL Server zombini kunye ne-SQL Azure.

Iinjongo zokubonelela ngeSQL yolwazi Uqeqesho

  • Ukubonelela ngeServer Database
  • Ukuphucula iSQL Server
  • Qwalasela i-SQL Server
  • Ukulawulwa kweenkcukacha kunye namaFayile (okwabiwe)
  • Ukubonelela, ukufuduka nokulawula iinkcukacha kwi ilifu

Abaphulaphuli abanenjongo yokubonelela ngeSQL yolwazi lweeNgcaciso

Abaphulaphuli bephambili kule khosi ngabantu abalawulayo nokugcina i-SQL Server yolwazi. Aba bantu benza ukugcinwa kwedatha kunye nokugcinwa kwedatha njengendawo yabo ephambili yokuxanduva, okanye basebenze kwiimeko apho indawo yolwazi idlala indima ephambili emsebenzini wabo oyintloko.

Abaphulaphuli ababini beli khosi ngabantu abahlakulela izicelo ezihambisa umxholo kwiSquL Server yolwazi.

Iimfuno ezifunekayo zokubonelela Ukubonelela ngeSQL yolwazi lweSatifikethi

Le khosi idinga ukuba uhlangabezane neemfuno ezilandelayo:

  • Ulwazi olusisiseko lweenkqubo ze-Microsoft Windows kunye nomsebenzi wayo oyintloko.
  • Ulwazi lo msebenzi Transact-SQL.
  • Ulwazi olusebenzayo lweenkcukacha zolwazi.
  • Amanye amava kunye noyilo lweenkcukacha

Ixesha loKhutshwa kweNkundla: Iintsuku ze-5

I-Module 1: I-SQL Server 2016 Components

Le modyuli ichaza iinkalo ezahlukeneyo zeSQL Server 2016 kunye neenguqulelo

  • Isingeniso kwisiCwangciso seSQL Server
  • Ubume bemiSebenzi yeSQL Server
  • IiNkonzo ze-SQL Server kunye neenketho zoqwalaselo

IBhabhu: Ingxoxo: Iinguqulelo zeSQL Server

  • Xa sisebenzisa ukufakela okuhlukeneyo kweSQL Server kwaye nini na ukusetyenziswa kwimeko ehlukeneyo?
  • Yiyiphi inguqu ye-SQL Server efanelekileyo kakhulu kwimibutho yakho?

Emva kokugqiba le modyuli, uya kuba:

  • Chaza izinto zeSQL Server kunye neenguqulelo.
  • Chaza uphuhliso lweSQL Server kunye nokusetyenziswa kwezixhobo.
  • Chaza iinkonzo ze-SQL Server kunye nendlela olawula ngayo ukulungiswa kwezi nkonzo.

I-Module 2: Ukufaka iSQL Server 2016

Ezi modyuli zichaza inkqubo yokufaka i-SQL Server 2016

  • Iingqwalasela zeSQL Ukufaka iNcedisi
  • Iifayile zeSpDB
  • Ukufaka iSQL Server 2016
  • Ukuzenzekelayo Ukufakwa

ULebhu: Ukufaka iSquL Server

  • Hlola izinto ezikhoyo
  • Faka umzekelo weSQL Server
  • Yenza ukuhlolwa kwesithuba
  • Ukuzenzekelayo Ukufakwa

Emva kokugqiba le modyuli, uya kuba:

  • Chaza ingqalelo xa ufaka iSQL Server.
  • Chaza iifayile ze-TempDB.
  • Faka iSQL Server 2016.
  • Ukuzenzekelayo ukufakwa kweSQL Server.

I-Module 3: Ukuphucula iSQL Server kwi-SQL Server 2016

Le modyuli ichaza inkqubo yokuphucula kwi-SQL Server 2016. Izifundo

  • Iimfuneko zokuPhucula
  • Ukuphucula iiNkonzo ze-SQL Server
  • Ukufuduka kweDatha yeWindows ne-Applications

ULebhu: Ukuphucula iSQL Server

  • Yakha i-Logins Application
  • Buyisela kwakhona i-Backup data
  • Abasebenzisi beeNtsana kunye neNgcaciso yeNqanaba lokuBambisana

Emva kokugqiba le modyuli, uya kuba:

  • Chaza iimfuno zokuphucula i-SQL Server.
  • Ukuphucula iSQL Server.
  • Ukuthutha idatha yeSQL Server kunye nezicelo.

I-Module 4: Ukusebenza neenkcukacha

Le modyuli ichaza iinkcukacha zolwazi olusungulwe ngaphambili, isakhiwo sendawo yolwazi kunye nolona lukhetho oluqhelekileyo olunxulumene nabo.

  • Isingeniso kwiSitoreji seDatha ngeSQL Server
  • Ukulawula Ukugcinwa kweenkcukacha zolwazi
  • Ukulawula Ukugcinwa Kweenkcukacha Zomsebenzisi
  • Ukuhambisa nokukhuphela iiFayile zeDatala
  • Ukuphuculwa kweCala-nge-Side: Ukufudukela kwiDatha yeSQL Server kunye nezicelo
  • Uphuhliso lweZiphulo sePlastiki

ILab: Ukulawula iSitoreji seSigcineko

  • Ukuqwalasela i-Tempdb Storage
  • Ukudala yolwazi
  • Ukudibanisa iDatabase
  • Nika amandla ukwandiswa kweZibhulo zePlastiki

Emva kokugqiba le modyuli, uya kuba:

  • Chaza ukugcinwa kwedatha ngeSQL Server.
  • Ukulawula ukugcinwa kweenkcukacha zolwazi.
  • Ukulawula Ukugcinwa Kweenkcukacha Zomsebenzisi.
  • Hambisa kwaye Khuphela Iifayile Zedatha.
  • Chaza ukuPhucula okuPhakathi-nge-Side: Ukufuduka kweSquL Server Data kunye neNkqubo yezicelo.
  • Chaza kwaye usebenzise i-Buffer Pool Extensions.

I-Module 5: Ukwenza iSondlo seNgcaciso

Le modyuli iquka izicwangciso zokugcina izigcawu

  • Ukuqinisekisa ukuthembeka kweDatabase
  • Ukugcina iiNkcukacha
  • Ukuzenzekelayo Ukugcinwa kweDatabase yeSondlo

ULebhu: Ukwenza iSondlo seNgcaciso

  • Sebenzisa i-DBCC CHECKDB ukuqinisekisa ubungqina beDatabase
  • Iingxelo zoKwakha
  • Yenza isicwangciso seSondlo seNgcaciso

Emva kokugqiba le modyuli, uya kuba:

  • Qinisekisa ukuthembeka kweDatabase.
  • Ukugcina iiNkcazo.
  • Ukuzenzekelayo i-Routine Database Maintenance.

I-Module 6: Izinketho zokuLondoloza idatha

Chaza ukhetho lweSQL Server

  • Isitoreji Sokugcina isitoreji seSQL
  • SMB Fayile
  • Isitoreji seSQL Server kwiMicrosoft Azure
  • Uluhlu lweenkcukacha

ULebhu: Ukuphunyezwa kweStrch Database

  • Jonga umcebisi weNgcaciso yoMgcini-mhlaba
  • Qalisa iNgcaciso yeSiseko

Emva kokugqiba le modyuli, uya kuba:

  • Chaza ukusebenza kweServices Server.
  • Chaza i-SMB ifayile.
  • Chaza ukugcinwa kweSQL Server kwi-Microsoft Azure.
  • Chaza iNgcaciso yedata.

I-Module 7: Ukucwangcisa ukusebenzisa iSQL Server kwi-Microsoft Azure

Le modyuli ichaza indlela yokucwangcisa ukuhambisa i-SQL Server kwi-Azure

  • I-SQL Server Virtual Machines kwi-Azure
  • Ukugcinwa Kwezakhiwo
  • I-Azure yeSQL Ukuqinisekiswa
  • Ukuthumela i-Database ye-Azure yeSQL

ULabhanki: Cwangcisa kwaye usebenzise iNgcaciso yeSQL ye-Azure

  • Cwangcisa i-Database ye-SQL ye-Azure, i-Networking, i-performance tiers, ukhuseleko
  • Ukubonelela ngeNgcaciso yeSquL Database
  • Xhuma kwi-Database ye-Azure yeSQL

Emva kokugqiba le modyuli, uya kuba:

  • Chaza i-SQL Server Virtual Machines kwi-Azure.
  • Chaza i-Azure Storage.
  • Chaza i-Azure yeSQL Ukuqinisekiswa, ukuphicothwa nokuthotyelwa.
  • Sebenzisa i-SQL ye-Azure Database.

I-Module 8: Ukufuduka kweenkcukacha zeNgcaciso zeSQL

Le modyuli ichaza indlela yokufudukela kwiinkcukacha zolwazi ukuya ku-Azure yeSquL Database

  • Izixhobo zokuvavanya ukuThuthwa kweDatha
  • Imiba yokuHlangana nokuThuthukiswa kweNgcaciso
  • Ukufuduka kweSediferensi yeSquL yeService yoNgcaciso lweSQL

ULebhu: Ukufuduka kweSquL Server yolwazi kwiNgcaciso

  • Ukuvavanywa kweMigration
  • Ukuthutha i-SQL Server Database ukuze uhlaziye i-SQL Database
  • Vavanya iData eDlulileyo

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Chaza izinto ezahlukeneyo zovavanyo lokufuduka kweenkcukacha.
  • Cacisa imiba yokuhambelana nokuhamba kwedatha.
  • Ukufudula isiseko seSQL Server ukuze uhlalise i-SQL database.

I-Module 9: Ukuthumela i-SQL Server kwiMicrosoft Azure Virtual Machine

Le modyuli ichaza indlela yokuhambisa i-SQL Server kwiMicrosoft Azure VM

  • Ukuthumela i-SQL Server kwi-VM ye-Azure
  • I-Deployment Database kwi-Microsoft Azure VM Wizard

ULebhu: Ukuthumela i-SQL Server kwiMashini eyiNgcaciso yeMicrosoft

  • Ukubonelela ngeVM eVukileyo
  • Sebenzisa i-Deploy Database ukuze uhlaziye iWeb Wizard

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Sebenzisa i-SQL Server kwi-VM ye-Azure.
  • Sebenzisa i-Deploy Database kwi-Microsoft Azure VM Wizard.

I-Module 10: Ukulawula yolwazi kwiLu

Le modyuli ichaza indlela yokulawula i-SQL Server kwi-Azure

  • UkuPhatha i-SQL yoLwazi lweNgcaciso yeNgcaciso
  • Qwalasela ukugcinwa kwe-Azure
  • I-Azure Automation

ULabhanki: Ukulawula iiNgcaciso kwiLu

  • Qwalasela iNgcaciso yoKhuseleko
  • Ukuzenzekelayo Ukuthunyelwa kweeNzululwazi

Emva kokugqiba le modyuli, abafundi baya kuba nako uku:

  • Ukulawula iNgcaciso yeSebl yeSebond Database.
  • Qwalasela ukugcinwa kwe-Azure.
  • Ukuzalisekisa iAzure Automation.

Imicimbi ezayo

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