70-445: Microsoft SQL Server 2005 Business Intelligence - Development and Maintenance: 70-445 (eLearning Basis)

Elearning training (basis pakket) inclusief oefenvragen, virtual oefenomgeving en toegang tot het digitale leerplein. Je kan op ieder gewenst moment starten. De getoonde startdatum is - ivm met opsturen van materiaal - 7 dagen na vandaag. De IT training Microsoft SQL Server 2005 Business Intelligence implementatie en het onderhoud Certification Training Course leert cursisten hoe ze een Analysis Services oplossing in een organisatie moeten ontwikkelen, implementeren en beheren. Hoe ze de Integration Services pakketten en de Reporting Services development tools moeten gebruiken om rapporten te maken en de Reporting Services-beheer inclusief de administratieve instrumenten te gebruiken om daarmee een Reporting Services-oplossing te beheren.

70-445: Microsoft SQL Server 2005 Business Intelligence - Development and Maintenance: 70-445 (eLearning Basis)

Doelgroep

Dit IT training is bedoeld voor IT professionals die expert willen worden in het implementeren en onderhouden van Business Intelligence oplossingen met behulp van de Microsoft SQL Server 2005 Business Intelligence tool suite.

Vereiste voorkennis (incl. eventueel voorafgaande training)

Deelnemers dienen over de volgende kennis en ervaring te beschikken:

• Kennis van database schema's, zowel relationele als multidimensionale• Ervaring met en / of kennis van de implementatie van een kubus in SQL Server Analysis Services (SSAS)
• Ervaring met en / of kennis van SSAS data mining algoritmen
• Ervaring met het maken en implementeren van SQL Server Reporting Services (SSRS) rapportages
• Ervaring met authoring en implementeren van SQL Server Integration Services (SSIS) pakketten
• Ervaring met het werken met Microsoft. NET Framework

Deze training bestaat uit de volgende onderdelen

• het officiële eLearning Basis cursusmateriaal (wordt opgestuurd voor aanvang van de training)
• toegang tot het eigen IT-University digitale leerplein Athena
• toegang tot de eigen IT-University virtuele labomgeving (waarmee buiten de training  kan worden geoefend)
• docentenbegeleiding via chat/email
• kennis assessment en oefenexamen
• studiebegeleiding door je eCoach
• deelnamecertificaat 

Examen

Deze training is ter voorbereiding op de volgende examens: 70-445

Certificering

Deze training maakt onderdeel uit van het(de) navolgende certificeringstraject(en):

MCITP SQL Server 2005 Business Intelligence Developer MCTS SQL Server 2005 Business Intelligence

Cursusduur

Omdat het zelfstudie betreft bepaal je de cursusduur zelf.

Prijs

€ 650 per cursus/per cursist (Ken je ook de andere leervormen van deze training? Bekijk ze via de Adviestool)

Leervorm

Deze eLearning Basis leervorm betreft zelfstudie waarbij je zelf kan bepalen Wat, Waar, Wanneer en Hoe snel je wil leren. Vooral geschikt voor mensen die in eigen tempo alleen dat deel willen leren wat ze nodig hebben op de momenten dat het past. Dit vraagt wel enige zelfdiscipline. Dit eLearning Basis pakket verschilt van het eLearning Plus pakket in de video-instructie, welke wel in het Plus pakket zit en niet in het Basispakket. Het Basispakket bevat de standaard eLearning. Alle IT eLearning wordt gevolgd vanuit het digitale leerplein Athena. Hierin zit veel extra functionaliteit zoals virtual labomgeving, kennis assessment, oefenexamens, de eCoach, contact met een docent (24x7), forum met medecursisten, enz. Kortom; veel begeleiding om van je IT eLearning een succes te maken.

Module 1 - Course 2791

