TypeKuphunzira Maphunziro
Time5 Masiku
Register

Lumikizanani nafe

Minda yodziwika ndi * zofunikira

 

Kupereka Zowonetsera SQL

Kupereka SQL Zomwe Zophunzitsira Zophunzitsa & Zovomerezeka

Kufotokozera

Omvetsera ndi Zoperekera

Zolembera Mwachidule

Ndandanda ndi Malipiro

chitsimikizo

Kupereka Zopangira SQL Zophunzitsa Maphunziro

Komitiyi yapangidwa kuti iphunzitse ophunzira momwe angapangire SQL Server zolongosoka zonse poyambira ndi SQL Azure.

Zolinga Zopereka SQL Zophunzitsira Maphunziro

  • Kupereka Chitsulo Chothandizira
  • Sungani SQL Server
  • Sungani SQL Server
  • Sungani Mazenera ndi Maofesi (adagawana)
  • Kukonzekera, kusamukira komanso kusunga mauthenga mtambo

Omvera Ovomerezeka Okonzekera SQL Zotsatira Zophunzitsa

Oyikira makamaka maphunzirowa ndi anthu omwe amachititsa ndikusunga SQL Server zolongosoka. Anthu awa amachita ma deta ndikusungirako zinthu monga malo awo ofunika, kapena kugwira ntchito m'madera omwe masanjidwe amathandiza kwambiri pantchito yawo yoyamba.

Ophunzira awiri a maphunzirowa ndi anthu omwe amapanga mapulogalamu omwe amapereka zinthu kuchokera ku SQL Server.

Zoperekera Zopereka SQL Zina Zopangidwe

Maphunzirowa amafuna kuti mukwaniritse zofunikira zofunika izi:

  • Chidziwitso chapadera pa mawonekedwe a Microsoft Windows ndi ntchito yake yaikulu.
  • Kudziwa ntchito Transact-SQL.
  • Kugwiritsa ntchito chidziwitso cha zidziwitso zogwirizana.
  • Zina mwazochitikira ndi makina opangidwira

Nthawi Yoyendetsera Nthawi Yomweyi: Masiku a 5

1 ya module: SQL Server 2016 Components

Mutu uwu umatanthauzira zigawo zosiyanasiyana za SQL Server 2016 ndi malemba.Zimenezi

  • Kuyamba kwa SQL Server Platform
  • Zachidule za SQL Server Architecture
  • Mapulogalamu a Pulogalamu ya SQL ndi Zosankha Zokonzekera

Lab: Zokambirana: Mabaibulo a SQL Server

  • Pamene tigwiritsa ntchito kupatula kwa SQL Server ndipo tikhoza kugwiritsa ntchito nthawi yosiyana?
  • Kodi ndi SQL Server yotani yomwe ili yabwino kwambiri m'bungwe lanu?

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani zigawo za SQL Server ndi mafotokozedwe.
  • Fotokozani zomangamanga za SQL Server ndi ntchito yogwiritsira ntchito.
  • Fotokozani mautumiki a SQL Server ndi momwe mumayendetsera kukonzekera kwa mautumikiwa.

XMUMX ya module: Kuika SQL Server 2

Ma modules awa akufotokoza njirayi kukhazikitsa SQL Server 2016.Zimenezi

  • Mfundo za SQL Kuika Server
  • Zithunzi za TempDB
  • Kuika SQL Server 2016
  • Kusuntha Kowonjezera

Lab: Kuika SQL Server

  • Ganizirani zomwe zilipo
  • Ikani chitsanzo cha SQL Server
  • Pangani zolemba zowonjezera
  • Kusuntha Kowonjezera

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozerani zochitika pakuika SQL Server.
  • Fotokozani mafayilo a TempDB.
  • Sakani SQL Server 2016.
  • Sungani kukhazikitsa SQL Server.

3 ya module: Kupititsa patsogolo SQL Server ku SQL Server 2016

