50068 Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator

Overview

This course provides students with the knowledge and skills to capitalize on their skills and experience as an Oracle DBA to manage a Microsoft SQL Server system.

Objectives

After completing this course, students will be able to:
  • Extend their existing competencies as Oracle DBAs to SQL Server.
  • Manage SQL Server using the same perspective of an Oracle DBA.
  • Understand the underlying architecture of SQL Server.
  • Manage the SQL Server system, databases, and users.
  • Manage database files by backing up or migrating to other systems.
  • Define and implement monitoring and tuning solutions to the SQL Server system.
  • Express High Availability options to SQL Server.
  • Explain the process and tool to migrate Oracle schemas to SQL Server databases.

Audience

This course is intended for experienced Oracle database administrators (DBAs) who work in an enterprise-level environment and require the skills to begin supporting and maintaining a SQL Server database.

Syllabus

Database and Instance

  • Defining a Database and an Instance
  • Introducing Microsoft’s and Oracle’s implementation of a database and an instance
  • Understanding client interaction
  • Key database and instance limitations

Database Architecture

  • Schema and Data Structure (Objects)
  • Storage Architecture
  • Logging Model
  • Data Dictionary
  • Lab : Database Architecture

Instance Architecture

  • Configure a Database server
  • Memory Architecture Overview
  • Memory Areas and Their Functions
  • Process and Thread Architecture
  • Controlling Resources in SQL Server 2008
  • Client and RDBMS Interactions
  • Background Processes/Threads and Their Functions
  • Lab : Instance Architecture

Data Objects

  • Tables are the main objects that store data
  • Indexes, views, stored programs, and other objects are the support structures
  • Various table types compared based on data organization
  • Various index types compared
  • Native and non-native data type support
  • Block-level storage architecture
  • Lab : Data Objects

Data Access

  • Introduce database components involved in data access
  • Introduce concepts of Transact-SQL and Procedural SQL as tools to access and manipulate data
  • Discuss transactional management concepts
  • Lab : Data Access

Data Protection

  • Protecting data from unauthorized users and authorized users
  • Using locking modes to achieve concurrency and consistency
  • Implementing database security features
  • Using auditing features to monitor database activity
  • Lab : Data Protection

Basic Administration

  • Planning and preparatory steps for a SQL Server environment
  • Creation and configuration of an instance of SQL Server and databases
  • Characteristics of a database
  • Basic database maintenance tasks
  • Lab : Creating Database

Server Management

  • Server-level and instance-level resources such as memory and processes
  • Database-level resources
  • User sessions and their activity
  • Concurrency structures
  • Lab : Resource Utilization

Managing Schema Objects

  • Naming guidelines for identifiers in schema object definitions
  • Storage and structure of schema objects
  • Implementing data integrity using constraints
  • Implementing business rules at the database level
  • Lab : Managing Schema Objects

Database Security

  • Manage access to database through user accounts
  • Control access to data through privileges and roles
  • Manage access to server using login accounts
  • Lab : Database Security

Data Transport

  • Tools and functionality in Oracle and their equivalents in SQL Server in data transport out and into the database
  • Tools and functionality in SQL Server for data transport within SQL Server and across multiple data sources and destinations
  • Lab : Transferring Data

Backup and Recovery

  • Backup and recovery methods available in Oracle and SQL Server 2008
  • Types of failure
  • Types of recovery
  • Lab : Create and Execute a Maintenance Plan for Backup

Performance Tuning

  • Performance tuning methodologies
  • Tools and techniques for performance analysis and tuning

Scalability and High Availability

  • Key high availability features available in Oracle and SQL Server
  • Key scalability features available in Oracle and SQL Server

Monitoring

  • Formulate requirements and identify resources to monitor database
  • Types of monitoring
  • Tools for monitoring
  • Lab : Integrating Performance Monitor Data in SQL Profiler

SQL

Training provider

Teaching mode:
Classroom - Instructor Led
Online - Instructor Led
Duration: 4 days
Gooroo has partnered with the global leaders in IT training to give you access to quality training, personalised to you, targeted at increasing your job opportunities and salary.

Our pricing

We do not display pricing as Gooroo members qualify for special discounts not available elsewhere. You must enquire through Gooroo to get this benefit.

New courses are happening all the time

Our partner's expert training consultant will provide you with the times and all the details you need. Enquire today.

Top skills covered in this course

Microsoft SQL Server
Worldwide
This skill has an average salary of
US$93,001
and is mentioned in
1.75%
of job ads.
Analysis
Worldwide
This skill has an average salary of
US$83,144
and is mentioned in
22.91%
of job ads.
High availability
Worldwide
This skill has an average salary of
US$106,642
and is mentioned in
0.35%
of job ads.
Oracle Database
Worldwide
This skill has an average salary of
US$96,410
and is mentioned in
2.83%
of job ads.