uhloboUqeqesho lweKlasi
INCWADI

Ukuphunyezwa kwe-Data Storage Warehouse nge-Microsoft SQL Server 2014 (M20463)

** Redeem Your Microsoft Vouchers(SATV) for 20463 XCHARX Implementing a Data Warehouse with Microsoft SQL Server 2014 Training course & Certification **

isishwankathelo

Abaphulaphuli

Inkcazo yeNkcazo

IShedyuli kunye neMali

iziQinisekiso

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

Kule khosi, uya kufunda indlela yokuphumeza isicwangciso sokugcina idatha yolwazi ukuxhasa isisombululo se-intelligence (BI). Uya kufumanisa indlela yokwakha igumbi lokugcina idatha, ukuphumeza ukukhipha, ukuguqula, nokulayisha (ETL) kunye neenkonzo ze-Integrated SQL Server (SSIS), kwaye uqinisekise kwaye uhlambulule idatha kunye neNkonzo zeNgcaciso zeDatha yeSQL Server (DQS) kunye neNkonzo zeNgcaciso zeDatha zeSQL Server.

Le khosi yenzelwe amakhasimende anomdla ekufundeni i-SQL Server 2012 okanye i-SQL Server 2014. Ihlanganisa iinkalo ezintsha ze-SQL Server 2014 kwakunye namandla abalulekileyo kwi-platform yolwazi lweSQL Server.

Le khosi ifaka izinto ezivela kwiMicrosoft yaseMicrosoft Learning Product 20463: Ukuphunyezwa kwe-Data Storage Warehouse nge-Microsoft SQL Server 2014. Ihlanganisa izakhono nolwazi olulinganiswe yi-Exam 70-463 kwaye kunye nolwazi lwama-job, lunceda ukulungiselela ukuhlolwa.

Iinjongo zokuphunyezwa kweDatha yoLondolozo lwe-Microsoft SQL Server 2014

  • Iingcamango zolondolozo lweenkcukacha kunye nokuqwalasela izakhiwo
  • Khetha iqonga elifanelekileyo le-hardware yendawo yokugcina idatha
  • Ukuyila nokuzalisekisa indlu yokugcina idatha
  • Qalisa ukuhamba kweedatha nokulawula ukuhamba kwiphakheji ye-SSIS
  • Ukuguqulwa kweengxaki kunye neengxaki ze-SSIS
  • Ukuphumeza isisombululo se-SSIS esisekela ukulandelwa kwempahla yolondolozo lweenkcukacha nokukhupha idatha
  • Phunyezwa ukucoca idatha usebenzisa iMicrosoft DQS
  • Ukuphunyezwa kweeNkonzo zeNgcaciso zeDatha (MDS) ukunyanzelisa intembeko yedatha
  • Ukwandisa i-SSIS kunye neempendulo zenkcubeko kunye nezinto
  • Sebenzisa kwaye ulungiselele iiphakheji ze-SSIS
  • Isisombululo seShishini soBuchule sisebenzisa idatha kwivenkile yokugcina idatha

Abaphulaphuli abafunyenweyo bokuphunyezwa kweDatha yoLondolozo lweMicrosoft ye-Microsoft SQL Server 2014 Course

  • Abaqeqeshi beenkcukacha ezidinga ukuzalisekisa indima yophuhliso lwe-BI egxile kwimisebenzi yezandla, ukudala izisombululo ze-BI kuquka ukuphunyezwa kokugcinwa kwedatha, i-ETL, kunye nokucoca idatha
  • Abachwephesha beenkcukacha ezijongene nokuzaliswa kwempahla yokugcina idatha, ukuphuhlisa amaphakheji e-SSIS ekukhutsheni idatha, ukulayisha, ukudlulisela, ukuguqula nokunyanzelisa ingqibelelo yedatha usebenzisa i-MDS kunye nokucoca idatha ngokusebenzisa i-DQS

Iimfuno zokuQala ukuPhathwa kweeNkcukacha zoLondolozo lweeNkcukacha nge-Microsoft SQL Server 2014 Certification

  • Ubuncinane beeminyaka emibili usebenze kunye nolwazi olunxulumene nolwalamano, kuquka ukuyila i-database eqhelekileyo, ukudala amatafula kunye nolwalamano
  • Iprogram eyisiseko yokwakha, kubandakanywa ukukhwela kunye nokuhlanganiswa
  • Gxininisa kwizinto eziphambili zoshishino, njengengeniso, inzuzo, kunye neengxelo zemali

Ixesha loKhutshwa kweNkundla: Iintsuku ze-5

1. Idata ehlala kuyo

  • Iingcamango nokuCwangcisa
  • Ukuqwalaselwa kweNkcukacha yoLondolozo lweDatha

2. Iinkcukacha zoLondolozo lweZibonelelo

  • Ukhetho lweMpahla
  • Iinkcukacha zoLondolozo lweeNdawo zoLondolozo lweeNdawo kunye neeMpahla

3. Ukuyila nokuSebenza kweeDawulo zoLwazi

  • Uyilo loLwazi,
  • Ukuphunyezwa komzimba

4. Yenza isisombululo se-ETL nge-SSIS

  • ETL nge SSIS
  • Hlola iNkcukacha yedatha
  • Ukuphunyezwa kweMvelaphi yeDatha

5. Ukuphunyezwa koMlambo wokuLawula kwiPakethe ye-SSIS

  • Ulawulo lokuLawula
  • Yakha iiphakheji zeDynamic
  • Ukusebenzisa iiContainers
  • Ukulawula ukuBambisana

6. I-Debug ne-Troubleshoot i-SSIS Packages

  • Ukuguqula iipakethe ze-SSIS
  • Qwalasela Iimpawu zePakethe ze-SSIS
  • UkuPhatha iziPhoso kwiPakethe ye-SSIS

7. Ukuphunyezwa kweNkqubo ye-ETL engekhoyo

  • ETL eyongeziweyo

8. Ukunyanzeliswa koBume beMigangatho

  • Microsoft SQL Server DQS
  • Sebenzisa i-DQS yokuCoca iDatha
  • Sebenzisa i-DQS kwiDatha yeDatha

9. Iinkonzo zeDatha zeMata

  • IiNgcaciso zeeNkcukacha zeeNkcukacha
  • Ukuphunyezwa kweModeli yoLwazi lweeNkcukacha zeData
  • Lawula i-Master Data kwaye Yakha i-Master Data Hub

10. Ukwandisa Iinkonzo Zokuhlanganiswa kweSQL Server (SSIS)

  • Izixhobo eziKhethekileyo kwi-SSIS
  • Iskripthi kwi-SSIS

11. Sebenzisa kwaye ulungiselele iipakethi ze-SSIS

  • Ukuqwalaselwa kweeNkonzo
  • Sebenzisa iiProjekthi ze-SSIS
  • Cwangcisa ukuPhathwa kwePakethe ye-SSIS

12. Sebenzisa iiDatha kwi-Data Storage Warehouse

  • Isisombululo Sobunjineli
  • UkuBaliswa kweNkcazo kunye noLwazi

Nceda ubhalele kuthi info@itstechschool.com Qhagamshelana nathi kwi-91-9870480053 kwixabiso lekhosi kunye neendleko zokuqinisekisa, ishedyuli kunye nendawo

Usilahle Umbuzo

Ukufumana ulwazi olungakumbi Qhagamshelana nathi.


Reviews