MOC - 2792: Implementing and Maintaining Microsoft SQL Server 2005 Integration Services
Po odslušanom seminaru polaznik će znati:
- Opisati SQL Server Integration Servise i njihove alate.
- Kreirati Integration Services paket.
- Implementirati kontrolu toka u Integration Services paket.
- Implementirati bilježenje logova u Integration Services paket.
- Debagirati i implementirati error handling u Integration Services paket.
- Implementirati checkpointove i transakcije u Integration Services paket.
- Primjeniti Integration Services paket.
- Upravljati i osigurati Integration Services paket.
Sadržaj seminara:
- Modul 1: Using SQL Server Integration Services
- Modul 2: Implementing an Integration Services Solution
- Modul 3: Implementing Control Flow
- Modul 4: Implementing Data Flows
- Modul 5: Implementing Logging
- Modul 6: Debugging and Error Handling
- Modul 7: Implementing Checkpoints and Transactions
- Modul 8: Deploying Integration Services Packages
- Modul 9: Managing and Securing Packages
Predznanje:
- Iskustvo u radu sa enterprise data import i eksport scenarijima.
- Iskustvo u korištenju Microsoft Windows Server okruženja.
- Iskustvo u radu sa Microsoft SQL Serverom, uključujući: - SQL Server Agent - SQL Server query language (SELECT, UPDATE, INSERT, and DELETE) - SQL Server System tables - SQL Server accounts (korisnici i dozvole)
- Upis u radnu knjižicu: ne
- Certifikat: da
- Uvjerenje: ne
- In-house: ne
- Svjedodžba: ne
- Diploma: ne