0 Items | 0.00
Go

Carefully read through the detailed training information and select the appropriate IT training for you!

Contact one of our training consultants in case you need assistance.


LinkedIn

What's New in SQL 2008R2

Course Code: GKSQL08R2
Day(s): 1
Price: €99.00 (ex. VAT)

Overview 

This 2-hour breakfast session instructed by our MCT SQL Professional Marc Mertens highlights the following new topics in SQL R2:

  • Mastering Data Services
  • Mulit-Server Application Management
  • Data-Tier Applications
  • Enhancements in Reporting Services

Pre-Requisites
Users completing this collection should have a basic understanding of SQL Server and relational database systems. It is also desirable to have an understanding of dimensions in analytic models.

Next Course Dates

Dates available on request. Please contact us






    More Information

    This session is intended for SQL users confident working SQL 2008 but also gives a nice insight for SQL 2005 or SQL 2000 users of what SQL2008 is able to do.

    • Explain the importance of and value provided by master data management and the features provided by Microsoft SQL Server Master Data Services.
    • Explain the core concepts in designing master data management solutions.
    • Describe the process involved in implementing a solution using Microsoft SQL Server Master Data Services.
    • Introducing Application and Multi-server Management
    • Working with data-tier applicationsManaging change in data-tier applications.
    • Managing data-tier applications.
    • Create a Utility Control Point.
    • Enroll managed instances.
    • Create data-tier applications.
    • Deploy and manage data tier applications
    • Learn Reporting Services enhancements.

    Master Data Services

    Master Data Services helps enterprises standardize the data people rely on to make critical business decisions. With Master Data Services, IT organizations can centrally manage critical data assets companywide and across diverse systems, enable more people to securely manage master data directly, and ensure the integrity of information over time

    Multi-Server Administration and Data-Tier Application

    o Sql Server Utility

    • Provides administrators with a holistic view of SQL Server resource health

    o Data-tier applications

    • A new single unit of deployment, Data-tier Application, packages database schema (database, tables, stored procedures, etc) with deployment requirements and can be extracted from existing applications or created in Microsoft Visual Studio®—accelerating deployments and upgrades

    Enhancements in Reporting Services

    • Report Parts
    • Shared Datasets
    • Cache Refresh Plans
    • Sparklines and Data Bars
    • Indicators
    • Map Layer
    • Calculating Aggregates of Aggregates

    There is no certification linked to this course.

    M6231 - Maintaining a SQL Server 2008 Database

    M6232 - Implementing a SQL Server 2008 Database

    GK7004 - Business Intelligence with SQL Server 2008

    M6234 - Implement & Maintain SQL Server 2008 - Analysis Services

    M6235 - Implement & Maintain SQL Server 2008 - Integration

    M6236 - Implement & Maintain SQL Server 2008 - Reporting


    In This Section

    Hot Specials are back!

    Get a 20% discount on a selection of trainings in May and June! 

    Learn more
    spotlightbottom

    Training Information

    Contact our experts
     +32 (0) 800 84 009

    spotlightbottom


    Copyright © 2012 Global Knowledge Belgium BVBA, registration number 0879.699.532 - VAT number BE 0879.699.532 – Tel +32 (0) 800/84.009
    RSS. (Srv: 220)