The Complete Database Administrator Course Part II : Mastering MySQL and Oracle Administration
(DBCOMP2, Live Instructor-Led Training, 5 days)


Description

The SETC certified complete Database course targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part II of the course focusses on the components of a production environment that allow database professionals to excel in their mission critical responsibilities.

Dates and Pricing


Nov 27 to Dec 1, 2017$2,500/person Jan 8 to Jan 12, 2018$2,500/person Feb 5 to Feb 9, 2018$2,500/person Mar 5 to Mar 9, 2018$2,500/person

Outline

Installation
Planning an Installation
Preparing the Environment
Performing and Verifying a MySQL Installation
Tuning a MySQL Server
Performing and Verifying an Oracle Installation
Tuning an Oracle Server
Performing and Verifying a SQL Server Installation
Tuning a SQL Server
Performing and Verifying a PostgreSQL Server Installation
Tuning a PostgreSQL Server
Putting It All Together
Relational Database Storage
The Principles of Data Storage
About Data Blocks and Their Impact on Performance and Design
Creating and Managing Database Files with MySQL
Creating and Managing Tablespaces with Oracle
Creating and Managing Tablespaces with PostgreSQL
Creating and Managing Database Files in SQL Server
Retrieving Space Allocation and Usage with the Various Platforms
Performance Optimization
Optimization Overview
Analyzing Queries for Oracle, MySQL, PostgreSQL and SQL Server
Gathering Practical and Strategic Data
Understanding the Importance of the Execution Plan: Actual vs Estimated
Optimizing for Data Retrieval
Optimizing for Insert, Update and Delete
Optimizing for Stored Procedures
Analyzing and Performing Bulk Operations
Analyzing and Optimizing Multi-Table Join Operations
Understanding Server Transactions and Locks
Dealing with Deadlocks and Livelocks
Backup and Recovery
Fault Tolerance vs Backup
Planning a Backup Strategy
Implementing a Backup Strategy for Oracle
Implementing a Backup Strategy for MySQL
Automating Backups
Recovering From Failure
Recovering System Databases
Implementing Fault Tolerance and High Availability
Essentials of High Availability and Fault Tolerance
About Clustering and Mirroring
MySQL Fault Tolerance Options
Oracle Fault Tolerance Options
SQL Server Fault Tolerance Options
PostgreSQL Server Fault Tolerance Options
Implementing a Fault Tolerance Strategy
Implementing Security
Security Management Overview
Planning and Implementing Security Management
Configuring the Server
Creating Logins
Creating Users
Granting Permissions: Grant, Deny and Revoke
Other Security Considerations
Monitoring Databases
Overview of Monitoring Tools
Planning to Monitor your Server
Implementing Alerts and Notifications
Using Performance Counters - Establishing a Baseline
Using Performance Counters - Analyzing Data
Profiling and Analyzing Queries
A Complete Lab for Database Administrators