Schedules:

There are currently no scheduled classes for this course.

 
  SQL Server Database Administration for the Oracle DBA
 

4-Day (SQ-DBAORCL-401-EN)

Description
Audience
Prerequisites
Course Objectives
Course Outline

Description

This 4 day course is designed for Oracle database administrators who have found themselves faced with the advanced administration of a SQL Server database. This course prepares individuals who are familiar with databases with the skills they need to understand the tasks that must be performed to maintain and administrate larger and more complex Microsoft SQL Server 2008 databases.

Audience

This course is intended for:

  • Experienced Oracle Database Administrators

Prerequisites

This course requires that students meet the following prerequisites:

  • Experience with and understanding of database concepts
  • Experience with the topics covered in Microsoft course 50068A: Microsoft SQL Server 2008 for the Experienced Oracle Database Administration
  • Experience with Oracle database administration

Course Objectives

This course has been designed with the objective of providing the advanced knowledge needed to install, maintain, and administrate a complex and larger SQL Server 2008 database. The course attendees will not only learn the topic listed in the course outline, they have the opportunity to learn SQL Server administrative best practices and tips/tricks from some of the most experienced SQL Server database administrators in the world.
After completion of this course, the course attendee will be able to:

  • Extend their advanced knowledge of Oracle database administration to SQL Server.
  • Manage larger and complex SQL Server database environments from the perspective of an Oracle DBA.
  • Understanding the underlying architecture of SQL Server 2008.
  • Be able to understand how to monitor and tune a SQL Server 2008 installation.
  • Understand how to migrate Oracle schemas and concepts to SQL Server 2008.

Course Outline

Module 1: Introduction to SQL Server Components

This module will provide the course attendees with the understanding of SQL Server and the components that can be installed with each SQL Server installation.  This module is intended to familiarize each course attendee with the components that make up the standard SQL Server environment. The module will cover the following topics:

  • Introduction to the Database Engine
  • Introduction to SQL Server Integration Services (SSIS)
  • Introduction to Reporting Services
  • Introduction to Analytical Services
  • Introduction to Service Broker
  • SQL Server Tools

Module 2:  Installing SQL Server

This module will provide the course attendees with the understanding of installing and configuring SQL Server 2005 and SQL Server 2008.  During this module, the course attendee will lean advanced techniques needed to install a non-standard SQL Server installation. The module will cover the following topics:

  • Understanding service accounts
  • Understanding authentication methods
  • Understanding file locations
  • Understanding default paths
  • Understanding files
  • Understanding database options
  • Understanding recovery model
  • Understanding collations
  • Understanding SQL Server Instances

Module 3:  Understanding the SQL Server Agent

This module will provide the course attendees with the understanding of how to configure SQL Server jobs using the SQL Server Agent.  Course attendees will learn how to use the SQL Server Agent to execute jobs and maintain their SQL Server installation. The module will cover the following topics:

  • Creating and scheduling jobs
  • Disabling and enabling jobs
  • Changing job step order
  • Logging Job Execution
  • Reviewing Job history

Module 4:  Understanding Error Monitoring

This module will provide the course attendees with the understanding of SQL Server error monitoring.  The course attendees will learn how to monitor SQL Server for errors and troubleshooting information. The module will cover the following topics:

  • Reviewing error logs
  • Reviewing agent error logs
  • Reviewing event logs
  • Advanced SQL Server Monitoring with DMVs
  • Extended Events

Module 5:  Understanding Database Layouts

This module will provide the course attendees with the understanding of how to design the database layout. The course attendee will learn how to utilize files/filegroups and partition their data for ease of maintenance and performance. The module will cover the following topics:

  • Understanding files and file groups
  • Data Partitioning

Module 11:  SQL Server Backups and Restores

This module will provide the course attendees with the understanding of how to perform SQL Server backups and restores.  . The course attendee will learn how to create a backup and restore strategy for larger and more complex database environments. The module will cover the following topics:

  • Backing Up SQL Server
    • Creating full backups
    • Creating differential backups
    • Creating transaction log backups
    • Creating compressed backups
    • Creating File and filegroup backups
    • Verifying backups
  • Restoring SQL Server
    • Performing full restores
    • Performing differential restores
    • Performing transaction log restores
    • Verifying restore

Module 12:  Database Maintenance

This module will provide the course attendees with the understanding of SQL Server maintenance and maintenance plans. The course attendee will learn how to meet the maintenance needs of their SQL Server database environments. The module will cover the following topics:

  • Creating maintenance plans
  • Altering maintenance plans
  • Viewing maintenance plan history
  • DBCC Checks

Module 13:  Policy Management

This module will provide the course attendees with the understanding of using the SQL Server 2008’s Policy Management component. The course attendee will learn how to use Policy Based Management to manage multi-server environments. The module will cover the following topics:

  • Creating a policy
  • Verifying policies
  • Scheduling a policy compliance check
  • Enforcing a policy
  • Creating a condition

Module 14: Understanding Table Indexes

This module will provide the course attendees with the understanding of how table indexes work and the different types of indexes available in SQL Server 2005 and SQL Server 2008.  The course attendee will learn how to create indexes to help the performance of their data access while learning how to maintain those indexes. The module will cover the following topics:

  • Understanding clustered and non-clustered indexes
  • Understanding XML indexes
  • Creating indexes
  • Altering indexes
  • Dropping indexes
  • Disabling and enabling indexes
  • Indexes with included columns
  • Creating filtered indexes
  • Rebuilding/reorganizing indexes
  • Online/offline index operations
  • Unique Indexes

Module 17:  Using CLR Objects

This module will provide the course attendees with the understanding of CLR objects and how to implement them.  The course attendee will learn the basics of SQL CLR and how it can be used in a SQL Server database environment. The module will cover the following topics:

  • Creating CLR objects
  • Permission sets (SAFE, UNSAFE, EXTERNAL_ACCESS)

Module 18:  Understanding SQL Server Concurrency

This module will provide the course attendees with the understanding of locking, blocking, and deadlocking in a SQL Server database. The course attendee will learn how to minimize and control locking in a SQL Server database. The module will cover the following topics:

  • Locking
  • Blocking
  • Deadlocking
  • Snapshot Isolation

Module 19:  Introduction to Replication

This module will provide the course attendees with the understanding of the different types of SQL Server replication and how to implement basic replication.  The course attendee will learn how replication can be used in SQL Server for data movement and high availability. The module will cover the following topics:

  • Introduction to Snapshot Replication
  • Introduction to Transactional Replication
    • Updating Subscribers
    • Peer-To-Peer
  • Introduction to Merge Replication

Module 20:  Introduction to Database Snapshots

This module will provide the course attendees with the understanding of database snapshots and how to use database snapshots.  The course attendee will learn how database snapshots can be used in SQL Server for data maintenance and high availability. The module will cover the following topics:

  • Creating database snapshots
  • Reverting from database snapshots
  • Dropping database snapshots

Module 21:  Introduction to Log Shipping

This module will provide the course attendees with the understanding of how to implement log shopping in a SQL Server environment. The course attendee will learn how log shipping can be used in SQL Server for high availability and disaster recovery.  The module will cover the following topics:

  • Setting up log shipping

Module 22:  Introduction to Database Mirroring

This module will provide the course attendees with the understanding of how to set up and maintain SQL Server database mirroring.  The course attendee will learn how database mirroring can be used in SQL Server for high availability. The module will cover the following topics:

  • Setting up database mirroring