7033 Microsoft SQL Server 2005 for Experienced DBAs

Overview

The purpose of this course is to teach Oracle DBAs how to leverage their skills and experience as an Oracle DBA to manage a SQL Server system.

Audience

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.

Syllabus

Database and Instance

  • Concept of Database and Instance
  • Client interaction with Database and Instance
  • Database limits

Database Architecture

  • Schema and schema objects
  • Storage Architecture
  • Logging Model
  • Data Dictionary

Instance Architecture

  • 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

Data Objects

  • 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

Data Access

  • Relational engine
  • Structured Query Language
  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Control Statements
  • Procedural SQL
  • Cursors
  • Error Handling
  • Query Optimization
  • Transaction Management

Data Protection

  • Concurrency and Consistency
  • Locking
  • Flashback Query in Oracle
  • Database Security
  • Privileges and Roles
  • Auditing

Basic Administration

  • Installing SQL Server
  • Database System
  • SQL Server databases
  • Database Configuration
  • Database Maintenance
  • Data Dictionary
  • System Stored Procedures

Server Management

  • Managing Memory
  • Managing Processes
  • Managing Storage
  • Managing Sessions and Transactions
  • Locks and Latches

Managing Schema Objects

  • Object Identifiers and Naming
  • Managing Tables
  • Managing Constraints
  • Managing Triggers
  • Managing Indexes
  • Managing Views
  • Sequences

Database Security

  • Managing Users
  • Managing Privileges
  • Managing Roles

Data Transport

  • Data out Overview
  • Data in Overview
  • SQL Server Data Transport
  • SQL Server Integration Services (SSIS)
  • Elements of Integration Services
  • SSIS Tools
  • Copy Database Wizard

Backup and Recovery

  • Database Errors
  • Backup methods
  • Recovery Models
  • Factors affecting backup strategy decisions
  • Recovering from database errors
  • Backup and Recovery tools
  • Third-party backup and recovery solutions

Performance Tuning

  • Tuning Methodologies—Tuning While Building
  • Tuning Methodologies—Performance Tuning
  • Application Tuning
  • Instance Tuning
  • SQL Server Performance Tuning Tools

Scalability and High Availability

  • High Availability
  • Clustering
  • Standby Database
  • Replication—Objects
  • Replication—Types of
  • Database Mirroring
  • Scalability
  • Scalability and HA in Backup and Recovery

Monitoring

  • Monitoring Availability
  • Monitoring Errors
  • Error Logs
  • Monitoring Performance – Server
  • Monitoring Performance – Database and Instance
  • Monitoring Tools

Microsoft SQL Server Migration Assistant (SSMA)

  • Installing SSMA
  • Configuring Options
  • Simulations
  • Assessment Reports
  • Schema Conversion and Migration
  • Data Migration
  • Converting Stored Programs
  • Viewing modes
  • Migration Testing
  • Test SQL
  • SSMA Workspace

Training provider

Teaching mode:
Online - Self paced
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$81,523
and is mentioned in
1.72%
of job ads.
High availability
Worldwide
This skill has an average salary of
US$95,314
and is mentioned in
0.34%
of job ads.
Oracle Database
Worldwide
This skill has an average salary of
US$86,026
and is mentioned in
2.46%
of job ads.
Database
Worldwide
This skill has an average salary of
US$71,026
and is mentioned in
10.54%
of job ads.