Course Overview
Introduction to SQL Server 2005 Analysis Services
Overview of Data Analysis Solutions
Overview of SQL Server 2005 Analysis Services
Installing SQL Server 2005 Analysis Services
Summary
Review Quiz
Creating Multidimensional Analysis Solutions
Developing Analysis Services Solutions
Creating a Data Source and a Data Source View
Creating a Cube
Summary
Create a Data Source
Create and Modify a Data Source View
Create and Modify a Cube
Review Quiz
Working with Dimensions
Configuring Dimensions
Defining Hierarchies
Sorting and Grouping Attributes
Summary
Configure Dimensions
Define Relationships and Hierarchies
Sort and Group Dimension Attributes
Review Quiz
Working with Measures and Measure Groups
Working with Measures
Working with Measure Groups
Summary
Configure Measures
Define Dimension Usage and Relationships
Configure Measure Group Storage
Review Quiz
Querying Multidimensional Analysis Solutions
MDX Fundamentals
Adding Calculations to a Cube
Summary
Query a Cube by Using MDX
Create a Calculated Member
Define a Named Set
Review Quiz
Customizing Cube Functionality
Implementing Key Performance Indicators
Implementing Actions
Implementing Perspectives
Implementing Translations
Summary
Implement a KPI
Implement an Action
Implement a Perspective
Implement a Translation
Review Quiz
Deploying and Securing an Analysis Services Database
Deploying an Analysis Services Database
Securing an Analysis Services Database
Summary
Deploy an Analysis Services Database
Secure an Analysis Services Database
Review Quiz
Maintaining a Multidimensional Solution
Configuring Processing Settings
Logging, Monitoring, and Optimizing an Analysis Services Solution
Backing Up and Restoring an Analysis Services Database
Summary
Implement Logging and Monitoring
Back Up and Restore a Database
Review Quiz
Introduction to Data Mining
Overview of Data Mining
Creating a Data Mining Solution
Validating Data Mining Models
Course Summary
Create a Data Mining Structure
Add a Data Mining Model
Explore Data Mining Models
Review Quiz

Module 2 - Course 2792

Course Overview
Introduction to SQL Server 2005 Integration Services
Overview of Integration Services Solutions
Integration Service Tools
Summary
Use the Import and Export Wizard
Run an Integration Services Package
Review Quiz
Developing Integration Services Solutions
Creating an Integration Services Solution
Using Variables
Building and Running a Solution
Summary
Create an Integration Services Project
Implement a Package
Build and Run an Integration Services Project
Review Quiz
Implementing Control Flow
Control Flow Tasks
Control Flow Precedence Constraints
COntrol Flow Containers
Summary
Create a Simple Control Flow
Configure Precedence Constraints
Use Containers
Review Quiz
Implementing Data Flow
Data Flow Sources and Destinations
Data Flow Transformations
Data Flow Paths
Summary
Transfer Data
Implement Transformations
Use Data Viewers
Configure Error Output
Review Quiz
Implementing Logging
Overview of Integration Services Logging
Implementing Logging
Summary
Configure Logging
Implement Custom Logging
Review Quiz
Debugging and Error Handling
Debugging a Package
Implementing Error Handling
Summary
Debug a Package
Review Quiz
Implementing Checkpoints and Transactions
Implementing Checkpoints
Implementing Transactions
Summary
Implement Checkpoints in a Package
Implement Transactions in a Package
Implement a Native Transaction
Review Quiz
Deploying Packages
Package Configurations
Deploying Packages
Summary
Create a Package Configuration
Prepare a Package for Deployment
Deploy a Package
Review Quiz
Managing and Securing Packages
Managing Packages
Securing Package
Course Summary
Import a Package
Configure and Execute a Package
Schedule a Package
Secure a Package
Review Quiz

Module 3 - Course 2793

Course Overview
Introduction to SQL Server Reporting Services
Overview of SQL Server Reporting Services
Installing Reporting Services
Reporting Services Tools
Summary
Explore Report Designer
Explore Report Manager
Review Quiz
Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Summary
Create a Basic Table Report
Format Report Pages
Add Calculated Values
Review Quiz
Enhancing Basic Reports
Interactive Navigation
Displaying Data
Summary
Use Dynamic Visibility
Use Document Maps
Initiate Actions
Use a List Data Region
Review Quiz
Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Summary
Restrict Query Results
Filter Report Data
Review Quiz
Using Report Models
Creating Report Models
Using Report Builder
Summary
Create a Report Model
Use Report Builder
Review Quiz
Publishing and Executing Reports
Publishing Reports
Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Summary
Publish Reports
Execute a Report On Demand
Configure and View a Cached Report
Configure and View Snapshot Report
Review Quiz
Using Subscriptions to Distribute Reports
Introduction to Report Subscriptions
Creating Report Subscriptions
Managing Report Subscriptions
Summary
Create a Standard Subscription
Create a Data-Driven Subscription
Review Quiz
Administering Reporting Services
Server Administration
Performance and Reliability Monitoring
Administering Report Server Databases
Security Administration
Summary
Use Configuration Manager
Secure a Report Services Site
Secure Items
Review Quiz
Programming Reporting Services
Querying for Server Information Using a Web Service
Automating Report Management
Rendering Reports
Creating Custom Code
Course Summary
Use URL Access to Display a Report
Build a Web Service Client
Use the Report Viewer Control
Review Quiz