Invitation to SQL 2008 Microsoft Event

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
6^th 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