ụdịỌzụzụ klas
Time5 Days
Deba aha

Kpọtụrụ Anyị

Ubi ama akara ya * na-achọrọ

 

Inye data SQL

Ịnye SQL Databases Ọzụzụ Agụmakwụkwọ & Asambodo

Description

Ndị na-ege ntị na ihe ndị dị mkpa

Ihe ndepụta

Nhazi & Ụgwọ

Asambodo

Inye usoro ihe omuma nke SQL

Nke a na-ezube iji kụziere ụmụ akwụkwọ otú e si nye SQL Server ọdụ data ma na premise na SQL Azure.

Ebumnuche nke Ịnye Ọzụzụ Data Data SQL

  • Nyefee Server Server
  • Kwalite SQL Server
  • Hazie SQL Server
  • Jikwaa ọdụ data na faịlụ (òkè)
  • Ntinye, ịkwaga ma jikwaa ọdụ data n'ime igwe-oji

Ejiri Ntuzi maka Ntuzi Data Databases

Ndị isi na-ege ntị maka usoro a bụ ndị na-enye ma na-akwado SQL Server ọdụ data. Ndị a na-eme nchịkwa nchekwa na nhazi dịka ọrụ ha kachasị mkpa, maọbụ ọrụ na gburugburu ebe ọdụ data na-arụ ọrụ dị mkpa n'ọrụ mbụ ha.

Ndị na-ege ntị nke abụọ maka usoro a bụ ndị na-azụlite ngwa ndị na-ewepụta ọdịnaya sitere na ọdụ data SQL Server.

Ihe ndị a chọrọ iji nweta data SQL Databases

Usoro a chọrọ ka ị zute ihe ndị a dị mkpa:

  • Ezigbo ihe omuma nke sistemụ arụmọrụ Microsoft na ọrụ ya.
  • Ịmara ihe Transact-SQL.
  • Ihe omuma ihe omuma data.
  • Ụfọdụ na-enweta ihe ngosi nchekwa data

Oge Nhazi Oge: 5 Days

1 Module: Ihe arụ 2016 SQL Server

Nke a modul kọwara ụdị SQL Server 2016 components na versions.Lessons

  • Okwu Mmalite nke SQL Server Platform
  • Isi nke SQL Server owuwu
  • Ọrụ SQL Server na nhazi Nhazi

Ụlọ: Mkparịta ụka: nsụgharị SQL Server

  • Mgbe anyị na-eji usoro dị iche iche nke SQL Server na mgbe ga-eji dị iche iche ihe atụ?
  • Kedu ụdị nke SQL Server kacha mma n'ime nzukọ gị?

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Kọwaa SQL Server components na nsụgharị.
  • Kọwaa njirimara SQL Server na ojiji ojiji.
  • Kọwaa ọrụ SQL Server na otu esi ejikwa nhazi nke ọrụ ndị ahụ.

2 Module: Ịwụnye SQL Server 2016

Modul ndị a na-akọwa usoro iji wụnye SQL Server 2016.Lessons

  • Echiche maka SQL Ịwụnye Server
  • Usoro TempDB
  • Ịwụnye SQL Server 2016
  • Ịkwụnye nrụnye

Laabu: Ịwụnye SQL Server

  • Chọpụta ihe onwunwe dịnụ
  • Wụnye ihe atụ nke SQL Server
  • Mee nlele ukpep nwụnye
  • Ịkwụnye nrụnye

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Kọwaa echiche ndị a mgbe ị na-etinye SQL Server.
  • Kọwaa faịlụ TempDB.
  • Wụnye 2016 SQL Server.
  • Megharia ngwa arụnyere SQL Server.

3 Module: Kwalite SQL Server na SQL Server 2016

Usoro a na-akọwa usoro maka mmelite na SQL Server 2016. Nkuzi

  • Nweta nkwalite
  • Nweta nkwalite SQL Server Ọrụ
  • Ibugharia SQL Server Data na Ngwa

Lab: Upgrading SQL Server

  • Mepụta Logins ngwa
  • Weghachite ndabere ndabere data
  • Ndị ọrụ na-enweghị nne na nna na ọkwa ntọala database

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Kọwaa nhazi nkwalite maka SQL Server.
  • Kwalite SQL Server.
  • Migrate SQL Server data na ngwa.

4 Module: Na - arụ ọrụ na ọdụ data

Nke a modul na-akọwa usoro data ntinye nke mbụ, usoro ọdịdị nke ọdụ data na nhazi nhazi kachasị mma metụtara ha.Lessons

  • Okwu Mmalite na Nchekwa Data na SQL Server
  • Ijikwa Nchekwa maka Ọdụ data System
  • Ijikwa Nchekwa maka Ọdụ data Ndị Ahịa
  • Ịkwaga na Iṅomi faịlụ nchekwa data
  • Nweta nkwalite: Na-ebugharị SQL Server Data na Ngwa
  • Ọnụ Mmiri Ọkụ Mmiri

Ụlọ nyocha: Ijikwa nchekwa nchekwa data

  • Configuring tempdb Nchekwa
  • Ịmepụta ọdụ data
  • Ijikọ data
  • Kwado Ọgba Mmiri Ọkụ Mmiri

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Kọwaa Nchekwa Data na SQL Server.
  • Jikwaa Nchekwa maka Ọdụ data System.
  • Jikwaa Nchekwa maka Ọdụ data Ndị ọrụ.
  • Bugharịa na Detuo faịlụ nchekwa data.
  • Kọwaa Nweta nkwalite site na akụkụ: Ịmalite usoro SQL Server Data na Ngwa.
  • Kọwaa ma jiri Ọgba Mmiri Ọgba Mmiri.

