:: Information Data Systems ::

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

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
Database and Instance
1. Overview
2. Concept of Database and Instance
3. Client Interaction with Database and Instances
4. Database Limits
Database Architecture
1. Overview
2. Schema and Schema Objects
3. Storage Architecture
4. Logging Model
5. Data Dictionary
6. Review
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
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
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
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
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
Server Management
1. Overview
2. Memory Management
3. Process Management
4. Storage Management
5. Session and Transaction Management
6. Locks and Latches
7. Review
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
Database Security
1. Overview
2. User Management
3. Privilege Management
4. Role Management
5. Review
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
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
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
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
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
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."

Readmore...

Customer Testimonials