Training Course: Microsoft SQL Server 2005 for Experienced DBAs (7033, MOC 7033)

Training Course Summary:

The purpose of this 4-day instructor-led course is to teach Oracle DBAs how to leverage their skills and experience as an Oracle DBA to manage a SQL Server system. This course provides a quick start for the Oracle DBA to map, compare and contrast the realm of Oracle database management to SQL Server database management..

Pre-Requisites:

Before attending this course, students must:

• Have thorough experience with SQL Server 2000

• Have experience with SQL Server 2005 and a comprehensive understanding of all the new features and technologies

• The relational engine

• Storage engine

• Integration Services

• Analysis Services

• Reporting Services

• Be familiar with SQL Server 2005 features, tools, and technologies.

Who Should Attend:

This course is intended for experienced database professionals currently implementing and administering non Microsoft enterprise database management systems who need to expand their database skill-set to SQL Server 2005.

Training Course Overview/Content:

Module 1: Database and Instance

In this module we will provide terminologies with proper definitions to unambiguously identify the various components of a database management system.

Lessons

• Concept of Database and Instance

• Client interaction with Database and Instance

• Database limits


After completing this lab, you will be able to clearly define database and instances, discuss the components of a database and an instance, examine the relationship between a database and an instance and understand client interaction between a database and an instance

Module 2: Database Architecture

This module examines the SQL Server 2005 database architecture.

Lessons

• Schema and schema objects

• Storage Architecture

• Logging Model

• Data Dictionary


Lab

After completing this module, you will be able to:

• Understand schema and schema objects

• Identify logical and physical structures using storage organization

• Explain the architecture of data storage components and their hierarchy and relationships

• Management of storage structures

• Understand how to build the database using files and tablespaces

• Comprehend the transaction logging model employed to perform transaction recovery and rollback

• Distinguish major differences between the construction of the data dictionary in Oracle and SQL Server


Module 3: Instance Architecture

This module describes the instance architecture, and explains how the two main components of an instance, the memory and processes, are leveraged to achieve "high performance" in large multi-user environment.

Lessons

• Memory Architecture - Overview

• Process and Thread-based Architecture

• Oracle Client-Database Interaction

• SQL Server 2005 Client-Database Interaction

• Oracle background processes

• SQL Server background processes


Lab

After completing this module, you will be able to:

• Configure a database server

• Understand the Memory Address Space of a database server

• Identify key database memory structures

• Identify memory areas inside Oracle SGA and their SQL Server equivalents

• Process and thread-based architecture relevant to RDBMS

• Detail client interaction with database server

• Understand database server processes/threat and the work performed


Module 4: Data Objects

This module discusses the objects in the database that are used to organize and store the content that most concerns the user; the business data.

Lessons

• Schema Objects - Table

• Schema Objects - Table

• Clustered Index

• Constraints

• Triggers

• Indexes

• Views

• Character-Based Data Types

• Numeric Data Types

• Binary Data Types

• Object Data Storage


Lab

After completing this module, you will be able to understand:

• The organization of data in tables and the various forms of data

• The supporting schema objects

• Types of data that can be stored in tables

• Organization and presentation of data in complex real-world forms

• Storage organization of the schema objects


Module 5: Data Access

This module explains how data access works and the many components required to access the data from an application.

Lessons

• Relational engine

• Structured Query Language

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Control Statements

• Procedural SQL

• Cursors

• Error Handling

• Query Optimization

• Transaction Management


Lab

After completing this module, you will be able to:

• Identify the components of the relational engine and their roles in processing SQL

• Understand the basic concepts of Structured Query Language

• Define procedural SQL constructs and their mechanisms

• Identify query optimization by the relational engine and user overrides

• Understand Transaction Management


Module 6: Data Protection

This module examines in detail the data protection mechanisms in SQL Server 2005.

L