TypeKuphunzira Maphunziro
Register

Kugwiritsa ntchito Galama Yopangitsira Deta ndi Microsoft SQL Server 2014 (M20463)

** Pulumutsani Zopereka Zanu za Microsoft (SATV) za 20463 - Kugwiritsa ntchito Chipinda Chosungira Deta ndi Microsoft SQL Server 2014 Kuphunzitsa ndi Certification **

mwachidule

Omvera

Zolembera Mwachidule

Ndandanda ndi Malipiro

chitsimikizo

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

Phunziro lino, mudzaphunzira momwe mungagwiritsire ntchito ndondomeko yosungiramo deta kuti mupeze chithandizo cha bizinesi (BI). Mudzapeza momwe mungapangire zipinda zosungiramo deta, pitirizani kutulutsa, kusintha, ndi kutumiza (ETL) ndi SQL Server Integration Services (SSIS), ndi kutsimikizira ndi kuyeretsa deta ndi SQL Server Data Quality Services (DQS) ndi SQL Server Master Data Services.

Maphunzirowa apangidwa kwa makasitomala omwe akufuna kuphunzira SQL Server 2012 kapena SQL Server 2014. Ikugwira ntchito zatsopano za SQL Server 2014 komanso zofunikira zofunika pa nsanja ya data ya SQL Server.

Komitiyi imaphatikizapo mfundo zochokera ku Microsoft Yovomerezeka Yophunzirira 20463: Kugwiritsa Ntchito Chida Chosungiramo Deta ndi Microsoft SQL Server 2014. Imaphatikizapo luso ndi chidziwitso chomwe chinayesedwa ndi Exam 70-463 komanso pulogalamu ya ntchito, imakuthandizani kukonzekera mayeso.

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

  • Mfundo zogulitsa zinthu ndi zojambula
  • Sankhani sewero loyenerera la zipangizo za galimoto
  • Pangani ndikugwiritsanso ntchito yosungirako deta
  • Gwiritsani ntchito kayendedwe ka deta ndi kuyendetsa mu phukusi la SSIS
  • Sungani ndi kusokoneza phukusi la SSIS
  • Tsatirani njira yothetsera SSIS yomwe imathandiza katundu wambiri wosungiramo zinthu komanso kuchotsa deta
  • Gwiritsani ntchito kuyeretsa deta pogwiritsa ntchito Microsoft DQS
  • Gwiritsani ntchito Master Data Services (MDS) kuti mugwirizanitse chikhulupiliro cha data
  • Wonjezerani SSIS ndi malemba ndi zigawo zikuluzikulu
  • Sungani ndi kukonza mapepala a SSIS
  • Momwe njira zogwirira ntchito zamalonda zimagwiritsira ntchito deta m'nyumba yosungiramo deta

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

  • Olemba akatswiri ogwira ntchito zapamwamba omwe akufunikira kukwaniritsa udindo wa BI wogwira ntchito pa manja, kupanga BI njira zowonjezeramo kuphatikizapo kusungidwa kwapadera, ETL, ndi kuyeretsa deta
  • Olemba akatswiri ogwira ntchito zapamwamba ogwira ntchito yosungiramo deta, akukonza mapepala a SSIS kuti adziwe deta, kukweza, kutumiza, kusintha, ndi kuyesetsa kusunga deta pogwiritsa ntchito MDS, ndi kuyeretsa deta pogwiritsa ntchito DQS

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

  • Zopitirira zaka ziwiri zakubadwa ndikugwira ntchito ndi mafotokozedwe oyanjana, kuphatikizapo kupanga kanema kaundula, kupanga magome ndi maubwenzi
  • Mapulogalamu oyambirira amamanga, kuphatikizapo kutseka ndi nthambi
  • Ganizirani za zofunika pazinthu zamalonda, monga ndalama, phindu, ndi ndalama za akaunti

Course Outline Duration: 5 Days

1. Kusungirako Deta

  • Malingaliro ndi Zomangamanga Zoganizira
  • Zomwe Zili M'njira Yopangiramo Zopezera Zopangidwira

2. Zosungiramo Zomwe Zipangizo Zogwirira Ntchito

  • Zosankha Zamagetsi
  • Maofesi a Zosungiramo Zosungiramo Zopangitsira Deta ndi Zomangamanga

3. Kupanga ndi Kukhazikitsa Zopinda Zopezeka

  • Kulinganiza kwabwino,
  • Kugwiritsa Ntchito Mwathupi

4. Pangani yankho la ETL ndi SSIS

  • ETL ndi SSIS
  • Fufuzani Chiyambi Cha Data
  • Tsatirani Chidwi Chakuyenda

5. Tsatirani Kuyenda Kudutsa mu Phukusi la SSIS

  • Kuthamanga Kudutsa
  • Pangani Packages Dynamic
  • Kugwiritsa Ntchito Zida
  • Sungani Kusagwirizana

6. Kuthetsa ndi Kuthetsa Ma Packages a SSIS

  • Chotsani Phukusi la SSIS
  • Lowani Zochitika Zakale za SSIS
  • Sungani Zolakwitsa mu Phukusi la SSIS

7. Tsatirani Njira Yowonjezera ya ETL

  • Kuchulukitsa ETL

8. Limbikitsani Chikhalidwe cha Data

  • Microsoft SQL Server DQS
  • Gwiritsani ntchito DQS Kuyeretsa Deta
  • Gwiritsani ntchito DQS kuti mufanane

9. Master Data Services

  • Master Data Services Concepts
  • Pangani chitsanzo cha Master Data Services
  • Sinthani Master Data ndipo Pangani Master Data Hub

10. Wonjezerani Mapulogalamu Ophatikizidwa a SQL Server (SSIS)

  • Zogwirizana Zachikhalidwe mu SSIS
  • Kulemba pa SSIS

11. Sungani ndi kukonza Package za SSIS

  • Maganizo Okhudza Kutumizidwa
  • Ikani Ntchito Zogwira SSIS
  • Sungani Kupanga Package kwa SSIS

12. Sungani Zambiri mu Zindikizo Zopezeka

  • Business Intelligence Solutions
  • Kufotokozera ndi Kusanthula Data

Chonde lembani kwa ife info@kambikathakalkochupusthakam.com & tilankhulani nafe ku 91-9870480053 pa mtengo wamtengo wapatali & ndondomeko mtengo, ndondomeko & malo

Tisiyeni Funso

Kuti mudziwe zambiri, mverani mwachifundo Lumikizanani nafe.


Reviews