Microsoft SQL Server 2008 Training Courses


50006: Microsoft SQL Server 2008 for the Oracle DBA


Course Description

This four-day instructor-led 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.

50006: Microsoft SQL Server 2008 for the Oracle DBA Course Outline


  1. Workshop Introduction
    1. Overview
    2. Workshop Objectives
    3. Workshop Prerequisites
    4. Workshop Outline
    5. RDBMS Similarities
    6. Introduction to SQL Server 2005
    7. SQL Server 2008 Manageability
    8. SQL Server 2008 High Availability
    9. SQL Server 2008 Scalability
    10. SQL Server 2008 Security
    11. SQL Server 2008 Programmability
    12. SQL Server 2008 Data Movement
  2. Database and Instance
    1. Overview
    2. Concept of Database and Instance
    3. Client Interaction with Database and Instances
    4. Database Limits
  3. Database Architecture
    1. Overview
    2. Schema and Schema Objects
    3. Storage Architecture
    4. Logging Model
    5. Data Dictionary
    6. Review
  4. Instance Architecture
    1. Overview
    2. Configuration
    3. Memory Architecture -- Overview
    4. Process and Thread-Based Architecture
    5. Oracle Client-Database Interaction
    6. SQL Server 2008 Client-Database Interaction
    7. Oracle Background Processes
    8. SQL Server Background Processes
    9. Review
  5. Data Objects
    1. Overview
    2. Schema Objects -- Table
    3. Clustered Index
    4. Constraints
    5. Triggers
    6. Indexes
    7. Views
    8. Character-Based Data Types
    9. Numeric Data Types
    10. Binary Data Types
    11. Object Data Storage
    12. Review
  6. Data Access
    1. Overview
    2. Relational Engine
    3. Structure Query Language (SQL)
    4. Data Definition Language (DDL)
    5. Data Manipulation Language (DML)
    6. Control Statements
    7. Procedural SQL
    8. Cursors
    9. Error Handling
    10. Query Optimization
    11. Transaction Management
    12. Review
  7. Data Protection
    1. Overview
    2. Concurrency and Consistency
    3. Locking
    4. Flashback Query in Oracle
    5. Database Security
    6. Privileges and Roles
    7. Auditing
    8. Review
  8. Basic Administration
    1. Overview
    2. SQL Server Installation
    3. Database System
    4. SQL Server Databases
    5. Database Configuration
    6. Database Maintenance
    7. Data Dictionary
    8. System Stored Procedures
    9. Review
  9. Server Management
    1. Overview
    2. Memory Management
    3. Process Management
    4. Storage Management
    5. Session and Transaction Management
    6. Locks and Latches
    7. Review
  10. Schema Object Management
    1. Overview
    2. Object Identifiers and Naming
    3. Table Management
    4. Constraint Management
    5. Trigger Management
    6. Index Management
    7. View Management
    8. Sequences
    9. Review
  11. Database Security
    1. Overview
    2. User Management
    3. Privilege Management
    4. Role Management
    5. Review
  12. Data Transport
    1. Overview
    2. Data Out Overview
    3. Data In Overview
    4. SQL Server Data Transport
    5. SQL Server Integration Services (SSIS)
    6. Elements of Integration Services
    7. SSIS Tools
    8. Copy Database Wizard
    9. Review
  13. Backup and Recovery
    1. Overview
    2. Database Errors
    3. Backup Methods
    4. Recovery Models
    5. Factors Affecting Backup Strategy Decisions
    6. Database Error Recovery
    7. Backup and Recovery Tools
    8. Third-Party Backup and Recovery Solutions
    9. Review
  14. Performance Tuning
    1. Overview
    2. Tuning Methodologies -- Tuning While Building
    3. Tuning Methodologies -- Performance Tuning
    4. Application Tuning
    5. Instance Tuning
    6. SQL Server Performance Tuning Tools
    7. Review
  15. Scalability and High Availability
    1. Overview
    2. High Availability
    3. Clustering
    4. Standby Database
    5. Replication -- Objects
    6. Replication -- Types of
    7. Database Mirroring
    8. Scalability
    9. Scalability and High Availability in Backup and Recovery
    10. Review
  16. Monitoring
    1. Overview
    2. Availability Monitoring
    3. Error Monitoring
    4. Error Logs
    5. Performance Monitor -- Server
    6. Performance Monitor -- Database and Instance
    7. Tool Monitoring
    8. Review
  17. Microsoft SQL Server SSMA
    1. Overview
    2. SSMA Installation
    3. Option Configuration
    4. Simulations
    5. Assessment Reports
    6. Schema Conversion and Migration
    7. Data Migration
    8. Stored Program Converting
    9. Viewing Modes
    10. Migration Testing
    11. SQL Testing
    12. SSMA Workspace
    13. Review

Technology Partners


"Our Gold Certified Partner designation demonstrates to both prospective and existing clients that our organization has demonstrated the highest level of competence and expertise with Microsoft technologies. Having such a close working relationship with Microsoft allows us to further enhance the level of service we deliver to our clients."

Customer Testimonials

2011 Information Data Systems Inc. All Rights Reserved.Home | Sitemap | Contact Us