ituaigaAoaoga a le potuaoga
taimiAso 5
Tusi Resitala

Tuuina atu o Faʻamaumauga SQL

Faʻapipiʻiina o aʻoaʻoga faʻamaumauga o faʻamaumauga ole SQL

faʻamatalaga

Tagata o loʻo faʻalogo ma faʻamuamua

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

Tuuina atu o aʻoaʻoga faʻamaumauga o faʻamaumauga SQL

O lenei vasega ua mamanuina e aʻoaʻoina ai tamaiti aʻoga i le auala e tuʻuina atu ai faʻamaumauga database a le SQL Server i luga o le fale ma le SQL Azure.

Sini o le Tuuina atu o Aʻoaʻoga Faʻamaumauga Faʻamaumauga

  • Tuʻuina se Tūmau Database
  • Faʻalautele le SQL Server
  • Faʻatulagaina le Tūmau SQL
  • Pulea Faʻamatalaga ma Faʻamaumauga (fefaʻasoaaʻi)
  • Tuuina atu, femalagaaʻi ma pulea faʻamaumauga i le ao

Intended Audience for Provisioning SQL Databases Course

O le aufaʻatasiga autu mo lenei vasega o tagata taʻitoʻatasi o loʻo faʻatino ma tausia faʻamaumauga o SQL Server. O nei tagata taʻitoʻatasi latou te faʻatino le puleaina o faʻamaumauga ma le tausiga o latou vaega autu o le matafaioi, poʻo le galue i siosiomaga lea o loʻo i ai faʻamaumauga autu i le latou galuega autu.

O le aufaʻasalalau lona lua mo lenei vasega, o tagata taʻitoʻatasi o loʻo atinaʻeina talosaga e tuʻuina atu ai faʻamatalaga mai faʻamaumauga o SQL Server.

Prerequisites Provisioning SQL Databases Certification

O lenei vasega e manaʻomia ai lou faʻatasia o mea nei e manaʻomia muamua:

  • Malamalamaaga autu o le polokalama o le faagaoioia o Microsoft Windows ma lona autu autu.
  • Fa'amatalaga galue o Galuega-SQL.
  • Faʻamatalaga galue i faʻamatalaga fesoʻotaʻiga.
  • O nisi o faʻamatalaga ma le faʻasologa o faʻamaumauga

Course Outline Duration: 5 Days

Faʻataʻitaʻiga 1: Faʻamaumau 2016 Tūmau SQL

O lenei vaega o loʻo faʻamatalaina vaega eseese o SQL Server 2016 ma versions.Lessons

  • Faatomuaga i le SQL Server Platform
  • Aotelega o le Faʻatulagaga o Faʻamaumauga SQL
  • Tautua Tūmau SQL ma Filifiliga Faʻatonu

Lusi: Talanoaga: Faʻamaumauga SQL Server

  • Pe a tatou faʻaaoga se isi faʻapipiʻi o le SQL Server ma o afea e faʻaaogaina ai se faʻavae ese?
  • O le fea itu o le SQL Server e sili ona talafeagai i lau faʻapotopotoga?

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala vaega o le SQL Server ma lomiga.
  • Faʻamatala le faʻasologa o le SQL Server ma le faʻaaogaina o punaoa.
  • Faʻamatala auaunaga a le Sāpono ma pe faʻapefea ona e pulea le faʻatulagaga o na 'auʻaunaga.

Modu 2: Faʻatuina o le Tūmau SQL 2016

O lenei 'auʻaunaga o loʻo faʻamatalaina le faagasologa e faʻapipiʻi ai le SQL Server 2016.Lessons

  • Iloiloga mo le SQL Setup Server
  • TempDB Faʻamatalaga
  • Faʻatuina o le SQL Server 2016
  • Faʻamomaga Faʻatonu

Lautusi: Faʻatulagaina o le SQL Server

  • Iloilo punaʻoa o maua
  • Faʻatulaga se faʻasologa o le SQL Server
  • Fai taga siaki faʻanatinati
  • Faʻamomaga Faʻatonu

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala manatu pe a faʻapipiʻi le Server SQL.
  • Faamatala le faila o le TempDB.
  • Faʻatuina le SQL Server 2016.
  • Faʻamuta se faʻapipiʻi SQL Server.

Module 3: Faaleleia le SQL Server i le SQL Server 2016