Mutu uwu umalongosola ndondomeko yowonjezeredwa ku SQL Server 2016. Tikuphunzirapo

  • Zosintha Zofunikira
  • Sinthani Mapulogalamu a SQL Server
  • Kusuntha SQL Server Data ndi Mapulogalamu

Lab: Kupititsa patsogolo SQL Server

  • Pangani Zolemba Zogwiritsa Ntchito
  • Bwezeretsani Zosungira Zina
  • Ogwiritsira Ntchito Amasiye Ndi Mndandanda wa Maofesi Atsitsi

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani zofunikira zowonjezera SQL Server.
  • Sungani SQL Server.
  • Sungani data ya SQL Server ndi ntchito.

XMUMX yamagulu: Kugwira ntchito ndi Ma database

Mutu uwu umatanthauzira zolemba zomwe zanenedwa kale, mawonekedwe a zidziwitso ndi zosankha zomwe zimakhala zowonjezereka zokhudzana nazo.Zimenezi

  • Kuyamba kwa Kusungirako kwa Data ndi SQL Server
  • Kusamalira Zosungirako Zosungidwa Zamasamba
  • Kusamalira Zosungirako Zosungidwa Zogwiritsa Ntchito
  • Kusuntha ndi Kujambula Files Database
  • Kusintha kwa mbali-ndi-kumbuyo: Kusunthira SQL Server Data ndi Applications
  • Buffer Extension Pool

Lab: Kusamalira Zosungirako Zosungidwa

  • Kukonzekera tempdb Storage
  • Kupanga Zithunzi
  • Kuyika Database
  • Thandizani Buffer Pool Extension

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani zosungirako zosungirako ndi SQL Server.
  • Sungani Kusungirako Zida Zosungidwa.
  • Sinthani Zosungirako Zomwe Mukugwiritsa Ntchito.
  • Sungani ndi Kulemba Database Files.
  • Fotokozani Kupititsa Mbali-ndi-Kumbuyo: Kusunthira SQL Server Data ndi Mapulogalamu ndondomeko.
  • Fotokozani ndikugwiritsa ntchito Buffer Pool Extensions.

XMUMX ya Module: Kuchita Database Maintenance

Mutu uwu umapanga mapulani okonzekera ma database

  • Kutsimikizira Kukhulupirika Kwambiri
  • Kusunga Zisonyezero
  • Machitidwe Odziwika Okhazikika Maintenance

Lab: Kupanga Database Maintenance

  • Gwiritsani ntchito DBCC CHECKDB kuti muwitsimikizire Database Integrity
  • Zotsatira Zowonjezera
  • Pangani ndondomeko yokonza ndondomeko

Pambuyo pomaliza gawoli, mudzatha:

  • Onetsetsani Kukhulupirika Kwambiri.
  • Sungani Zisonyezero.
  • Yendetsani Maulendo Odziwika Okhazikika.

XMUMX ya Module: Zosungiramo Zosungiramo Zosungidwa

Fotokozani zosankha zosungiramo SQL Server

  • Ntchito yosungirako SQL Server
  • SMB Sintha
  • SQL Server Storage mu Microsoft Azure
  • Sakani Zosintha

Lab: Kugwiritsa ntchito Sitima yachinsinsi

  • Kuthamanga Stretch Database Advisor
  • Tsatirani Chitsulo Chothandizira

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani SQL Server Storage Performance.
  • Fotokozani Filamu Yotsatsa.
  • Fotokozani SQL Server Storage mu Microsoft Azure.
  • Fotokozani Database Stretch.

XMUMX Module: Kukonzekera Kutumiza SQL Server pa Microsoft Azure

Mutu uwu umalongosola momwe mungakonzekeretse kuti mutenge SQL Server pa Zotsatira za Azure

  • SQL Server Virtual Machines mu Azure
  • Kusungirako Azure
  • Kutsimikizira SQL Kuvomerezeka
  • Kutumizira A Azure SQL Database

