Kurser

5 dages kursus 
Læring inden for et specifikt emne

SQL Server Integration Services [55321]

24. maj til 9. juni 2023 Taastrup
6. - 22. september 2023 Aarhus
23. oktober til 10. november 2023 Taastrup
DKK  21.499
ekskl. moms
Nr. 91210 A
Tilmeld dig

Lær hvordan du kan anvende Microsoft SQL Server Integration Service (SSIS) til at opbygge, udrulle, vedligeholde og sikre Integration Services-projekter og -pakker og hvordan du udvikler ETL-løsninger til at udtrække, transformere og indlæse data til og fra SQL Server.

Dette kursus afløser Microsofts kursus 20767 Implementing a SQL Data Warehouse, men fokuserer mere på at opbygge pakker snarere end hele Datawarehouse design og implementering.

Deltagerprofil

Dette kursus er for dig, der arbejder med Business Intelligence på SQL Server og ønsker viden om BI-løsninger, Data Warehouse implementering, ETL-løsninger og rensning af data.

Forudsætninger

Du forventes at have et godt praktisk kendskab til at arbejde med relationelle databaser og T-SQL, og det er en fordel også at have grundlæggende kendskab til database design.

Udbytte

  • Oprette sofistikerede SSIS-pakker til udtrækning, transformation og indlæsning af data
  • Bruge containers til effektivt at styre gentagne opgaver og transaktioner
  • Konfigurere pakker til dynamisk tilpasning ændringer
  • Bruge Data Quality Services til at rense data
  • Fejlfinding
  • Oprette og administrere SSIS
  • Udrulle, konfigurere og planlægge pakker
  • Sikkerhed på SSIS

Det får du på kurset

Vi sørger for at rammerne er i orden, så du kan fokusere på at lære

Efter du har fuldendt kurset, vil du modtage et kursusbevis.

Kursusbevis

Hos Teknologisk Institut bruger vi kun erfarne undervisere.

Erfaren underviser

På kurset får du morgenmad, frokost, snacks og drikkevarer.

Fuld forplejning

På kurset er der indtænkt øvelser og deltagerinddragelse.

Øvelser og inddragelse

Materiale på engelsk

Materiale på engelsk

Undervisning på dansk

Undervisning på dansk

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

    - Import/Export Wizard
    - Exporting Data with the Wizard
    - Common Import Concerns
    - Quality Checking Imported/Exported Data
Module 2: Working with Solutions and Projects
  • In this module, students learn to work with SQL Server Data Tools (SSDT) to design and deploy reports.

    - Working with SQL Server Data Tools
    - Understanding Solutions and Projects
    - Working with the Visual Studio Interface
Module 3: Basic Control Flow
  • The Control Flow tab of the SSIS Designer is used to organize the general flow of your package execution. The control flow of a package includes different element types, such as tasks, containers, and precedence constraints. Each of these element types has a set of properties that you will use to define and manage individual instances of these elements. In this module, students learn to add containers or tasks from the SSIS Toolbox to the Control Flow Designer.

    - Working with Tasks
    - Understanding Precedence Constraints
    - Annotating Packages
    - Grouping Tasks
    - Package and Task Properties
    - Connection Managers
    - Favorite Tasks
Module 4: Common Tasks
  • Microsoft has organized the tasks in the Common section of the SSIS Toolbox alphabetically. This module will touch on the functionality of each of these tasks, and provide Try It exercises for the tasks that are most commonly seen in classes and companies.

    - 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
Module 5: Data Flow Sources and Destinations
  • In this module, students will learn to work with data flow sources and destinations.

    - The Data Flow Task
    - The Data Flow SSIS Toolbox
    - Working with Data Sources
    - SSIS Data Sources
    - Working with Data Destinations
    - SSIS Data Destinations
Module 6: Data Flow Transformations
  • In this module, students learn about transformations, which allow you to modify data in the data flow pipeline.

    - Transformations
    - Configuring Transformations
Module 7: Making Packages Dynamic
  • In this module, students will learn to make SSIS packages dynamic.

    - 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
Module 8: Containers
  • In this module, students learn to use containers, which provide a way to organize tasks that need to be managed together as a group.

    - Sequence Containers
    - For Loop Containers
    - Foreach Loop Containers
Module 9: Troubleshooting and Package Reliability
  • This module puts together common troubleshooting methods along with some of the reliability features for SSIS all in one place.

    - Understanding MaximumErrorCount
    - Breakpoints
    - Redirecting Error Rows
    - Logging
    - Event Handlers
    - Using Checkpoints
    - Transactions
Module 10: Deploying to the SSIS Catalog
  • The project deployment model provides the framework for new functionality such as the SSIS catalog, environments, project level parameters and project level connection managers. This module explains how to deploy projects to the SSIS catalog.

    - The SSIS Catalog
    - Deploying Projects
    - Working with Environments
    - Executing Packages in SSMS
    - Executing Packages from the Command Line
    - Deployment Model Differences
Module 11: Installing and Administering SSIS
  • In this module, students will learn to install, upgrade, and administer SSIS.

    - Installing SSIS
    - Upgrading SSIS
    - Managing the SSIS Catalog
    - Viewing Built-in SSIS Reports
    - Managing SSIS Logging and Operation Histories
    - Automating Package Execution
Module 12: Securing the SSIS Catalog
  • In addition to the standard SQL Server database and instance permissions that can be configured like any other database, the SSIS catalog has special pre-defined database roles and additional permissions that can be assigned for the management and execution of SSIS packages. In this module, students learn to work with roles and permissions to secure the SSIS catalog.

    - Principals
    - Securables
    - Grantable Permissions
    - Granting Permissions
    - Configuring Proxy Accounts
 
25656
Underviser

Teknologisk Institut benytter erfarne undervisere fra er bredt netværk af dygtige specialister.

Vælg dato

Taastrup
24. maj til 9. juni 2023
Aarhus
6. - 22. september 2023
Taastrup
23. oktober til 10. november 2023
Billede der illustrerer kurset

Firmakurser - få et tilbud

Er i flere, der har samme behov for kompetenceudvikling, så er et firmakursus ofte den rette løsning, der kan skabe fælles fundament og økonomisk besparelse.