UhloboUkuqeqesha ekilasini
Isikhathi5 Days
BHALISA

Xhumana nathi

Izinsimu ezimakwe nge * Kudingeka

 

Ukuhlinzeka nge-SQL yolwazi

Ukuhlinzeka nge-SQL yolwazi Ukuqeqesha nokuQinisekisa

Incazelo

Izilaleli & Izidingo Zokuqala

Uhlaka Lokufunda

Uhlelo noHlelo

Certification

Ukuhlinzeka nge-SQL yolwazi lokuqeqesha

Leli klasi laklanyelwe ukufundisa abafundi indlela yokuhlinzeka ngolwazi lwe-SQL Server kokubili kokubeka phambili naku-SQL Azure.

Izinjongo Zokuhlinzekela Ukuqeqesha Ulwazi lwe-SQL

  • Ukuhlinzeka ngeServer Database
  • Thuthukisa i-SQL Server
  • Lungiselela i-SQL Server
  • Phatha imininingwane kanye namafayela (okwabiwe)
  • Ukuhlinzeka, ukufuduka nokuphatha yolwazi ku- ifu

Izilaleli ezihlosiwe zokuhlinzeka nge-SQL yolwazi lwezinkundla

Izilaleli eziyinhloko kule nkambo ngabanye abaphatha futhi balondoloze ulwazi lweSQL Server. Laba bantu benza ukuphathwa kanye nokugcinwa kwedatha njengendawo yabo eyinhloko yomthwalo wemfanelo, noma basebenza ezindaweni lapho ulwazi oludlala khona ludlala indima ebalulekile emsebenzini wabo oyinhloko.

Izilaleli zesibili zalesi sifundo ngabantu abahlakulela izicelo eziletha okuqukethwe okuvela kulwazi lwe-SQL Server.

Okudingekayo Okuhlinzekwa kweSQL yolwazi Izaziso

Lezifundo zidinga ukuba uhlangabezane nalezi zinto ezilandelayo:

  • Ulwazi oluyisisekelo ohlelweni lokusebenza lwe-Microsoft Windows kanye nokusebenza kwalo okuyisisekelo.
  • Ulwazi lokusebenza I-Transact-SQL.
  • Ukwaziswa okusebenzayo yolwazi lokuxhumana.
  • Okunye okuhlangenwe nakho kokuklanywa kwedatha

Isikhathi sokuphuma kwesikhathi sezinkathi: Izinsuku ze-5

I-Module 1: Izingxenye ze-SQL Server 2016

Le module ichaza izingxenye ezihlukahlukene ze-SQL Server 2016 nezinguqulo.Izici

  • Isingeniso kwi-SQL Server Platform
  • Uhlolojikelele lwe-Architecture ye-SQL Server
  • Isevisi ye-SQL Server kanye nezinketho zokucushwa

I-Lab: Ingxoxo: izinguqulo ze-SQL Server

  • Uma sisebenzisa ukufakwa okuhlukile kwe-SQL Server futhi nini uzosebenzisa isigaba esihlukile?
  • Iyiphi inguqulo ye-SQL Server efaneleke kakhulu enhlanganweni yakho?

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza izingxenye ze-SQL Server nezinguqulo.
  • Chaza ukwakheka kwe-SQL Server nokusetshenziswa kwemithombo.
  • Chaza amasevisi we-SQL Server nokuthi ulawula kanjani ukucushwa kwalawo masevisi.

I-Module 2: Ukufaka i-SQL Server 2016

Lezi modyuli zichaza inqubo yokufaka i-SQL Server 2016.Izici

  • Ukucatshangelwa kweSQL Ukufaka Iseva
  • Amafayela we-TempDB
  • Ukufaka i-SQL Server 2016
  • Ukuzenzakalela ukufakwa

I-Lab: Ukufaka i-SQL Server

  • Hlola izinsiza ezikhona
  • Faka isibonelo se-SQL Server
  • Yenza ukuhlolwa kokuthunyelwe kokuthunyelwe
  • Ukuzenzakalela ukufakwa

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza ukucabangela lapho ufaka iSQL Server.
  • Chaza amafayela we-TempDB.
  • Faka i-SQL Server 2016.
  • Hlela ukufakwa kwe-SQL Server.

I-Module 3: Ukuthuthukisa i-SQL Server ku-SQL Server 2016

Le module ichaza inqubo yokuthuthukiswa ku-SQL Server 2016. Izifundo

  • Izidingo zokuthuthukisa
  • Thuthukisa amasevisi we-SQL Server
  • Ukuthutha idatha ye-SQL Server kanye nezicelo

I-Lab: Ukuthuthukisa i-SQL Server

  • Yakha ukungena ngemvume kohlelo lokusebenza
  • Buyisela izipele ze-Database
  • Abasebenzisi bezintandane kanye neNgcono yokuThuthukiswa kwedatha

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza izidingo zokuthuthukisa i-SQL Server.
  • Thuthukisa i-SQL Server.
  • Thuthela idatha ye-SQL Server nezinhlelo zokusebenza.

I-Module 4: Ukusebenza nolwazi olusetshenziswayo

Le modolula ichaza ulwazi olususwe ngaphambili lwesistimu, isakhiwo sangokwenyama yolwazi kanye nezinketho ezijwayelekile zokucushwa ezihlobene nabo.Izici

  • Isingeniso kwisitoreji sedatha nge-SQL Server
  • Ukuphatha Isitoreji Semininingwane Yesistimu
  • Ukuphatha Isitoreji Semininingwane Yomsebenzisi
  • Ukuhambisa nokukopisha amafayela e-Database
  • Ukuthuthukiswa kocansi-nge-Side: Ukuthutha idatha ye-SQL Server kanye nezicelo
  • I-Buffer Pool Extension

Ilabhu: Ukuphatha Isitoreji SeSitolo

  • Ilungiselela isitoreji se-tempdb
  • Ukudala yolwazi
  • Ukuhlanganisa i-Database
  • Nika amandla ukukhuliswa kwe-Pool Buffer

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza ukugcinwa kwedatha nge-SQL Server.
  • Phatha Isitoreji Semininingwane Yasistimu.
  • Phatha Isitoreji Semininingwane Yomsebenzisi.
  • Hambisa futhi Kopisha Amafayela Ezigciniwe.
  • Chaza ukuthuthukiswa okuhlangene-nge-Side: Ukuthutha inqubo ye-SQL Server Data and Applications process.
  • Chaza futhi usebenzise izandiso ze-Buffer Pool.

I-Module 5: Ukwenza i-Database Maintenance

Le module ihlanganisa izinhlelo zokulondolozwa kwedatha

  • Ukuqinisekisa ukuthembeka kwedatha
  • Ukugcina ama-index
  • Ukuzenzekelayo Ukugcinwa Kwemininingwane Yedatha

I-Lab: Ukwenza i-Database Maintenance

  • Sebenzisa i-DBCC CHECKDB ukuze uqinisekise ukuthembeka kwedatha
  • Izinkampani ezakha kabusha
  • Dala uhlelo lokugcinwa kwedatha

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Qinisekisa ukuthembeka kwedatha.
  • Londoloza izinkomba.
  • Yenza ngokuzenzakalelayo ukugcinwa kwedatha yokugcinwa kwedatha.

I-Module 6: Izinketho zokugcina idatha

Chaza izinketho zokugcina isitoreji se-SQL Server

  • Ukusebenza kwesitoreji seSQL Server
  • SMB Ukudlala
  • Isitoreji seSQL Server ku-Microsoft Azure
  • Sula imininingwane

I-Lab: Ukusebenzisa i-Stretch Database

  • Run Stretch Database Advisor
  • Qalisa i-Stretch Database

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza ukusebenza kwesitoreji se-SQL Server.
  • Chaza ukuhlunga kwe-SMB.
  • Chaza isitoreji se-SQL Server ku-Microsoft Azure.
  • Chaza i-Stretch Database.

I-Module 7: Ukuhlela Ukusebenzisa I-SQL Server ku-Microsoft Azure

Le module ichaza indlela yokuhlela ukuhambisa i-SQL Server kuma-Azure.Izici

  • Amashini we-SQL Server Virtual in Azure
  • Isitoreji se-Azure
  • I-Azure SQL Ukuqinisekisa
  • Ukuthumela idatha ye-Azure SQL

Lab: Hlela futhi usebenzise Idatha ye-Azure yeSQL

  • Hlela i-Database ye-Azure ye-SQL, I-Networking, i-performance tiers, ukuphepha
  • Ukuhlinzeka nge-Database ye-Azure yeSQL
  • Xhuma kwi-Database ye-Azure SQL

Ngemuva kokuqedela le moduli, uzokwazi uku:

  • Chaza ama-SQL Server Virtual Machines ku-Azure.
  • Chaza ukugcinwa kwe-Azure.
  • Chaza ukuqinisekiswa kwe-Azure SQL, ukuhlola nokuhambisana.
  • Sebenzisa i-Database ye-Azure SQL.

I-Module 8: Ukufuduka kwemininingwane ukuze kutholakale i-SQL Database

Le module ichaza ukuthi ungathutha kanjani imininingwane yolwazi ku-Azure SQL Database

  • Amathuluzi Wokuvivinya Ukuthutha Idatha
  • Imibuzo yokuhambisana nokuhamba kwe-Database
  • Ukuthuthela i-SQL Server Database ukuze uqinisekise i-SQL Database

I-Lab: Ukufuduka kwe-SQL Server yolwazi ukuze kuqinisekiswe

  • Yenza ukuhlolwa kokuhamba
  • Thuthela i-SQL Server Database ukuze uqinisekise i-SQL Database
  • Hlola i-Database edlulisiwe

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Chaza izinhlobo ezahlukene zokuhlola ukuhamba kwamadatha.
  • Chaza izinkinga zokuhambisana kokuhamba kwedatha.
  • Thuthela imininingwane ye-SQL Server ukuze uqinisekise i-SQL database.

I-Module 9: Ukuthumela i-SQL Server kumshini we-Microsoft Azure Virtual

Le module ichaza indlela yokuhambisa i-SQL Server kwi-Microsoft Azure VMs.Izifundo

  • Ukuthumela i-SQL Server kwi-VM e-Azure
  • I-Deploy Database ku-Wizard ye-Microsoft Azure VM

I-Lab: Ukuthumela i-SQL Server kumshini we-Azure Virtual

  • Ukuhlinzeka nge-VM e-Azure
  • Sebenzisa i-Deploy Database ukuze uqinisekise i-Wizard VM

Ngemuva kokuqedela le module, abafundi bazokwazi:

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

I-Module 10: Ukuphatha yolwazi ku-Cloud

Le module ichaza indlela yokuphatha i-SQL Server ku-Azure

  • Ukuphatha i-Azure Database ye-Azure Database
  • Lungiselela isitoreji se-Azure
  • I-Azure Automation

Ilabhu: Ukuphatha Ulwazi olusuka ku-Cloud

  • Lungiselela ukuphepha kwe-Azure
  • Hlela ukuthunyelwa kwe-Azure

Ngemuva kokuqedela le module, abafundi bazokwazi:

  • Phatha i-azure SQL Database Security.
  • Lungiselela isitoreji se-Azure.
  • Phumelela i-Azure Automation.

Imicimbi ezayo

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