SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Oracle Training

Liked the interactive working with other students in the class. This allowed practice of not only the exercise, but what it would be like in a work environment.
Comment from HRSDC

1. Title

  • The Complete Database Administrator Course Part II : Mastering MySQL and Oracle Administration (DBCOMP2, 5 days)
    View PDF

2. Course Pre-requisites

  • Previous experience in a database administrator role, or DBCOMP1

3. Target Audience

  • IT Professionals who want to learn how to effectively administer a multi-platform production database environment.

4. Dates and Pricing

Sep 18 to Sep 22, 2017$2,775.00/person
Nov 27 to Dec 1, 2017$2,775.00/person

5. Outline

Module 1: Installation

Topic 1: Planning an Installation

Topic 2: Preparing the Environment

Topic 3: Performing and Verifying a MySQL Installation

Topic 4: Tuning a MySQL Server

Topic 5: Performing and Verifying an Oracle Installation

Topic 6: Tuning an Oracle Server

Topic 7: Performing and Verifying a SQL Server Installation

Topic 8: Tuning a SQL Server

Topic 9: Performing and Verifying a PostgreSQL Server Installation

Topic 10: Tuning a PostgreSQL Server

Topic 11: Putting It All Together

Module 2: Relational Database Storage

Topic 1: The Principles of Data Storage

Topic 2: About Data Blocks and Their Impact on Performance and Design

Topic 3: Creating and Managing Database Files with MySQL

Topic 4: Creating and Managing Tablespaces with Oracle

Topic 5: Creating and Managing Tablespaces with PostgreSQL

Topic 6: Creating and Managing Database Files in SQL Server

Topic 7: Retrieving Space Allocation and Usage with the Various Platforms

Module 3: Performance Optimization

Topic 1: Optimization Overview

Topic 2: Analyzing Queries for Oracle, MySQL, PostgreSQL and SQL Server

Topic 3: Gathering Practical and Strategic Data

Topic 4: Understanding the Importance of the Execution Plan: Actual vs Estimated

Topic 5: Optimizing for Data Retrieval

Topic 6: Optimizing for Insert, Update and Delete

Topic 7: Optimizing for Stored Procedures

Topic 8: Analyzing and Performing Bulk Operations

Topic 9: Analyzing and Optimizing Multi-Table Join Operations

Topic 10: Understanding Server Transactions and Locks

Topic 11: Dealing with Deadlocks and Livelocks

Module 4: Backup and Recovery

Topic 1: Fault Tolerance vs Backup

Topic 2: Planning a Backup Strategy

Topic 3: Implementing a Backup Strategy for Oracle

Topic 4: Implementing a Backup Strategy for MySQL

Topic 5: Automating Backups

Topic 6: Recovering From Failure

Topic 7: Recovering System Databases

Module 5: Implementing Fault Tolerance and High Availability

Topic 1: Essentials of High Availability and Fault Tolerance

Topic 2: About Clustering and Mirroring

Topic 3: MySQL Fault Tolerance Options

Topic 4: Oracle Fault Tolerance Options

Topic 5: SQL Server Fault Tolerance Options

Topic 6: PostgreSQL Server Fault Tolerance Options

Topic 7: Implementing a Fault Tolerance Strategy

Module 6: Implementing Security

Topic 1: Security Management Overview

Topic 2: Planning and Implementing Security Management

Topic 3: Configuring the Server

Topic 4: Creating Logins

Topic 5: Creating Users

Topic 6: Granting Permissions: Grant, Deny and Revoke

Topic 7: Other Security Considerations

Module 7: Monitoring Databases

Topic 1: Overview of Monitoring Tools

Topic 2: Planning to Monitor your Server

Topic 3: Implementing Alerts and Notifications

Topic 4: Using Performance Counters - Establishing a Baseline

Topic 5: Using Performance Counters - Analyzing Data

Topic 6: Profiling and Analyzing Queries

Module 8: A Complete Lab for Database Administrators

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette