ituaigaAoaoga a le potuaoga
Tusi Resitala

Faʻaaogāina o se Faletusi Faʻamatalaga ma le Microsoft SQL Server 2014 (M20463)

** Faʻaola Lau Pukaoloa Microsoft (SATV) mo le 20463 - Faʻaaogaina o Fale Faʻamaumauga Faʻamaumauga i le Microsoft SQL Server 2014 Training course & Certification **

lagona

Tagata faʻalogo

Taʻiala o le Vasega

Faamatalaga & Totogifuapauina

faʻamaoniga

M20463 XCHARX Implementing a Data Warehouse with Microsoft SQL Server 2014 Training

I lenei vasega, o le ae iloa ai le auala e faʻaaogaina ai se faʻamaumauga o fale teu oloa mo le lagolagoina o le poto masani pisinisi (BI). O le ae iloa pe faʻapefea ona e fausia se fale teu oloa, faʻaogaina se mea, suia, ma le mamafa (ETL) faʻatasi ma le SQL Server Integration Services (SSIS), ma faʻamaonia ma faʻamama faʻamaumauga i le Faʻatonuina o le Faʻatonuina o Auaunaga Faʻatonu (DQS) ma le Faʻamaumauga Faʻatonu a le Faʻatonu a le SQL Server.

O lenei kosi ua mamanuina mo tagata e fiafia i le aʻoaʻoina o le SQL Server 2012 poʻo le SQL Server 2014. E ufiufi ai foliga fou o le SQL Server 2014 faapea foi ma le taua tele i luga o le faʻamaumauga SQL Server.

O lenei kosi e aofia ai mea mai le Mea Faʻapitoa Faʻafaiaoga Microsoft 20463: Faʻatinoina o Fale Faʻamaumauga Faʻamaumauga ma le Microsoft SQL Server 2014. E aofia ai tomai ma malamalama na fuaina e le Exam 70-463 ma faʻatasi ai ma le poto masani ile-galuega, fesoasoani ia te oe e sauniuni mo le suʻega.

Sini o le Faʻatinoina o Fale Faʻamaumauga Faʻamatalaga ma le aʻoaʻoga a Microsoft SQL Server 2014

  • Faʻamaumauga o faleteuoloa faʻamatalaga ma mafaufauga faufale
  • Filifili se faʻamaumauga talafeagai mo masini mo fale teu oloa
  • Fuafua ma faʻaaoga se fale teu oloa
  • Faʻaaogā le tafe o faʻamatalaga ma le taofiofia o le tafe i se pusa SSIS
  • Tetee ma faʻalavelave faʻapipiʻi SSIS
  • Faʻatino se faʻafitauli SSIS e lagolagoina ai faʻaopoopoga faʻamaumauga o fale teuoloa ma le suʻeina o faʻamatalaga
  • Faʻaaogā faʻamalosi faʻamatalaga e faʻaaoga ai le Microsoft DQS
  • Faʻaaogaina le Auaunaga Faʻamaumauga a le Matai (MDS) e faʻamalosia le amio saʻo
  • Faʻatele le SSIS i faʻamaumauga faʻapitoa ma vaega
  • Faʻaaogā ma faʻapipiʻi pusa SSIS
  • Faʻafefea ona fofo faʻamatalaga o Faʻamatalaga Faʻamatalaga Tau Pisinisi i totonu o fale teu oloa

Tagata faʻalogo mo le faʻatinoga o le Faletusi Faʻamaumauga ma le Microsoft SQL Server 2014 Course

  • O tagata faʻapolofesa i luga o le database o loʻo manaʻomia le faʻatinoina o se galuega o le Faʻaleleia o le BI e taulaʻi i galuega faʻavae, faia o faʻamatalaga BI e aofia ai le faʻaaogaina o fale faʻamatalaga, ETL, ma le faʻamamaina o faʻamatalaga
  • O tagata tomai faapitoa i luga o le database e nafa ma le faʻaaogaina o se fale teu oloa, faʻapipiʻi SSIS packages mo le faʻaliliuina o faʻamatalaga, faʻaleleia, faʻaliliuina, suia, ma le faʻamalosia o faʻamaoni faʻamaumauga e faʻaaoga ai le MDS, ma le faʻamamaina o faʻamatalaga e faʻaaoga ai le DQS

Faʻatatau mo le faʻatinoina o fale faʻamaumauga faʻamaumauga ma le faʻamaumauga a Microsoft SQL Server 2014

  • Minimum tausaga lua tausaga o galulue ma faʻamatalaga faʻapitoa, e aofia ai le fuafuaina o se faʻamaumauga tuʻufaʻatasia, fatuina o laulau ma mafutaga
  • Faʻatulagaga faʻavae polokalame, e aofia ai le faʻamalosi ma le faʻalautele
  • Taulai atu i matāʻupu muamua o pisinisi, e pei o tupe maua, tupe maua, ma tala o tupe

Taʻiala o le Taimi Taimi: 5 Days

1. Faʻamatalaga Faʻamaumauga

  • Mafaufauga ma Ata Faʻataʻitaʻiga
  • Faʻamatalaga mo se Faʻamaumauga o fale teu oloa

2. Atinaʻe Faʻamaumauga o fale teu oloa

  • Filifiliga Faʻamatalaga
  • Faʻamatalaga Faʻamatalaga Faʻamatalaga o Fale teu oloa

3. Fuafuaina ma le Fausiaina o Fale Faʻamaumauga

  • Fuafuaga Faʻatino,
  • Faatinoina Faaletino

4. Fausia se faʻamaoniga a le ETL ma le SSIS

  • ETL ma SSIS
  • Suʻesuʻe Punavai Faʻamatalaga
  • Faʻaaogāina o le Fuga o Faʻamatalaga

5. Faʻaaogāina le Pulea o le Puleaina i se SSIS Package

  • Taofia le Totogi
  • Fausia Pusa Faʻaola
  • Faaaogaina o koneteina
  • Puleaina le Tumau

6. Debug ma Faʻamaumauga SSIS Packages

  • Totoina se SSIS Package
  • Saini le SSIS Package
  • Tuʻu Faʻasologa i se SSIS Package

7. Faʻatinoina se Faʻasalaga Tetele ETL

  • Incremental ETL

8. Faʻaleleia le Tulaga Aupito Manaomia

  • Microsoft SQL Server DQS
  • Faʻaaogā le DQS e fufulu ai faʻamaumauga
  • Faaaoga le DQS e fetaui ma faʻamatalaga

9. Faʻamaumauga o Faʻamaumauga

  • Faʻamatalaga Faʻatulagaga Faʻatonu a le Matai
  • Faʻaaogaina se Model Master Services Data
  • Faʻatautaia le Faʻamatalaga o le Matai ma Fausia se Faʻamatalaga o Faʻamatalaga Matai

10. Faʻateleina Auaunaga Faʻapipiʻi Fesoʻotaʻiga SQL (SSIS)

  • Faʻamaumauga Faʻamau i SSIS
  • Tusitusiga i SSIS

11. Faʻapipiʻi ma faʻapipiʻi SSIS Packages

  • Faiga Faʻavae Fuafuaga
  • Faʻapipiʻi Polokalama SSIS
  • Fuafua le faʻatulagaina o le SSIS

12. Faʻamaumauga Faʻatau i se Faletupe Faʻamaumauga

  • Faʻamatalaga Faʻamatalaga Faʻamatalaga
  • Lipoti ma Faʻamatalaga Faʻamatalaga

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

Tuʻu mai ia i matou se Fesili

Mo nisi faʻamatalaga agalelei Faafesootai matou.


iloiloga