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

Oracle Training

Excellent trainer, very patient and helpful.
Comment from Public Safety Canada

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

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