TypeHo Koetlisa Sekolo
Ngodisa

Contact

Masimo a tšoauoa ka * ho hlokahala

 

Ho kenya ts'ebetsong lebenkele la polokelo ea litaba le Microsoft SQL Server 2014 (M20463)

** Lokolla Lits'obeletso tsa hau tsa Microsoft (SATV) bakeng sa 20463 - Ho kenya ts'ebetso ea polokelo ea boitsebiso ka Microsoft SQL Server 2014 koetliso ea thuto & Certification **

Overview

bamameli ba

Tlhahiso ea Tlhahlobo

Kemiso le Litefiso

tiiseletswe

20463 - Ho kenya ts'ebetso ea polokelo ea boitsebiso ka Microsoft SQL Server 2014 Training

Thutong ena, o tla ithuta ho kenya ts'ebetsong sethaleng sa polokelo ea data ho tšehetsa tharollo ea khoebo (BI). U tla fumana mokhoa oa ho theha polokelo ea polokelo ea data, kenya ts'ebetso, ho fetola le ho laola (ETL) le SQL Server Integration Services (SSIS), le ho netefatsa le ho hloekisa dintlha le SQL Server Data Quality Services (DQS) le SQL Server Master Data Services.

Koetliso ena e etselitsoe bareki ba thahasellang ho ithuta SQL Server 2012 kapa SQL Server 2014. E akaretsa lintlha tse ncha tsa SQL Server 2014 hammoho le tsebo ea bohlokoa ho pholletsa le sethaleng sa data sa SQL Server.

Koetliso ena e kenyelletsa boitsebiso bo tsoang ho XMUMX ea Puo e Fanoang ea Microsoft: Ho kenya ts'ebetso ea polokelo ea boitsebiso ka Microsoft SQL Server 20463. E akaretsa tsebo le tsebo e lekantsoeng ke Exam 2014-70 le hammoho le phihlelo ea mosebetsi, e thusa ho itokisetsa tlhahlobo.

Sepheo sa ho kenya ts'ebetso ea Ditaba Ntlong ea polokelo le mochini oa Microsoft SQL Server 2014

  • Litlhaloso tsa ho boloka matšoao le lisebelisuoa tsa mehaho
  • Khetha sethala se nepahetseng sa thepa bakeng sa polokelo ea data
  • Etsa le ho kenya ts'ebetso ea polokelo ea data
  • Etsa ts'ebetsong ho phalla ha data le ho laola phallo pakeng tsa SSIS
  • Tšoaetsa le ho rarolla liphutheloana tsa SSIS
  • Phethahatsa tharollo ea SSIS e tšehetsang lits'enyehelo tse ngata tsa polokelo ea data le ho ntša dintlha
  • Kenya ts'ebetsong ea ho hloekisa data ho sebelisa Microsoft DQS
  • Tsamaisa Mesebetsi ea Ditshebeletso tsa Master (MDS) ho tiisa botšepehi ba data
  • Eketsa SSIS ka mekhoa e tloaelehileng le likaroloana
  • Sebelisa le ho lokisa liphutheloana tsa SSIS
  • Kamoo tharollo ea Khoebo ea Khoebo e sebelisang data ho boloka boitsebiso ba data

Bamameli ba Motlatsi oa Ho Sebelisa Demo ea Matlotlo le Sesebelisoa sa Microsoft SQL Server 2014

  • Basebetsi ba basebetsi ba hlokang ho phethahatsa karolo ea boipheliso ba BI e tsepamisitsoeng matsoho mosebetsing, ho bopa tharollo ea BI ho kenyelelitsoe ts'ebetsong ea ho boloka matlotlo, ETL, le ho hloekisoa ha data
  • Basebeletsi ba basebetsi ba ikarabellang bakeng sa ho kenya ts'ebetso ea polokelo ea lisebelisoa, ho hlahisa liphutheloana tsa SSIS bakeng sa pokello ea lintlha, ho laela, ho fetisetsa, ho fetola le ho tiisa botšepehi ba data ho sebelisa MDS, le ho hloekisa boitsebiso ba sebelisa DQS

Lintho tse hlokahalang bakeng sa ho kenya ts'ebetso ea Ditaba Ntlong ea polokelo ea thepa ka Microsoft SQL Server 2014

  • Nako e ka tlase lilemo tse peli tse sebetsang le marang-rang a litaba, ho kenyelletsa le ho theha li-database tse tloaelehileng, ho theha litafole le likamano
  • Lenaneo la motheo le haha, ho kenyeletsa ho looping le branching
  • Tsepamisa maikutlo liphuthehong tsa bohlokoa tsa khoebo, tse kang chelete, phaello le akhaonto ea lichelete

Nako ea Nako ea Tlhahlobo: Matsatsi a 5

1. Dintlha tsa ho boloka boitsebiso

  • Likhopolo le Mekhoa ea Boqapi
  • Tlhokomelo bakeng sa Ditaba tsa polokelo ea matlotlo Tharollo

2. Litšebeletso tsa thepa ea ho boloka boitsebiso

  • Khetho ea Sehlooho
  • Ditaba tsa Warehouse Reference Architectures le Appliances

3. Ho theha le ho kenya ts'ebetso ea polokelo ea boitsebiso

  • Tlhaho e utloahalang,
  • Ts'ebetsong ea 'mele

4. Etsa Tharollo ea ETL le SSIS

  • ETL le SSIS
  • Hlahloba Lintlha tsa Mohloli
  • Qetella Phallo ea Ditshebeletso

5. Qetella Phallo ea Taolo ka har'a Phakatsi ea SSIS

  • Phallo ea taolo
  • Etsa liphutheloana tsa Dynamic
  • Ho Sebelisa Li-Containers
  • Laola Boits'oaro

6. Tlhōlisano le Matšoenyeho a li-Package tsa SSIS

  • Tšoaetsa sephutheloana sa SSIS
  • Ingolisa li-SSIS Package Events
  • Tšoara liphoso ka har'a pakete ea SSIS

7. Etsa ts'ebetso ea mokhoa o hlophisitsoeng oa ETL

  • ETL

8. Netefatsa Tlhahiso ea Data

  • Microsoft SQL Server DQS
  • Sebelisa DQS ho Hlalosa Dintlha
  • Sebelisa DQS ho Fumana Mathata

9. Ditshebeletso tsa Ditshebeletso tsa Master

  • Tsebo ea Litšebeletso tsa Ditaba tsa Master
  • Qetella setšoantšo sa Master Data Services
  • Laola Ditaba tsa Mongolo mme o Bopa Master Data Hub

10. Eketsa Lits'ebeletso tsa Kopano ea SQL Server (SSIS)

  • Likarolo tse tloaelehileng tsa SSIS
  • Ho ngolla ka SSIS

11. Sebelisa le ho lokisa liphutheloana tsa SSIS

  • Ho nahanisisa ka ho tsamaisoa
  • Sebelisa merero ea SSIS
  • Etsa tlhahlobo ea Package ea SSIS

12. Sebelisa Dintlha ka Darelete ya Ditaba

  • Business Intelligence Solutions
  • Tlhahlobo ea Litlaleho le Litlaleho

Re kopa o re ngolle info@itstechschool.com & re ikopanye le rona ka + 91-9870480053 bakeng sa theko ea theko le theko ea tiiso, kemiso le sebaka

Re Tlisetsa Potso

Bakeng sa lintlha tse ling ka mosa Iteanye le rona.


Reviews