Wednesday, July 30, 2008

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
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

 
doggy steps
doggy steps