HEAD to HEAD:
SQL 2008 vs 2005
Why I NEED TO UPGRADE
3-Day Hands on Workshop
NEW YORK, WALTHAM, TAMPA
This is a special Invitation to an Exclusive Microsoft Event for key Microsoft customers.
Enrollment fee is:
$499 prior to Aug 1 $599 After Aug1
This is a Special 50% Discount for these 3 events.
This class is being presented by Signzilla Tech, A Microsoft Gold Partner.
Class space is limited, these are individualized sessions, designed to answer your specific needs.
Contact info: info@signzillatech.com
Phone: 570-877-8375
LOCATIONS:
New York, NY
Aug 25,26,27
Register Now
Microsoft Corp
1290 Ave of Americas
6th Floor
NY, NY 10104
Waltham, MA
Sep 10,11,12
Register Now
Microsoft Corp
201 Jones Rd
Waltham, MA 02451
Tampa, FL
Sep 22,23,24
Register Now
Microsoft Corp
3000 Bayport Dr
Suite 480
Tampa FL, 33607
Introduction:
This three-day Instructor-Led course provides students with the skills and information to upgrade SQL 2000 & 2005 instances to 2008, Migrate Reporting and Analysis Services Projects, as well as provide information necessary to plan and implement SQL 2008 Databases and BI infrastructures.
Course Completion
After completion students will:
1) Know about all new features contained in SQL 2008
2) Migrate 2005 Databases to 2008
3) Migrate 2000 Databases to 2008
4) Manage SQL 2008
5) Perform Database Optimizations
6) Use Reporting Services
7) Use Analysis Services
8) Migrate 2005 Reporting to 2008
9) Migrate 2005 Analysis Projects to 2008
10) Create and use a Data Warehouse in 2008
11) Use Integration Services in 2008
Prerequisites
Students should have a working knowledge of SQL 2005 and be prepared with questions and concerns about 2008 in their environment.
Covered Topics
Managing SQL Server 2008
Creating a Configuration Server
Creating and Applying a Policy
SQL Server 2008 Performance Enhancements
Managing Workloads with Resource Governor
Monitoring Performance with the Data Collector
Managing Performance with Plan Freezing
Using Resource Governor
Using the Data Collector
SQL Server 2008 Security Enhancements
Encrypting Databases
Auditing All Actions
SQL Server 2008 Database Development Enhancements
Developer Tool Enhancements
Data Type Enhancements
Working with Spatial Data
Developing Databases with SQL Server 2008
Using Date and Time Data Types
Using Spatial Data
SQL Server 2008 Availability Enhancements
Always On Technologies
Transactional Peer-to-Peer Replication
Maintaining High Availability
Configuring Peer-to-Peer Replication
Adding a Replication Node
SQL Server 2008 Data Warehousing Enhancements
ETL Enhancements
Using Partitioned Tables
Optimizing Data Storage
Using Change Data Capture
Using the MERGE Statement
Working with Partitioned Data
SQL Server 2008 Reporting Services Enhancements
Reporting Services Architecture and Management
Authoring Reports
Report Processing and Rendering
Creating a Report with Report Designer
Managing Reporting Services
SQL Server 2008 Analysis Services Enhancements
Multidimensional Analysis with SQL Server Analysis Services
Data Mining with SQL Server Analysis Services
Implementing Multidimensional Analysis
Implementing Data Mining
Schedule:
DAY1 8:15-9:00 Welcome & Breakfast (Provided)
9:00-9:45 Overview and Introduction to SQL 2008
9:45-10:15 OPEN DISCUSSION about Migration and Product Concerns
10:15-10:30 Break
10:30-11:00 Lesson: INSTALLING SQL 2008
11:00-12:00 Instructor-Led LABS
12:00-12:45 LUNCH (Provided)
12:45-1:15 LESSION: Migration Options and Planning
1:15-2:00 Instructor-Led LABS
2:00-2:30 New Features Overview
2:30-2:45 Break Coffee & Cookies
2:45-4:00 Instructor-Led LABS
DAY2
8:30-9:00 Breakfast (provided)
9:00-9:15 Recap & Q & A
9:15-9:45 SSMS Features and Best Practices
9:45-10:15 Instructor-Led LABS
10:15-10:30 SSMS Migration
10:30-10:45 Break
10:45-12:00 Instructor-Led LABS
12:00:12:45 Lunch (Provided)
12:45-1:30 2008 Development Enhancements
1:30-2:30 Instructor-Led LABS
2:30-3:00 2008 Reporting Services
3:00-4:30 Instructor-Led LABS
DAY3
8:30-9:00 Breakfast (provided)
9:00-9:15 Recap & Q & A
9:15-10:00 Data Warehousing 2008
10:00-12:00 Instructor-Led LABS
12:00-12:30 LUNCH (provided)
12:30-1:00 High Availability
1:00-2:00 Instructor-Led LABS
2:00-2:45 2008 Security
2:45-4:00 Instructor-Led LABS