1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2008 Skills Upgrade: Hands-On

Updating Your SQL Server 2005 Skills to 2008

 
Course: 136     Type: Hands-On Training     Duration: 3 Days

Quick Enroll    

You Will Learn How To
  • Leverage new SQL Server 2008 features and tools to support database administration and development
  • Simplify server-side programming with new Transact-SQL commands
  • Enforce standards to ensure compliance with policy-based management
  • Monitor and log data changes for auditing compliance
  • Enhance security and high availability through improved encryption and replication
  • Improve query performance with plan guides and extended event capabilities

Course Benefits
SQL Server 2008 offers cutting edge capabilities for database administration. This skills upgrade course provides hands-on experience with the new features of SQL Server 2008, including improvements to querying, searching, synchronizing, reporting and analyzing functionality. Throughout this course, you learn to translate the strengths of SQL Server 2008 into improvements in your organization's data processes.

Who Should Attend
Many of the new features of SQL Server 2008 focus on management improvements. Experienced SQL Server 2005 administrators and developers considering or currently migrating to SQL Server 2008.

Hands-On Training
Throughout this course, extensive hands-on exercises provide experience with SQL Server 2008 new features. Practical exercises include:
  • Upgrading from SQL Server 2005 to SQL Server 2008
  • Handling date and time values with new datatypes
  • Saving storage with backup compression
  • Querying Geo-Spatial data to plot demographics
  • Setting up CDC with Transact-SQL
  • Restoring an encrypted database to a different instance of SQL Server
  • Establish a Peer-to-Peer replication topology

Course 136 Content
Introducing SQL Server 2008 New Features
  • Exploring new and enhanced administration and development features
  • Upgrading from SQL Server 2005
  • SQL Server Management Studio
  • Coding with Intellisense
Easing Development with Transact-SQL
Working with new data types and statements
  • Date
  • Time
  • DateTimeOffset
  • DateTime2
  • SparseColumn
  • HierarchyID
  • Grouping data by grouping sets
  • Combining insert and update with merge
Manipulating Geo-Spatial data
  • Storing and retrieving geographic information
  • Querying data with Spatial Index
Extending beyond relational data
  • Import and export external data with Integration Services
  • Enabling the storage and access of binary files with Filestream
Improving Data Management
Scrutinizing internal information with Dynamic Management Views (DMVs)
  • Analyzing DMVs for memory usage
  • Verifying dependencies among objects
Performance and scalability enhancements
  • Expanding system hardware with Hot Add CPU and memory
  • Compressing backup files on the fly
Allocating processor time and memory
  • Specifying resource limits
  • Prioritizing workloads with Resource Governor
Policy-Based Management Framework
Establishing policy-based management
  • Defining guidelines for SQL Server instances
  • Reducing TCO by simplifying administrative tasks
Enforcing policy compliance
  • Creating policies, conditions and facets
  • Applying policies to SQL Servers
  • Detecting compliance issues with alerts and notifications
  • Subscribing to policies
Proactively Monitoring Data
Recording modifications
  • Configuring Change Tracking
  • Logging primary keys for rows that have changed
  • Administering performance implications
  • Applying CHANGETABLE function
Auditing with Change Data Capture (CDC)
  • Enabling CDC for history logging
  • Tracking Data Manipulation Language (DML) and Data Definition Language (DDL) statements
Securing Your Data Through Encryption
Managing Transparent Data Encryption (TDE)
  • Creating the database encryption key
  • Demystifying encryption key hierarchy
  • Comparing cell-level encryption to TDE
Extensible key management
  • Storing keys externally
  • Restoring encrypted data
  • Querying and managing encryption key data
Enabling High Availability
Employing replication enhancements
  • Managing efficiently with Replication Monitor
  • Joining to an existing Peer-to-Peer transactional replication
  • Detecting and handling data conflicts
Enhancing database mirroring
  • Recovering damaged or corrupted data with automatic page repair
  • Improving performance with log stream compression
Boosting SQL Server Performance
Optimizing query execution
  • Investigating execution plans
  • Taking advantage of the query plan freeze
Collecting performance data
  • Creating the MDW database
  • Establishing the data collector
  • Analyzing data capture from queries
  • Reporting on performance bottlenecks
Monitoring with the extended events engine
  • Handling events uniformly across SQL Server
  • Dynamically inspecting active processes

Related Courses
SQL Server 2008 is a registered trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 45% per course on the standard tuition!

SQL Server 2008 Skills Upgrade: Hands-On
Upcoming Dates
Feb 18 - 20, 2009
 New York
Mar 18 - 20, 2009
 Washington, DC (Rockville, MD)
Apr 1 - 3, 2009
 Ottawa
Apr 8 - 10, 2009
 Los Angeles
Apr 15 - 17, 2009
 Washington, DC (Alexandria, VA)
May 6 - 8, 2009
 Washington, DC (Reston, VA)
May 20 - 22, 2009
 Toronto
May 27 - 29, 2009
 New York
Jun 3 - 5, 2009
 Chicago (Schaumburg)
Jun 24 - 26, 2009
 Washington, DC (Rockville, MD)

SQL Server 2008 Skills Upgrade: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,390 Standard Tuition
Tuition with a Savings Plan
$ 1,350 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,155 Alumni Gold Discount
$ 2,124 Government Discount
 

 

SQL Server 2008 Skills Upgrade: Hands-On
SQL Server 2008 Skills Upgrade: Hands-On
Participants enforcing policy compliance with DMF.


CPE 17 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733