homKev Kawm hauv Chav Kawm
Sau npe

Tiv tauj peb

Cov tsiaj ntawv cim nrog tus * yog xav tau

 

Siv cov ntaub ntawv Warehouse nrog Microsoft SQL Server 2014 (M20463)

** Txhawb koj lub Microsoft Vouchers (SATV) rau 20463 - Kev Siv Cov Ntaub Ntawv Warehouse nrog Microsoft SQL Server 2014 Kev Kawm Ntawv & Ntawv Pov Thawj **

Txheej txheem cej luam

cov neeg tuaj saib

Cov Qauv Dua

Teem & Cov Nqi

Certification

20463 - Siv cov Ntaub Ntawv Warehouse nrog Microsoft SQL Server 2014 Training

Nyob rau hauv hoob no, koj yuav kawm txog kev siv cov ntaub ntawv cia khoom lag luam los txhawb kev lag luam kev lag luam (BI). Koj yuav nrhiav tau li cas los tsim ib cov ntaub ntawv warehouse, siv extract, txia, thiab load (ETL) nrog SQL neeg rau zaub mov kev pab (SSIS), thiab validate thiab cleanse cov ntaub ntawv nrog SQL neeg rau zaub mov cov ntaub ntawv kev pab (DQS) thiab SQL Cov Kev Pab Cuam Tshaj Cov Ntaub Ntawv.

Hoob no yog tsim los rau cov neeg tuaj xav kawm txog SQL Server 2012 lossis SQL Server 2014. Nws npog cov tshiab nta ntawm SQL neeg rau zaub mov 2014 li no tseem ceeb peev txheej thoob SQL Server cov ntaub ntawv.

Chav kawm no sib txuas nrog cov ntaub ntawv los ntawm Kev Tshawb Fawb Microsoft Learning 20463: Kev Siv Cov Ntaub Ntawv Warehouse nrog Microsoft SQL Server 2014. Nws qhia txog cov txuj ci thiab kev paub los ntawm 70-463 thiab nrog rau kev ua haujlwm, pab koj npaj rau kev xeem.

Cov hom phiaj ntawm kev siv cov ntaub ntawv Warehouse nrog rau Microsoft SQL Server 2014 kev cob qhia

  • Cov ntaub ntawv cov khoom siv ua lag luam thiab kev xav txog kev tsim vaj tsev
  • Xaiv ib qhov chaw kho vajtse kom tsim nyog rau cov ntaub ntawv cia khoom
  • Tsim thiab siv cov ntaub ntawv cia khoom
  • Siv cov ntaub ntawv nquag thiab tswj ntws hauv pob SSIS
  • Debug thiab troubleshoot SSIS pob khoom
  • Siv qhov kev txhim kho SSIS uas txhawb nqa cov ntaub ntawv kom muaj kev nce siab thiab cov ntaub ntawv muab rho tawm
  • Siv cov ntaub ntawv ua kom siv Microsoft DQS
  • Siv Master Data Services (MDS) los tswj cov ntaub ntawv kev ntseeg
  • Ntev SSIS nrog kev cai cov ntawv sau tseg thiab cov khoom
  • Tseg thiab sib configures SSIS tej pob khoom
  • Yuav ua li cas Business Intelligence daws kom cov ntaub ntawv nyob rau hauv ib cov ntaub ntawv cia khoom

Qhia Cov Neeg Nruab Nrab ntawm Kev Siv Cov Ntaub Ntawv Warehouse nrog Microsoft SQL Server 2014 Chav

  • Database cov tub txawg uas yuav tsum tau ua kom tiav ntawm BI tus tsim lub luag haujlwm rau cov haujlwm tes ua haujlwm, tsim cov BI kev daws teeb meem nrog cov ntaub ntawv warehouse siv, ETL, thiab cov ntaub ntawv ntxuav
  • Database cov tub ua haujlwm tiv thaiv kev siv cov ntaub ntawv khaws tseg, tsim SSIS tej pob khoom rau cov ntaub ntawv rho tawm, kev thau khoom, hloov, hloov, thiab tswj cov ntaub ntawv keeb kwm siv MDS, thiab cov ntaub ntawv cleansing siv DQS

