home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - OS/390 - z/OS » UNIX - Linux - AIX » Windows » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
Updating your SQL Server 2005 skills to SQL Server 2008

Intended for

This course is intended for experienced SQL Server 2005 developers and database administrators who want to upgrade their skills to SQL Server 2008.

Background

Before attending this course, students must have experience developing or administering SQL Server 2005 databases.

Training method

Classical training with practice exercices.

Course leader

RealDolmen.

Duration

3 days.

Schedule

No public sessions are currently scheduled. We will be pleased to set up an on-site course or to schedule an extra public session (in case of a sufficient number of candidates). Interested ? Please contact ABIS.

Objectives

After completing this course, students will be able to describe SQL 2008 Server enhancements .

Main topics

  • Introduction to SQL Server 2008
  • The evolution of SQL Server
  • Preparing for SQL Server 2008
  • Managing SQL Server 2008
  • Configuration server
  • Declarative Management Framework: policies.
  • Performance enhancements
  • Resource governor
  • Management data warehouse: data collection
  • Plan freezing.
  • Securing a SQL Server 2008 database
  • Transparent data encryption.
  • SQL Server 2008 database development enhancements
  • Developer tools enhancements
  • Data type enhancements
  • Spatial data.
  • SQL Server 2008 availability enhancements
  • Always on technologies
  • Transactional peer-to-peer replication.
  • SQL Server 2008 data warehousing enhancements
  • Change data capture
  • Merge statement
  • Working with partitioned data.
  • SQL Server 2008 Reporting Services enhancements
  • Architecture and management
  • Authoring reports
  • Report processing and rendering.
  • SQL Server Analysis Services enhancements
  • Multidimensional analysis
  • Data mining.