5 Module: Ịrụ ọrụ Ụlọ Nche

Nke a modul na-echekwa ndokwa atụmatụ nchekwa data.Lessons

  • Gbaa mbọ na iguzosi ike n'ezi ihe
  • Idebe akwụkwọ
  • Na-akpacha aka na nhazi usoro nhazi

Ụlọ nyocha: Ịrụ ọrụ ntanetị

  • Jiri DBCC CHECKDB iji nyochaa iguzosi ike n'ezi ihe
  • Akwụkwọ ndozi
  • Mepụta usoro nhazi usoro data

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Gbaa mbọ hụ na iguzosi ike n'ezi ihe.
  • Debe Akwụkwọ.
  • Ghazi usoro nhazi usoro nhazi.

6 Module: Nhọrọ nchekwa nchekwa data

Kọwaa nhọrọ nchekwa nchekwa SQL.Lessons

  • Ọrụ nchekwa SQL Server
  • SMB faịlụhare
  • Nchekwa SQL Server na Microsoft Azure
  • Nbudata Ntanye

Ụlọ nyocha: Ịmepụta Ntọala Ntọala

  • Gbaa Akaụntụ Ntọala Nyocha
  • Mepee Ntọala Ntọala

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Kọwaa arụmọrụ arụmọrụ SQL.
  • Kọwaa SMB faịlụhare.
  • Kọwaa Nchekwa Nchekwa SQL na Microsoft Azure.
  • Kọwaa ebe nchekwa data.

7 Module: Nzube iji dozie SQL Server na Microsoft Azure

Nke a modul na-akọwa otú e si eme atụmatụ idozi SQL Server na Azure.Lessons

  • Ejiri SQL Server arụ ọrụ na Azure
  • Nchekwa Azure
  • Eziokwu SQL Azure
  • Deploying a azure SQL Database

Ụlọ nyocha: Mee atụmatụ na Jigharịa SQL Database

  • Mee atụmatụ SQL Azure Database, IZIRỊTA, ọrụ ndị ọzọ, nche
  • Nweta SQL Azure
  • Jikọọ na Azure SQL Database

Mgbe i mechara usoro a, ị ga - enwe ike:

  • Kọwaa SQL Server mepụtara Machines na Azure.
  • Kọwaa Nchekwa Azure.
  • Kọwaa Eziokwu SQL, Azịza na nnabata.
  • Jiri Azure SQL Database.

8 Module: Nbanye Databases na Azure SQL Database

Usoro a na-akọwa otú ị ga-esi kwaga data data na Azure SQL Database.Lessons

  • Ngwaọrụ Nleba Migration nke Ụlọọrụ
  • Mbugharị Mgbanwe Mbupu Mbupu
  • Ịgagharị SQL Server database ka Azure SQL Database

Lab: Ibughari Databases Data SQL na Azure

  • Mee Nnwale Migration
  • Migrate a SQL Server database ka Azure SQL Database
  • Nyocha a megharịrị database

Mgbe i mechara usoro a, ụmụ akwụkwọ ga-enwe ike:

  • Kọwaa ngwaọrụ dịgasị iche iche nchekwa data nchekwa.
  • Kọwaa ihe gbasara nsogbu migration.
  • Migrate a SQL Server nchekwa data ka Azure SQL database.

9 Module: Deploying SQL Server na Microsoft Azure Virtual Machine

Nke a modul na-akọwa otu esi etinye SQL Server na Microsoft Azure VMs.Lessons

  • Deploying SQL Server na VAM Azure
  • Ntọala data maka Wizard Microsoft Azure Microsoft Azure

Lab: Deploying SQL Server na Azure Virtual Machine

  • Na-enye VM Azure
  • Jiri Nchịkọta Depụta na WM Wizard Azure

Mgbe i mechara usoro a, ụmụ akwụkwọ ga-enwe ike:

  • Debe SQL Server na VM Azure.
  • Jiri Deployment Depot Database ka Microsoft Azure VM Ọkachamara.

10 Module: Ijikwa ọdụ data na Ígwé ojii

Usoro a na-akọwa otu esi ejikwa SQL Server na Azure.Lessons

  • Ijikwa Azure SQL Database Security
  • Hazie Azure nchekwa
  • Azure akpaaka

Ụlọ nyocha: Ijikwa ọdụ data na ígwé ojii

  • Hazie Nchekwa Azure
  • Gbanyee Ọrụ Ịzụ Azure

Mgbe i mechara usoro a, ụmụ akwụkwọ ga-enwe ike:

  • Jikwaa Azure SQL Database Security.
  • Hazie Azure nchekwa.
  • Mee Azure akpaaka.

Na-abịa na Ihe

Enweghị ihe ọ bụla na-abịanụ n'oge a.

Biko dee anyị na info@itstechschool.com & kpọtụrụ anyị na + 91-9870480053 maka ụgwọ ọnụahịa & asambodo ụgwọ, oge & ọnọdụ

Wepụ Anyị Ajụjụ

Maka ozi ndị ọzọ Kpọtụrụ anyị.


Nyocha