UhloboUkuqeqesha ekilasini
BHALISA

Ukusebenzisa i-Data Storage Warehouse nge-Microsoft SQL Server 2014 (M20463)

** Sebenzisa Microsoft lakho Izaphulelo (SATV) ngoba 20463 - Ukwethulwa kohlelo Data Warehouse Microsoft SQL Server 2014 Training Yiqiniso nesitiketi **

Uhlolojikelele

Izilaleli

Uhlaka Lokufunda

Uhlelo noHlelo

Certification

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

Kule nkambo, uzofunda ukuthi ungayisebenzisa kanjani isiteji sedatha yokugcina idatha ukusekela isisombululo sebhizinisi le-intelligence (BI). Uzothola ukuthi ungakha kanjani indawo yokugcina idatha, usebenzise ukukhipha, ukuguqula, nokulayisha (ETL) nge-SQL Server Integration Services (I-SSIS), futhi uqinisekise futhi uhlanze idatha nge-SQL Server Data Quality Services (DQS) kanye ne-SQL Server Master Data Data.

Le nkambo yenzelwe amakhasimende anentshisekelo ekufundeni i-SQL Server 2012 noma i-SQL Server 2014. Ihlanganisa izici ezintsha ze-SQL Server 2014 kanye namakhono abalulekile kuwo wonke amapulatifomu wedatha ye-SQL Server.

Leli klasi lihlanganisa izinto ezivela ku-Microsoft Official Product Training 20463: Ukusebenzisa i-Data Warehouse nge-Microsoft SQL Server 2014. Ihlanganisa amakhono nolwazi olulinganiselwe yi-Exam 70-463 kanye nokuhlangenwe nakho okusemsebenzini, kukusiza ukulungiselela ukuhlolwa.

Objectives of Implementing a Data Warehouse with Microsoft SQL Server 2014 training

  • Idatha yokugcinwa kwedatha nokucabangela
  • Khetha ispredishithi efanele yehadiwe yendawo yokugcina idatha
  • Yakha futhi usebenzise indawo yokugcina idatha
  • Qalisa ukugeleza kwedatha nokulawula kokugeleza kwiphakheji le-SSIS
  • Dedula bese uphazamisa amaphakheji we-SSIS
  • Phakamisa isisombululo se-SSIS esisekela imithwalo yokugcina idatha yedatha nokukhipha idatha
  • Qalisa ukuhlanzwa kwedatha usebenzisa i-Microsoft DQS
  • Qalisa ukusebenza koMnyango weDatha (MDS) ukuphoqelela ukuthembeka kwedatha
  • Nweba i-SSIS ngezikripthi zenkambiso nezingxenye
  • Sebenzisa futhi ulungise amaphakheji we-SSIS
  • Indlela izixazululo ze-Business Intelligence zisebenzisa idatha kudatha lokugcina idatha

Intended Audience of Implementing a Data Warehouse with Microsoft SQL Server 2014 Course

  • Abasebenzi be-database abadinga ukufeza indima ye-BI yonjiniyela egxile emsebenzini wokusebenza, ukudala izixazululo ze-BI kufaka phakathi ukuqaliswa kokugcinwa kwedatha, i-ETL, nokuhlanzwa kwedatha
  • Abasebenzi be-database abanesibopho sokusebenzisa indawo yokugcina idatha, ukuthuthukisa amaphakheji e-SSIS wedatha yedatha, ukulayisha, ukudlulisa, ukuguqula, nokuqinisa ubuqotho bemininingwane besebenzisa i-MDS, nokuhlanza idatha usebenzisa i-DQS

Prerequisites for Implementing a Data Warehouse with Microsoft SQL Server 2014 Certification

  • Isikhathi esincane seminyaka emibili esisebenza ngokuxhumana nolwazi oluhlobene, kufaka phakathi ukuklama idatha ejwayelekile, ukudala amatafula nobuhlobo
  • Uhlelo oluyisisekelo lwakhiwa, kufaka phakathi ukukhishwa nokuhlanganisa
  • Gxila ezintweni ezibalulekile zebhizinisi, njengenzuzo, inzuzo, kanye ne-akhawunti yezimali

Course Outline Duration: 5 Days

I-1. Idatha yokulondoloza

  • Ukucabangela imiqondo kanye nezakhiwo
  • Ukucatshangelwa kweso Sokugcina Indawo Yokugcina Imininingwane

I-2. Isikhungo Sengqalasizinda Yedatha

  • Izinketho zekhwalithi
  • I-Data Warehouse Reference Architectures nama-Appliances

I-3. Yakha futhi Yenza Inqolobane Yedatha

  • Design Design,
  • Ukusetjenziswa komzimba

I-4. Yakha isisombululo se-ETL nge-SSIS

  • I-ETL ene-SSIS
  • Hlola idatha yomthombo
  • Qalisa ukugeleza kwedatha

I-5. Qalisa ukugeleza kokulawula kuphakheji le-SSIS

  • Ukugeleza kokulawula
  • Dala amaphakheji weDynamic
  • Ukusebenzisa iziqukathi
  • Phatha ukuvumelana

I-6. Ukuguqulwa nokuxazulula izinkinga ze-SSIS Amaphakheji

  • Dedula iphakethe le-SSIS
  • Faka imicimbi ye-SSIS yephakheji
  • Phatha Iziphambeko kuPhakheji le-SSIS

I-7. Ukuqalisa uhlelo lokunciphisa lwe-ETL

  • I-ETL engathanga

I-8. Qinisekisa izinga lemininingwane

  • I-Microsoft SQL Server DQS
  • Sebenzisa i-DQS yokuhlanza idatha
  • Sebenzisa i-DQS kumininingwane yokufanisa

I-9. Amasevisi weDatha yedatha

  • I-Master Data Services Services
  • Phumelela Isibonelo Sesevisi Yedatha Yedatha
  • Phatha i-Master Data bese udala i-Master Data Hub

I-10. Nweba amasevisi wokuhlanganiswa kwe-SQL Server (SSIS)

  • Ama-Components ngokwezifiso ku-SSIS
  • Iskripthi ku-SSIS

I-11. Sebenzisa futhi ulungiselele amaphakheji we-SSIS

  • Ukucatshangelwa kokuthunyelwa
  • Sebenzisa izinhlelo ze-SSIS
  • Hlela ukufakwa kwephakheji le-SSIS

I-12. Sebenzisa idatha ku-Warehouse Data

  • Izixazululo ze-Business Intelligence
  • Ukubika kanye nokuhlaziywa kwedatha

Sicela ubhalele kithi info@itstechschool.com & xhumana nathi ku-91-9870480053 ngezindleko zemali & isitifikedi, isimiso & indawo

Siphonsa Umbuzo

Ukuze uthole olunye ulwazi ngomusa Xhumana nathi.


Izibuyekezo