Yuavtsum tau kawm uantej rau Kev Siv Cov Ntaub Ntawv Warehouse nrog Microsoft SQL Server 2014 Daim Ntawv Ceeb Toom

  • Yam tsawg kawg nkaus ob xyoo dhau los ua hauj lwm nrog cov kev sib txuas lus nrog kev lag luam, nrog rau tsim tus qauv qub, tsim cov rooj thiab kev sib raug zoo
  • Cov kev qhia ntawv yooj yim heev, xws li looping thiab branching
  • Tsom rau kev lag luam tseem ceeb, xws li nyiaj, profitability, thiab nyiaj txiag

Cov Qauv Ntu Kev Kawm Duration: 5 Hnub

1. Cov Ntaub Ntawv Warehousing

  • Ntsiab Lus thiab Kev Xav Txog Tus Qauv Sau
  • Kev pom zoo rau Kev Kho Mob Warehouse Data

2. Cov Ntaub Ntawv Warehouse Infrastructure

  • Kho Khoom Siv Xaiv
  • Cov Ntaub Ntawv Warehouse Siv Architectures thiab Khoom Siv

3. Tsim thiab Siv Cov Ntaub Ntawv Warehouse

  • Kev Lag Luam Tsim,
  • Lub Cev Xam Pom

4. Tsim kom muaj ETL Solution nrog SSIS

  • ETL nrog SSIS
  • Tshawb qhov ntaub ntawv
  • Siv cov Data Flow

5. Xyaum Tswj Khoom Ntws hauv qhov SSIS Package

  • Tswj Ntws
  • Tsim Dynamic Packages
  • Siv Cov Ntim
  • Tswj Tswj Teeb Meem

6. Debug thiab Troubleshoot SSIS Ntim

  • Tshem tawm ib pob SSIS
  • Tshawb SSIS Rooj Txheej Txheem
  • Kaw cov kev txhaum hauv SSIS Pob

7. Xyaum Ua Tus Txheej Txheem hauv Incremental ETL

  • Incremental ETL

8. Txhawb Cov Ntaub Ntawv Zoo

  • Microsoft SQL neeg rau zaub mov DQS
  • Siv DQS rau Cov Ntaub Ntawv Tshaj Lij
  • Siv DQS los Cov Ntawv Qhia Ua Phem

9. Tswv Yim Cov Ntaub Ntawv

  • Yuav Tsum Tau Tshaj Cov Ntaub Ntawv Cov Ntaub Ntawv
  • Siv cov qauv kev qhia ntawv Master
  • Tswj Cov Ntaub Ntawv Cov Ntaub Ntawv thiab Tsim Tsim Kev Xa Cov Tshaj Tawm

10. Ntev SQL Server Kev Pab Sib Cais (SSIS)

  • Kev Cheebtsam hauv SSIS
  • Scripting hauv SSIS

11. Cais thiab Configure SSIS Packages

  • Txaus Siab Rau
  • Tso SSIS Tej Hauj Lwm
  • Npaj SSIS Lub Tswv Yim Kom Tiav

12. Txhawm rau Cov Ntaub Ntawv Hauv Cov Ntaub Ntawv Warehouse

  • Kev Lag Luam Kev Lag Luam
  • Kev Tshaj Qhia thiab Kev Tshawb Xyuas Txog Cov Ntaub Ntawv

Thov sau ntawv rau peb ntawm info@itstechschool.com & hu rau peb ntawm + 91-9870480053 rau cov nqi kawm & daim ntawv teev nqi, sij hawm & qhov chaw

Tawm Peb ib qho lus nug

Rau ntau info kindly Tiv tauj peb.


Xyuas