Ịmepụta ụlọ ọrụ data na Microsoft SQL Server 2014 (M20463)

** Na-agbapụta Ụgwọ Microsoft Gị (SATV) maka 20463 - Na-emepụta Ụlọ Ahịa Data na Microsoft SQL Server 2014 Training Course & Certification **

Overview

Ndị na-ege ntị

Ihe ndepụta

Nhazi & Ụgwọ

Asambodo

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

Na nke a, ị ga-amụta otú ị ga-esi mepụta usoro nkwakọba ihe data iji kwado ngwọta azụmahịa (BI). Ị ga-achọpụta otú ịmepụta data nkwakọba ihe, mejuputa wepụ, mgbanwe, na ibu (ETL) na SQL Server Integration Ọrụ (SSIS), ma kwenye ma wepu data site na SQL Server Data Quality Services (DQS) na SQL Server Master Data Data.

A haziri usoro a maka ndị ahịa nwere mmasị ịmụta SQL Server 2012 ma ọ bụ SQL Server 2014. Ọ na-ekpuchi atụmatụ ọhụrụ nke SQL Server 2014 nakwa dị ka ihe dị mkpa gafee n'ozuzu data SQL Server.

Usoro a na-agụnye ihe ọmụma si na Nchịkọta Ihe Ọmụma Microsoft Microsoft 20463: Na-emepụta Ụlọ Ahịa Data na Microsoft SQL Server 2014. Ọ na-ekpuchi nkà na ihe ọmụma nke nyochare 70-463 na yana ahụmahụ na-arụ ọrụ, na-enyere gị aka ịkwadebe maka ule.

Ebumnuche nke Ịmepụta Ụlọ Ahịa Data na nkwekọrịta Microsoft SQL Server 2014

  • Echere ụlọ nkwakọba data na atụmatụ ụlọ
  • Họrọ ngwaike ngwanrọ kwesịrị ekwesị maka ụlọ nkwakọba data
  • Chepụta na mejuputa data nchekwa
  • Gbanwee usoro data na nchịkwa na nhazi SSIS
  • Debug na troubleshoot SSIS nchịkọta
  • Na-eme ihe SSIS ngwọta nke na-akwado ụtụ isi ụlọ nkwakọba ihe na iwepụta data
  • Mee nchacha data site na iji Microsoft DQS
  • Debe Ọrụ Ntanetị Nna-ukwu (MDS) iji mezuo iguzosi ike data
  • Gbasa SSIS na ederede na components
  • Debe ma hazie SSIS nchịkọta
  • Olee otú Business Intelligence ngwọta na-eri data na data nkwakọba

Ejiri na-ege ntị na ịmepụta Ụlọ Ahịa Data na Microsoft SQL Server 2014 Agụmakwụkwọ

  • Ndị ọkachamara na-ahụ maka data bụ ndị dị mkpa iji mezuo ọrụ mmepụta BI na-elekwasị anya na-arụ ọrụ, na-emepụta BI ngwọta gụnyere data nkwakọba ihe mmejuputa iwu, ETL, na nchacha data
  • Ndị ọkachamara n'inwe ego maka imejuputa data ụlọ nkwakọba ihe, ịmepụta SSIS nchịkọta maka data mmịpụta, ntinye, ịnyefe, gbanwee, na ịme ka iguzosi ike n'ezi ihe site na MDS, na imecha data site na iji DQS

Ihe ndị dị mkpa maka ịmepụta ụlọ ọrụ data na Microsoft SQL Server 2014 Asambodo

  • Obere afọ abụọ na-arụ ọrụ na ọdụ data, gụnyere ịmepụta nchekwa data, ịmepụta tebụl na mmekọrịta
  • Nhazi usoro mmemme, gụnyere looping na branching
  • Lekwasị anya n'ichepụta ihe ndị dị mkpa, dịka ego ntinye ego, uru, na akaụntụ ego

Oge Nhazi Oge: 5 Days

1. Data Warehousing

  • Atụmatụ na Atụmatụ
  • Atụmatụ maka Ngwọta Ụlọ Ahịa Data

2. Ụlọ Ọrụ Ụlọ Ahịa Data

  • Nhọrọ Akụrụngwa
  • Ụlọ ọrụ Nkọwapụta Ngwaahịa na Ngwaọrụ

3. Wepụta ma mejuputa Ụlọ Ahịa Data

  • Echiche ezi uche,
  • Mmezi ahụ

4. Mepụta ihe ETL Ngwọta na SSIS

  • ETL na SSIS
  • Nyochaa Data Iyi
  • Na-eme ngwa ngwa data

5. Mee Mmetụta Na-arụ na SSIS ngwugwu

  • Ọgba ọsọ
  • Mepụta nchịkọta di omimi
  • Iji ndenye
  • Jikwaa Njikwa

6. Debug na Troubleshoot SSIS nchịkọta

  • Debug SSIS ngwugwu
  • Ihe nchịkọta SSIS ngwugwu
  • Mezie Njehie na SSIS ngwugwu

7. Mee Mmemme ETL usoro

  • Enwekwu akwụkwọ ETL

8. Mee ka ogo data dị

  • DQS Microsoft SQL Server
  • Jiri DQS iji mee ka Data dị ọcha
  • Jiri DQS iji nweta data data

9. Ọrụ Nchịkọta Ihe Nlekọta

  • Atụmatụ Ọrụ Data Nchịkwa
  • Mee ihe ngosi nke ọrụ data ntanetị
  • Jikwaa Ozizi Nzuzi ma mepụta Ndapụta Data Data

10. Gbasa SQL Server Integration Ọrụ (SSIS)

  • Ihe ndị omenala na SSIS
  • Ihe ederede na SSIS

11. Jikwaa ma hazi SSIS nchịkọta

  • Atụmatụ nke atụmatụ
  • Jiri ihe SSIS rụọ
  • Mee nhazi SSIS ngwugwu ngwugwu

12. Data nchekwa na Ụlọ Ahịa Data

  • Business Intelligence Ngwọta
  • Ịkọ akụkọ na nyocha data

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

Wepụ Anyị Ajụjụ

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


Nyocha