O lenei vaega o loʻo faʻamatalaina le faagasologa mo le faʻaleleia i le SQL Server 2016. Lesona

  • Faʻaleleia Manaoga
  • Faaleleia Auaunaga SQL Server
  • Faʻateleina o Faʻamaumauga o le SQL Server ma Talosaga

Lab: Faʻaleleia le Tūmau SQL

  • Fausia le Faʻailoga Talosaga
  • Faʻamālōlōina Backups Database
  • Ulugalii Tagata Uma ma le Database Database Compatibility Level

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala le faʻaleleia manaoga mo le SQL Server.
  • Faʻalautele le SQL Server.
  • Faʻasili atu faʻamatalaga SQL Server ma faʻaoga.

Module 4: Galulue ma Faʻamatalaga

O lenei vaega o loʻo faʻamatalaina ai faʻamaumauga o faʻamuamua ua maeʻa ona faʻaleleia, o le faʻavasegaga faaletino o faʻamaumauga ma faʻamaumauga sili ona laugatasia e fesoʻotaʻi ma i latou.Lessons

  • Folasaga i le Teuina o Meaʻai ma le SQL Server
  • Puleaina o le Teuina mo Faʻamaumauga Faʻatonu
  • Puleaina o le Teuina mo Faʻamaumauga o Tagata
  • Faʻasalalau ma Kopi Faʻamaumauga Faʻamaumauga
  • Faʻasalalau Faʻasalalau: Faʻateleina o Faʻamaumauga o Fesoʻotaʻiga SQL ma Talosaga
  • Faʻaauau Vaitafe

Lisi: Puleaina o le Teuina o Meafaigaluega

  • Faʻasaʻoina o le tempdb Storage
  • Fausia o Faʻamatalaga
  • Tuʻuina o se Faʻamaumauga
  • Faʻateleina le faʻaleleia o le faʻamaumauga

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faamatala le Faʻamaumauga o Faʻamaumauga ma le SQL Server.
  • Pulea le Teuina mo Faʻatonu o Faʻamatalaga.
  • Pulea le Teuina mo Faʻamaumauga o Tagata.
  • Alu ma Kopi Pakisi Faʻamatalaga.
  • Faʻamatala le Faʻasalalau Faʻasalalau: Faʻateleina o le Faʻamaumauga o Fesoʻotaʻiga SQL ma Talosaga.
  • Faʻamatala ma faʻaaoga Faʻamasinoga Vaitafe Vaitafe.

Faʻataʻitaʻiga 5: Faʻatinoina o le Tausiga o Faʻamaumauga

O lenei laupepa o loʻo aofia ai fuafuaga mo le tausiga o le database.Lessons

  • Faamautinoa o le Amio Saʻo
  • Faatumauina o Taui
  • Faʻamutaina Faʻamatalaga Faʻamatalaga Faʻamaumauga

Lautusi: Faatinoina o le Tausiga o Faʻamaumauga

  • Faaaoga le DBCC CHECKDB e Faʻamaonia ai le Amio Saʻo
  • Toe fausia Atinaʻe
  • Fausia se Fuafuaga mo le Tausiga o Faʻamaumauga

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Ia mautinoa le saʻo o le database.
  • Fausia faʻasologa.
  • Faʻamataʻu le Faʻamatalaga Faʻamatalaga Faʻamaumauga.

Faʻataʻitaʻiga 6: Faʻamaumauga mo le Puipuiga o le Database

Faʻamatala le filifiliga o le teuina o le SQL Server.Lessons

  • Faʻamaumauga o le Faʻamaumau o le SQL Server
  • SMB Fileshare
  • Tūmau SQL Server i Microsoft Azure
  • Faʻamaumauga Faʻamatalaga

Lautusi: Faʻatinoina o le Faʻamaumauga Faʻasaʻo

  • Faʻasalalau le Faufautua o le Faʻamatalaga o Faʻatonu
  • Faʻaaogā le Faʻamaumauga Faʻasaʻo

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala le Tausiga o le Faʻamaumauga o Sosaiete SQL
  • Faamatala SMB Fileshare.
  • Faamatala le Faʻamaumauga Tūmau SQL i Microsoft Azure.
  • Faʻamatala le Faʻamatalaga Faʻamatalaga.

Faʻataʻitaʻiga 7: Fuafuaga e faʻapipiʻi le SQL Server i luga o Microsoft Azure

