Kushandisa Dare rekuchengetedza Dzimba ne Microsoft SQL Server 2014 (M20463)

** Chengetedza Zvitengi Zvako zveMicrosoft (SATV) ye20463 - Kushandisa Dare Rekuchengetedza Data ne Microsoft SQL Server 2014 Dzidzo Nokudzidziswa **

tsananguro

Vateereri

Course Outline

Purogiramu nemitengo

kutaura kuti ichokwadi

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

Muchikoro ichi, iwe uchadzidzira nzira yekushandisa dhipatimendi yekuchengetedza dhaka yekusimbisa bhizinesi rezvebhizimisi (BI). Iwe uchaona kuti ungagadzira sei dhaka yekuchengetedza dhaka, shandisa zvinyorwa, kuchinja, uye kutakura (ETL) ne SQL Server Integration Services (SSIS), uye kugadzirisa nekuchenesa dambudziko neSQL Server Data Quality Services (DQS) uye SQL Server Master Data Services.

Iyi ndiyo yakagadzirirwa vatengi vanofarira kudzidza SQL Server 2012 kana SQL Server 2014. Inobatanidza zvinhu zvitsva zveSQL Server 2014 pamwe chete nemakosha anokosha kune yese yeSquL Server data platform.

Iyi dzidzo inosanganisira mashoko kubva kuMutemo weMicrosoft Learning Product 20463: Kushandisa Data Warehouse ne Microsoft SQL Server 2014. Inobatanidza unyanzvi uye ruzivo rwakaenzaniswa neChitsuko 70-463 uye pamwe chete nehuwandu-hwemabasa, hukubatsira kugadzirira kuongorora.

Zvinangwa zvekushandisa Dhinda Dare rekuchengetedza ne Microsoft SQL Server 2014 kudzidziswa

  • Dhiyabhorosi yekuchengetedza mazano uye mazano ekugadzira
  • Sarudza iyo yakakodzera yehurongware yechipinda chekuchengetedza deta
  • Kugadzira uye kushandisa dhaka rekushandisa
  • Itai kuti ruzivo rwekuyerera uye kutonga rwubudirire mumutambo weSSIS
  • Kugadzirisa uye kushungurudza SSIS pakatari
  • Itai sarudzo yeSSIS iyo inotsigira kukura kwezvinhu zvekuchengetedza kwedhaka uye kutora deta
  • Shandisai kuchenesa deta uchishandisa Microsoft DQS
  • Kushandisa Master Data Services (MDS) kusimudzira kuderera kwe data
  • Wedzera SSIS netsika zvinyorwa uye zvikamu
  • Shandisa uye gadzirisa maSpisketti eSSIS
  • Maitiro eBusiness Intelligence solutions anotora data mune imwe nzvimbo yekuchengetedza dhaka

Vateereri vateereri veKushandisa Data Dzimba dzekuchengetedza ne Microsoft SQL Server 2014 Course

  • Vashandi vezvenhau vanofanirwa kuzadzisa BI yekugadzirisa chinangwa pamaoko-kubasa, kuumba BI mhinduro dzinosanganisira data yekuchengetedzwa kwekuchengetedza, ETL, uye kucheneswa kwedunhu
  • Dhipatimendi rezvemabhizimisi anoona nezvekushandisa dhipatimendi yekuchengetedza dhaka, kushandura mapurisa eSSSIS ekuwedzerwa kwemashoko, kuendesa, kuendesa, kushandura, uye kushandura kutendeseka kwedata uchishandisa MDS, nekuchenesa dhidhiyo uchishandisa DQS

Zvinotarisirwa Kuita Kushandisa Data Dzimba dzekuchengetedza ne Microsoft SQL Server 2014 Certification

  • Makore maviri emakore ruzivo ruchishanda pamwe neshamwari dzezvekodzero, kusanganisira kugadzira dare re database, kugadzira matafura uye hukama
  • Basic programming constructs, kusanganisira kuvhara uye kubata
  • Taura nezvezvinhu zvinokosha zvebhizimisi, zvakadai sekubhadhara mari, kubatsirwa, uye mari yemari

Nzira Yokubuda Nenguva Inguva: 5 Days

1. Data Dare rekuchengetedza

  • Concepts and Architecture Zvichifunga
  • Kufungidzira kweDhina Dhaka rekuchengetedza Zvigadziriswa Solution

2. Data Dare Rekushandisa Infrastructure

  • Zvisarudzo zveChina
  • Data Warehouse Reference Architectures uye Appliances

3. Kugadzirwa uye Kuita Dhiyabhorosi Gadziriro

  • Logical Design,
  • Physical Implementation

4. Dzai ETL Solution neS SSIS

  • ETL ne SSIS
  • Ongorora Chinyorwa Data
  • Shandisai Dhiririro Rwenyika

5. Ita Kuti Kudzora Kubudirira muSISIS Package

  • Kudzora Kuyerera
  • Gadzira Dynamic Packages
  • Kushandisa Containers
  • Shandisa Kutevedzera

6. Kugadzirisa uye Matambudzikohoot SSIS Packages

  • Dzoka SSIS Package
  • Logisi SSIS Package Zviitiko
  • Tora Zvikanganiso mune SSIS Package

7. Shandisai Kuwedzera kweEt Process

  • Inonakidza ETL

8. Shandisai Data Quality

  • Microsoft SQL Server DQS
  • Shandisa DQS Kuchenesa Data
  • Shandisa DQS Kufananidza Dhina

9. Master Data Services

  • Master Data Services Concepts
  • Shandisai Dhi Data Data Service Model
  • Shandisa Master Data uye Gadzira Master Data Hub

10. Wedzera SQL Server Integration Services (SSIS)

  • Nyaya Zvikwata muSSIS
  • Scripting muSSIS

11. Shandisa uye Gadzirisa SSIS Packages

  • Kufungidzirwa Kutora
  • Shandisa Mirairo yeSSIS
  • Ronga Purogiramu yeSSIS Package

12. Shandisa Data muDhipatimendi Rekuchengetedza

  • Business Intelligence Solutions
  • Kuzivisa uye Kuongorora Data

Ndapota nyorera kwatiri info@itstechschool.com & taura nesu pa + 91-9870480053 pamutengo wematengo & chikwata chemari, purogiramu & nzvimbo

Dhidzai Mhinduro

Kuti uwane mamwe mashoko nemutsa Taura nesu.


Reviews