SQL Server Integration Services (55321)

ONZE LESMETHODE: ACTIVE LEARNING

Bij Active Learning word je gecoacht bij het ontwikkelen van vaardigheden die voor jou persoonlijk cruciaal zijn. De methode sluit goed aan bij hoe mensen leren, en houdt rekening met wat jij al weet en kunt. Als je erover nadenkt, is het zo logisch als wat.

Je maakt samen met je trainer een plan en gaat actief aan de slag. In een kleine klas verdiepen in wat je echt nodig hebt, inzoomen op zaken die je echt interesseren en overslaan wat je al weet of niet nodig hebt. Plan je lesdagen flexibel, neem real-life casussen mee en werk ze uit met je trainer. Verrijk je kennis en verbind het met alles wat je al wist.

OMSCHRIJVING TRAINING

Volg de MS55321 SQL Server Integration Services Training bij Master IT en leer SSIS te gebruiken. Deze training is bedoeld voor IT-professionals die willen leren hoe ze SSIS kunnen gebruiken om Integration Services-projecten en -pakketten te bouwen, implementeren, onderhouden en beveiligen

Deze training vervangt de MS20767 Implementing a SQL Data Warehouse training.

Na afronding van deze training kun je onder andere:

– Geavanceerde SSIS-pakketten voor het extraheren, transformeren en laden van gegevens maken
– Containers gebruiken om repetitieve taken en transacties efficiënt te beheren
– De SSIS-catalogus maken, beheren en beveiligen

This five-day instructor-led course is intended for IT professionals who need to learn how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages, and to use SSIS to extract, transform, and load data to and from SQL Server.This course is similar to the retired Course MS20767-C: Implementing a SQL Data Warehouse but focuses more on building packages, rather than the entire data warehouse design and implementation. At Course Completion

  • Create sophisticated SSIS packages for extracting, transforming, and loading data
  • Use containers to efficiently control repetitive tasks and transactions
  • Configure packages to dynamically adapt to environment changes
  • Use Data Quality Services to cleanse data
  • Successfully troubleshoot packages
  • Create and Manage the SSIS Catalog
  • Deploy, configure, and schedule packages
  • Secure the SSIS Catalog

Voorkennis

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of relational databases.
  • Some experience with database design.

VOOR WIE.

The primary audience for this course is database professionals who need to fulfil a Business Intelligence Developer role. They will need to focus on hands-on work creating BI solutions including Data Warehouse implementation, ETL, and data cleansing.

ONDERDELEN VAN DE TRAINING.

Module 1: SSIS OverviewThis module explains the purpose of SSIS and teaches how to use the Import/Export Wizard to exchange data between data structures.Lessons

  • Import/Export Wizard
  • Exporting Data with the Wizard
  • Common Import Concerns
  • Quality Checking Imported/Exported Data

Lab: Use the Import/Export Wizard from SSMSModule 2: Working with Solutions and ProjectsLessons

  • Working with SQL Server Data Tools
  • Understanding Solutions and Projects
  • Working with the Visual Studio Interface

Lab:

  • Import and run a package in SSDT-BI

Module 3: Basic Control FlowLessons

  • Working with Tasks
  • Understanding Precedence Constraints
  • Annotating Packages
  • Grouping Tasks
  • Package and Task Properties
  • Connection Managers
  • Favorite Tasks

Lab:

  • Precedence Constraints and Execute SQL Task

Module 4: Common TasksLessons

  • Analysis Services Processing
  • Data Profiling Task
  • Execute Package Task
  • Execute Process Task
  • Expression Task
  • File System Task
  • FTP Task
  • Hadoop Task
  • Script Task Introduction
  • Send Mail Task
  • Web Service Task
  • XML Task

Labs:

  • Create a package to copy a file and send an email message on completion
  • Create a package to perform data profiling and then review the results
  • Create a master package and test the execution flow of the child packages

Module 5: Data Flow Sources and DestinationsLessons

  • The Data Flow Task
  • The Data Flow SSIS Toolbox
  • Working with Data Sources
  • SSIS Data Sources
  • Working with Data Destinations
  • SSIS Data Destinations

Lab: Working with Data Sources and DestinationsModule 6: Data Flow TransformationsLessons

  • Transformations
  • Configuring Transformations

Lab:

  • Working with Derived Column Transformations
  • Working with Lookup Transformations
  • Module 7: Making Packages Dynamic

After completing this module, students will be able to:

  • Working with Derived Column Transformations
  • Working with Lookup Transformations

Module 7: Making Packages DynamicLessons

  • Features for Making Packages Dynamic
  • Package Parameters
  • Project Parameters
  • Variables
  • SQL Parameters
  • Expressions in Tasks
  • Expressions in Connection Managers
  • After Deployment
  • How It All Fits Together

Lab: Making a Package DynamicModule 8: ContainersLessons

  • Sequence Containers
  • For Loop Containers
  • Foreach Loop Containers

Lab: Use a Foreach Loop container to send a custom email to the names found in a database viewModule 9: Troubleshooting and Package ReliabilityLessons

  • Understanding MaximumErrorCount
  • Breakpoints
  • Redirecting Error Rows
  • Logging
  • Event Handlers
  • Using Checkpoints
  • Transactions

Labs:

  • Creating a Script Task to Merge Error Messages
  • Configure a package to use transactions

Module 10: Deploying to the SSIS CatalogLessons

  • The SSIS Catalog
  • Deploying Projects
  • Working with Environments
  • Executing Packages in SSMS
  • Executing Packages from the Command Line
  • Deployment Model Differences

Labs:

  • Deploying a Project to the SSIS Catalog
  • Manually executing a Package

Module 11: Installing and Administering SSISLessons

  • Installing SSIS
  • Upgrading SSIS
  • Managing the SSIS Catalog
  • Viewing Built-in SSIS Reports
  • Managing SSIS Logging and Operation Histories
  • Automating Package Execution

Lab: Automating Package ExecutionModule 12: Installing, Upgrading, and Migrating to Windows 7Lessons

  • Principals
  • Securables
  • Grantable Permissions
  • Granting Permissions
  • Configuring Proxy Accounts

Lab: Securing the SSIS Catalog

 

in samenwerking met

PRAKTISCHE INFORMATIE

MAESTRO PRIJS

€2.495,-

PARTNER PRIJS

€ 2.395,-

CURSUS

Active Learning

AANTAL DAGEN

5 dagen (flexibel in te plannen)

TIJD

incl studiemateriaal, certificaat, koffie/thee en een uitgebreide lunch.

Datum optie 1 01 December 2024 Locatie: Capelle a/d IJssel (kies zelf 5 dagen) Datum optie 2 01 December 2024 Locatie: Eindhoven (kies zelf 5 dagen) Datum optie 3 01 December 2024 Locatie: Vianen (kies zelf 5 dagen) Datum optie 4 01 December 2024 Locatie: Virtueel (kies zelf 5 dagen)

DIRECT AANMELDEN

Aanmelden voor SQL Server Integration Services (55321)

VOORWAARDEN

  • Partners van de Maestro Academy: Specialisten aangesloten bij Het Finance Gilde, Data2Succes, Change Management Community Nederland of HeadFirst(Premium overeenkomst);
  • De betaling dient vóór aanvang van de eerste trainingsdag volledig te zijn voldaan

Alle bovengenoemde prijzen zijn exclusief BTW;