1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2008 Skills Upgrade: Hands-On

Updating Your SQL Server 2005 Skills to 2008
 
Course: 136   Type: Hands-On Training   Duration: 3 Days
 
 

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

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

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

Related Courses

 
SQL Server 2008 is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Dec 10 - 12, 2008
 Washington, DC (Rockville, MD)
Jan 7 - 9, 2009
 Washington, DC (Alexandria, VA)
Jan 28 - 30, 2009
 Washington, DC (Reston, VA)
Feb 18 - 20, 2009
 New York
Feb 25 - 27, 2009
 Chicago (Schaumburg)
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)
Jul 22 - 24, 2009
 Washington, DC (Alexandria, VA)

For complete schedule, please visit www.learningtree.com
 
http://www.lerningtree.com/courses/136pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2008 Skills Upgrade: Hands-On

Updating Your SQL Server 2005 Skills to 2008
 
Course: 136   Type: Hands-On Training   Duration: 3 Days
 
 
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 existing 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
 
http://www.lerningtree.com/courses/136pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2008 Skills Upgrade: Hands-On Tuition

Updating Your SQL Server 2005 Skills to 2008
 
Course: 136   Type: Hands-On Training   Duration: 3 Days
 
 

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

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.lerningtree.com/courses/136pf.htm