Expert Gym - SQL Server Upgrade Centre Workshop

Expert Gym is back!

You are invited to join our Expert Gym 2007 Series,

SQL Server Upgrade Centre Workshop

Session Details
What: Two-day workshop

When: April,   3-4 ( Silahkan datang langsung ke tempat acaranya)
     April 25-26
     9 AM – 4 PM

Where: Microsoft Indonesia, PT
      Jakarta Stock Exchange Building, 18th Floor, Tower 2
      Jl.Jend.Sudirman Kav.52-53 Jakarta 12190 Indonesia

Who: Developer, System Engineer, Infrastructure Architect

Cost: Free of Charge

Registration Process: Email to events@corporate.ms.

Syllabus:

1. Relational Engine Lab 1:
Performing an In-Place Upgrade of a SQL Server 2000 Relational Database Environment

   * Exercise 1: Executing Upgrade Advisor
   * Exercise 2: Fixing Upgrade Issues
   * Exercise 3: Performing Pre-Upgrade Tasks
   * Exercise 4: Performing the Version Upgrade

2. Relational Engine Lab 2:
Performing a Side-by-Side Upgrade of a SQL Server 2000 Relational Database Environment

Lab 2A: Upgrading a Relational Database by Using the Backup/Restore Method

   * Exercise 1: Backing Up the Source Database and Reviewing Instance-Level Objects
   * Exercise 2: Restoring and Upgrading the Database

Lab 2B: Upgrading a Relational Database by Using the Copy Database Wizard

   * Exercise 1: Using the Copy Database Wizard
   * Exercise 2: Reviewing the Copy Database Wizard Package

3. Relational Engine Lab 3:
Upgrading a Clustered SQL Server 2000 Environment by Using the Detach and Attach Method

   * Exercise 1: Reviewing the Server Environment
   * Exercise 2: Upgrading a Clustered SQL Server 2000 Database by Using the Detach and Attach Method
   * Exercise 3: Performing Post-Installation Tasks

4. Introduction to SQL Server Management Studio

   * Exercise 1: Exploring the Environment
   * Exercise 2:Attaching a Database
   * Exercise 3:Exploring an Existing Database
   * Exercise 4:Creating a new database
   * Exercise 5:Setting up Database Access

5. T-SQL Enhancements

   * Exercise 1:PIVOT and UNPIVOT Operators
   * Exercise 2:Common Table Expressions and Recursive Queries
   * Exercise 3:DDL Triggers and EventData()
   * Exercise 4:Event Handling

6. Data Mining

   * Exercise 1: Creating Decision Tree and Naïve Bayes Data Mining Models
   * Exercise 2 Viewing Mining Accuracy Charts
   * Exercise 3 Creating a Prediction Query

7. SQL Query Tuning

   * Exercise 1: Troubleshooting Deadlocks with SQL Profiler
   * Exercise 2: Isolating a Slow Running Query Using SQL Profiler
   * Exercise 3: Examining an Execution Plan
   * Exercise 4: Using the Database Tuning Advisor

8. Table and Index Partitioning Exercises

   * Understanding Partitioned Tables Using a Date Range    
   * Understanding the concepts – Range Partition Function  
   * Understanding the concepts – Partition Scheme 
   * Understanding the concepts – Partitioned Table  
   * Understanding the concepts – The Sliding Window Scenario
   * Additional Partitioning Resources

Value to You:

SQL Server Upgrade Centre will provide you
a step-by-step guidance to upgrade SQL Server 7.0/2000 to SQL Server 2005
to ensure the success of SQL Server 2005 implementation

We are looking forward to meeting you.