O lenei vaega o loʻo faʻamatalaina le auala e fuafua ai e faʻapipiʻi le SQL Server i luga o Azure.Lessons

  • Faʻamaumauga Mataʻitusi Faʻamaumau SQL i le Azure
  • Faleoloa Azure
  • Azure SQL Authentication
  • Faʻapipiʻiina o le Database Database SQL

Laʻasaga: Fuafua ma Faʻapipiʻi se Faʻamatalaga Faʻasaʻo SQL

  • Fuafua se Faʻatonu Database Database, Networking, vaega o galuega, puipuiga
  • Tuuina atu se Database Database Database
  • Fesoʻotaʻi atu i le Database Database SQL

A maeʻa lenei faʻavae, o le a mafai ona e:

  • Faʻamatala le Faʻamaumauga Mataʻitusi Faʻasalalau Sisifo i le Azure.
  • Faamatala le Puipuiga o Azure.
  • Faamalamalama Azure SQL Authentication, suʻeina ma le tausisia.
  • Faʻapipiʻi se Faʻamaumauga Database Azure SQL.

Faʻataʻitaʻiga 8: Faʻasalalau Faʻamatalaga i le Faʻasaʻoina o SQL Database

O lenei vaega o loʻo faʻamatalaina le ala e faimalaga ai faʻamaumauga i le Database Database Database.Lessons

  • Faʻamaumauga Faʻataʻitaʻiga o Femalagaiga i Migration
  • Faʻamaumauga o Femalagaʻiga i le Faʻasalalau Faʻamatalaga
  • Faʻasalalauina o se Faʻamaumauga SQL Database i le Faʻatonu Database Database

Lautusi: Faʻasaoina o Faʻamaumauga Faʻamaumau SQL Server i le Azure

  • Fai Suʻega o Migration
  • Faʻamuta se Faʻamaumauga Faʻamaumau SQL i le Faʻatonu Database Database
  • Suʻeina se Faʻamaumauga Faʻasaʻo

A maeʻa lenei faʻavae, o le a mafai e tamaiti ona:

  • Faʻamatalaga eseese meafaigaluega mo le suʻeina o fuataga.
  • Faʻamatala faʻamalamalama faʻasalalauga tuʻufaʻatasiga o fesoʻotaiga.
  • Faʻasalalau se faʻamaumauga o SQL Server i le database o Azure SQL.

Module 9: Faʻapipiʻiina o le SQL Server i luga o se Masini Faʻatino Microsoft Azure

O lenei vaega o loʻo faamatalaina le auala e faʻaaogaina ai le SQL Server i Microsoft Azure VMs.Lessons

  • Faʻaaluina o le SQL Server i luga o se Azure VM
  • O le Fafoina o le Database i le Microsoft Azure Viz Wizard

Lautusi: Faʻapipiʻiina o le SQL Server i luga o se Masini Faʻasaʻo Azure

  • Tuuina atu se VM Azure
  • Faʻaaoga le Faʻapipiʻi le Database i le Azure VM Wizard

A maeʻa lenei faʻavae, o le a mafai e tamaiti ona:

  • Faʻapipiʻi le SQL Server i luga o se Azure VM.
  • Faaaoga le Fafoina o Faʻamatalaga i le Microsoft Azure Viz Wizard.

Module 10: Puleaina o faʻamaumauga i le Cloud

O lenei vaega o loʻo faʻamatalaina le auala e pulea ai le SQL Server i Azure.Lessons

  • Puleaina o Azure SQL Database Security
  • Faʻasaʻo le teuina o Azure
  • Azure Automation

Lisi: Pulea o Faʻamaumauga i le Lagi

  • Faʻasaʻo le Puipuiga Auro
  • Faʻamuta le Faʻatonuina o Auro

A maeʻa lenei faʻavae, o le a mafai e tamaiti ona:

  • Pulea Azure SQL Database Security.
  • Faʻasaʻo le teuina o Azure.
  • Faʻaaoga le Azure Automation.

Aʻoaʻoga Faʻaauau

E leai ni mea tutupu i le taimi nei.

Faamolemole tusi mai ia i matou i le info@itstechschool.com & faʻafesoʻotaʻi i matou i le 91-9870480053 mo le tau aʻoaʻoga & tusi tau tusi, faʻasologa ma le nofoaga

Tuʻu mai ia i matou se Fesili

Mo nisi faʻamatalaga agalelei Faafesootai matou.


iloiloga