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

SQL Server 2008 New Features: Hands-On

 
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
  • Monitor and log data changes for auditing compliance
  • Enhance security and high availability through improved encryption and mirroring
  • Improve query performance with plan guides and extended event capabilities
  • Integrate new components of Business Intelligence (BI) for better reporting and analysis

Course Benefits
In order to properly evaluate and prepare for SQL Server 2008, experience with the cutting edge capabilities of this version is critical. This course provides hands-on experience with the latest features that enable you to extend your administration and development skillset. You leverage SQL Server 2008 in order to transform databases beyond the relational model and gain business advantage.

Who Should Attend
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
  • Pinpointing performance bottlenecks with extended events
  • Setting up CDC with Management Studio
  • Restoring an encrypted database to a different instance of SQL Server
  • Configuring mirroring with log stream compression

Course 136 Content
Introducing SQL Server 2008 New Features
  • Exploring new and enhanced components
  • 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 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
  • Configuring the Internal Full Text Search (IFTS)
  • 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
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
  • Detecting compliance issues in Management Studio
Proactively Monitoring Data
Recording modifications
  • Configuring Change Tracking
  • Logging primary keys for rows that have changed
Auditing with Change Data Capture (CDC)
  • Enabling CDC for history logging
  • Tracking Data Manipulation Language (DML) statements
Data Protection and High Availability
Securing your data through encryption
  • Transparent Data Encryption (TDE)
  • Storing keys externally
  • Restoring encrypted data
Employing replication enhancements
  • Managing efficiently with Replication Monitor
  • Joining to an exisiting Peer-to-Peer transactional replication
Enhancing database mirroring
  • Recovering damaged or corrupted data with automatic page repair
  • Improving performance with log stream compression
Simplifying clustering setup
  • Addressing hardware compatibility changes
  • Streamlining cluster configuration
Boosting SQL Server Performance
Optimizing query execution
  • Attaching query hints with the plan guide
  • Taking advantage of the query plan freeze
Collecting performance data
  • 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
Integrating BI Enhancements
SQL Server Analysis Services (SSAS)
  • Creating multidimensional data with Cube Designer
  • Improving business insight with Data Mining
SQL Server Reporting Services (SSRS)
  • Presenting intelligent data reports with Tablix
  • Eliminating the need for IIS
  • Rendering reports to Microsoft Word
SQL Server Integration Services (SSIS)
  • Building an ADO.NET source or destination
  • Integrating SSIS with merge
  • Incorporating C# into the script task
  • Handling advanced data types in the SQL Server Import and Export Wizard

Related Courses

SQL Server is a trademark of Sybase, Inc.
  
 
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 as much as $2,350 on a Triple-Pack!

SQL Server  2008 New Features: Hands-On
Upcoming Dates
Oct 22 - 24, 2008
 Washington, DC (Reston, VA)
Nov 12 - 14, 2008
 New York
Nov 19 - 21, 2008
 Chicago (Schaumburg)
Dec 10 - 12, 2008
 Ottawa
Dec 10 - 12, 2008
 Washington, DC (Rockville, MD)
Dec 17 - 19, 2008
 Los Angeles
Jan 7 - 9, 2009
 Toronto
Jan 7 - 9, 2009
 Washington, DC (Alexandria, VA)
Jan 28 - 30, 2009
 Washington, DC (Reston, VA)
Feb 18 - 20, 2009
 New York

SQL Server  2008 New Features: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,250 Standard Tuition
Tuition with a Savings Plan
$ 1,245 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,025 Alumni Gold Discount
$ 2,000 Government Discount
 

 

SQL Server  2008 New Features: Hands-On
SQL Server  2008 New Features: Hands-On
Participants enforcing policy compliance with DMF.


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