Labu: Konzani ndi Kugwiritsa Ntchito SQL Database Yodziwika

  • Konzani Zokwanira SQL Database, Networking, ntchito tiers, chitetezo
  • Kupereka Zowonjezera SQL Database
  • Tsegulani ku Azure SQL Database

Pambuyo pomaliza gawoli, mudzatha:

  • Fotokozani SQL Server Virtual Machines mu Azure.
  • Fotokozani Kusungirako Azure.
  • Fotokozerani zapamwamba za SQL Kuvomerezeka, kuwerengera ndikutsatira.
  • Sungani Zokwanira SQL Database.

8 ya Module: Kusuntha Zithunzi Kuti Zithetse SQL Database

Mutu uwu umatanthawuza momwe mungasunthire ndondomeko ku Azure SQL Database.Lessons

  • Zida Zowesera Zosamukira
  • Nkhani Zogwirizana ndi Kusamukira Kwadongosolo
  • Kusunthira SQL Server Database kuti Yambitse SQL Database

Lab: Kusunthira SQL Server Zambiri Kuti Zisinthe

  • Yesani Kuyesera Kusamukira
  • Sungani SQL Server Database kuti Muyambe SQL Database
  • Yesani Kusinthika kwa Database

Pambuyo pomaliza gawoli, ophunzira athe:

  • Fotokozani zipangizo zosiyanasiyana zoyesera kusamukira kunthaka.
  • Fotokozerani zosamvana zomwe zimayenda mozungulira.
  • Sungani ndondomeko ya SQL Server kuti muzunge SQL database.

XMUMX ya Module: Kutumizira SQL Server pa Makina Opambana a Microsoft Azure

Mutu uwu ukufotokoza m'mene mungathere SQL Server pa Microsoft Azure VMs.Zimenezi

  • Kutumizira SQL Server pa VM ya Azure
  • The Deploy Database ku Microsoft Azure VM Wizard

Lab: Kutumizira SQL Server pa Chida Chokha Chokha

  • Kupereka VM Azure
  • Gwiritsani ntchito Deploy Database Kuti Muyambe VM Wizard

Pambuyo pomaliza gawoli, ophunzira athe:

  • Sendani SQL Server pa VM ya Azure.
  • Gwiritsani ntchito Deploy Database ku Microsoft Azure VM Wizard.

XMUMX ya Module: Kusamalira zolemba mu Cloud

Mutu uwu umalongosola momwe mungagwirire SQL Server pa Zotsatira za Azure

  • Kusamalira Ukhazikika SQL Database Security
  • Sungani yosungirako Azure
  • Azure Automation

Lab: Kusamalira Zambiri Zamtambo

  • Konzani Chitetezo cha Azure
  • Kuthamangitsidwa Kwambiri

Pambuyo pomaliza gawoli, ophunzira athe:

  • Sinthani Azure SQL Database Security.
  • Sungani yosungirako Azure.
  • Tsatirani Zokwanira Zomangamanga.

Maphunziro Otsogolera

Palibe zochitika zomwe zikubwera panthawiyi.

Chonde tilembereni pa info@itstechschool.com & tilankhulani nafe ku 91-9870480053 pa mtengo wamtengo wapatali & ndondomeko mtengo, ndondomeko & malo

Tisiyeni Funso

Kuti mudziwe zambiri, mverani mwachifundo Lumikizanani nafe.


Reviews




ZOYENERA KUFUNA ZOCHITA

  • Kupereka SQL Zopangira maphunziro mu gurgaon
  • Kupereka SQL Zomwe zimapangidwira ndalama ku Gurgaon
  • Institute for Provisioning SQL Zambiri mu gurgaon
  • Kupereka Zowonetsera SQL ku Gurgaon
  • Kupereka SQL Zomwe zimapangidwira chidziwitso ku gurgaon
  • Kupereka SQL Zopangira maphunziro ku Gurgaon
  • Mapulogalamu Opangira SQL Opambana Pa Maphunziro a Online
  • Kupereka SQL Zopangira maphunziro