Oracle Training: Oracle Administration Complete


Course Delivery

Live Instructor-Led Training

Course Description

The course Oracle Administration Complete (Oracle Training) is an exploration of Oracle database administration from A to Z. We learn all about Oracle installation, configuration, databases, tablespaces, files & more. The course discusses Oracle enterprise manager, fault tolerance, high availability, security, partitioning, & flashback management. The training also includes a discussion on performance tuning through configuration, PLSQL tuning & database indexing.

Course Dates and Pricing


May 29 - Jun 1, 2018$2,775.00Jun 26 - 29, 2018$2,775.00Sep 4 - 7, 2018$2,775.00Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00

Course Outline

Oracle 11g Server Overview

Learning Objectives
DBA Roles and Responsibilities
The Oracle RDBMS
Oracle Server Product Overview
Oracle Architecture
Overview of PL/SQL
Objectives Covered

Installing an Oracle 11g Server

Learning Objectives
Preparing for an Oracle 11g Installation
Installing an Oracle 11g Server
Product Specific Prerequisite Checks
Database Configuration
Database Content: Sample Schemas
Recovery Configuration
Memory Parameters
Database Connection Mode
Security Settings
Creation Options
Objectives Covered

Creating and Configuring Databases

Learning Objectives
Oracle Database Server: Core Services
Tablespaces, Datafiles and Control Files
Converting Text-based to Server Parameter files
Overview of Memory Allocation and Memory Targets
Simplifying Memory Allocation and Memory Targets
Using the SQL *PLUS Utility
Configuring Oracle Databases
Overview of SYSDBA Privilege
Authenticating Connections having SYSDBA Privilege
Automating Database Management
Objectives Covered

Administering an Oracle 11g Server

Learning Objectives
Administering Oracle Databases
Using the Oracle Administration Assistant
Administering User Roles
Overview of Sophisticated Password
Authenticating Users with Sophisticated Password Checking
Ensuring Database Availability
Objectives Covered

Managing Tables and Files

Learning Objectives
Overview of Profiles
Limiting Resources Usage Through Profiles
Overview of Read Only Tables
Preventing Changes to Read Only Tables
Comparing Traditional managed and Oracle Managed Files
Configuring Storage Patterns for Database Objects
Structuring Data and Index Segments
Overview of Extents and Block Occupancy
Sizing Database Objects by defining Extents and Block Occupancy
Overview of PCTFree and Data Pump
Eliminating Row Mitigation with PCTFree and Data Pump
Compressing Table Data to Conserve Storage
Shrinking Tables and Indexes Online to Regain Space
Objectives Covered

Oracle Database Processes and Features

Learning Objectives
Processing Transactions with the Server
Overview of Processes and Memory Structures
Identifying types of Oracle 11g Processes and Memory Structures
Understanding Database File Structures
Archiving the Redo Log
Overview of the Result Cache
Sizing the Result Cache for Optimizing Repeated Queries
Objectives Covered

Oracle 11g Networking

Learning Objectives
Oracle Net Configuration Assistant
Listener Configuration
Naming Methods Configuration
Local Net Service Configuration
Directory Usage Configuration
Oracle Net Manager
General Tracing Settings
Oracle Advanced Security
Service Identification
Configuring Listeners
Naming Methods
Objectives Covered

Oracle Enterprise Manager

Learning Objectives
Oracle Enterprise Manager
Database Performance Page
Database Availability Page
Database Server Page
Database Schema Page
Database Data Movement
Database Software and Support
Configuring Enterprise Manager
Configuring Administrators
Oracle Notification Methods
Metalink and Patching Settings
Offline Patching Settings
Linux Server Staging Setup
Blackouts
Management Pack Access
Monitoring Templates
Corrective Actions Library
Data Exchange Hub
Management Services and Repository
Agents
Objectives Covered

Administering with Database Control

Learning Objectives
Comparing Command-Line and Graphical Interfaces
Overview of Database Control
Administering with Database Control
Equipping Database Control to Manage Additional Databases
Objectives Covered

Thresholds and Alerts

Learning Objectives
Overview of Thresholds and Alerts
Setting Thresholds and Generating Alerts
Verifying Changes in the Data Dictionary
Overview of Privilege Management
Performing Privilege Management
Objectives Covered

Flashback Management

Learning Objectives
Performing Flashback Management
Managing Space for Rollback and Read Consistency
Monitoring Expansion of Rollback Segments
Swapping to an alternative Undo Tablespace
Resetting Data to Recent Points in Time with Flashback
Tracking Changes to Data Values with Row History
Overview of Transaction History
Obtaining Transaction History with Flashback Transaction
Overview of Flashback Table
Performing efficient Recovery of Data with Flashback Table
Overview of the Recycle Bin
Retrieving Dropped Tables and Dependent Objects from the Recycle Bin
Objectives Covered

Partitioning

Learning Objectives
Overview of Partitioning
Partitioning to Support Administration and Availability
Overview of Table Partitions Recommendations
Creating Table Partitions and Sub-Partitions
Choosing Partitioning Methods - range, list, hash, intervals
Partitioning Tables based on Virtual Columns
Setting up Automatic Partition Allocation
Administering Partitions with merge, split, add and drop
Objectives Covered

Indexes

Learning Objectives
Overview of Partition Indexes
Maintaining Partition Indexes
Maximizing Performance with Local and Global Indexes
Monitoring Index Partition Usage
Overview of Unusable Indexes
Rebuilding Unusable Indexes
Objectives Covered

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related Oracle Training

PLSQL Training: Mastering Database Programming with PL/SQL

The course Mastering Database Programming with PL/SQL (PLSQL Training) covers the essential elements of the PL/SQL language. The training includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. The course also covers blocks, data types, variables, program flows, stored procedures & functions and PL/SQL packages. Training course titled PLSQL Training: Mastering Database Programming with PL/SQL that will allow you to hone your professional skills.

May 22 - 25, 2018$2,775.00Jun 19 - 22, 2018$2,775.00Sep 4 - 7, 2018$2,775.00Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00

PLSQL Training: Objects, Librairies, XML, Java & More

The course Objects, Libraries, XML, Java & More (PLSQL Training) covers the advanced elements of PL/SQL. Beginning with stored procedures & functions, the training discusses database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling & object oriented programming in PL/SQL. The course concludes with XML processing, Java integration and performance tuning & optimization in Oracle. Training course titled PLSQL Training: Objects, Librairies, XML, Java & More that will allow you to hone your professional skills.

May 30 - Jun 1, 2018$1,675.00Jun 27 - 29, 2018$1,675.00Sep 12 - 14, 2018$1,675.00Oct 10 - 12, 2018$1,675.00Nov 7 - 9, 2018$1,675.00Dec 5 - 7, 2018$1,675.00

PLSQL Training: The Complete PL/SQL Programming Course

The course The Complete PL/SQL Programming Course (PLSQL Training) is a detailed exploration of the PL/SQL language and it many nooks and crannies. The course covers basic & advanced SQL techniques and PL/SQL programming fundamentals. The training also includes cursors, triggers, stored procedures & functions, sequences and packages. Finally, the course discusses object oriented programming, Java integration, XML processing & performance tuning with indexes. This PL/SQL course will teach you how to write great PL/SQL code. Training course titled PLSQL Training: The Complete PL/SQL Programming Course that will allow you to hone your professional skills.

Jun 5 - 8, 2018$2,775.00Sep 11 - 14, 2018$2,775.00Oct 9 - 12, 2018$2,775.00Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00

Oracle Training: A Complete Introduction to Forms & Reports

The course A Complete Introduction to Forms & Reports (Oracle Training) covers the essentials skills that are necessary to design. implement & troubleshoot Oracle Forms and Reports. Whether you need to build a report that highlights sales in the last quarter or build a form that allows sales to be entered into an Oracle database, this is the training course for you. Training course titled Oracle Training: A Complete Introduction to Forms & Reports that will allow you to hone your professional skills.

May 22 - 25, 2018$2,775.00Jun 19 - 22, 2018$2,775.00Sep 11 - 14, 2018$2,775.00Oct 9 - 12, 2018$2,775.00Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00

Oracle Training: Building a Data Warehouse

The course Building a Data Warehouse (Oracle Training) focuses on the art, functionality and application of Data Mining and Data Warehousing with Oracle. Beginning with the definitions of facts and dimensions, the course discusses every aspect of the Data Warehouse creation process from data loading to data mining. Implementing a data warehouse has never been this intuitive. Training course titled Oracle Training: Building a Data Warehouse that will allow you to hone your professional skills.

May 29 - Jun 1, 2018$3,350.00Jun 26 - 29, 2018$3,350.00Sep 11 - 14, 2018$3,350.00Oct 9 - 12, 2018$3,350.00Nov 6 - 9, 2018$3,350.00Dec 4 - 7, 2018$3,350.00

Oracle Training: Database Administration A to Z

The course Database Administration A to Z (Oracle Training) 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. Training course titled Oracle Training: Database Administration A to Z that will allow you to hone your professional skills.

Jun 12 - 15, 2018$2,775.00Sep 11 - 14, 2018$2,775.00Oct 9 - 12, 2018$2,775.00Nov 6 - 9, 2018$2,775.00Dec 4 - 7, 2018$2,775.00

Oracle Training: MySQL Core Administration

The course MySQL Core Administration (Oracle Training) :: database course introduces the MySQL Relational Database Management System. Every aspect of MySQL database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the MySQL database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a MySQL database in your organization, this is the course for you. Training course titled Oracle Training: MySQL Core Administration that will allow you to hone your professional skills.

Jun 5 - 8, 2018$3,350.00Sep 4 - 7, 2018$3,350.00Oct 2 - 5, 2018$3,350.00Oct 30 - Nov 2, 2018$3,350.00Nov 27 - 30, 2018$3,350.00

Oracle Training: Oracle Core Administration

The course Oracle Core Administration (Oracle Training) is an exploration of the installation, configuration and maintenance of Oracle servers on Linux. The training includes an architecture overview, performance optimization through caching/tuning, backup & recovery and security. This comprehensive course discusses every aspect of Oracle database administration. Training course titled Oracle Training: Oracle Core Administration that will allow you to hone your professional skills.

Jun 12 - 15, 2018$2,775.00Sep 4 - 7, 2018$2,775.00Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00

Oracle Training: Professional Database Tuning & Optimization

The course Professional Database Tuning & Optimization (Oracle Training) is a detailed exploration of Oracle database performance tuning and optimization. The training includes a discussion of the tools of the performance tuning trade and quickly proceeds to coverage of structural SQL optimization techniques and PL/SQL code optimization. The course covers database indexing and server & memory optimization techniques. Fine tune your Oracle database to make them lightning fast. Training course titled Oracle Training: Professional Database Tuning & Optimization that will allow you to hone your professional skills.

Jun 5 - 8, 2018$2,775.00Sep 18 - 21, 2018$2,775.00Oct 16 - 19, 2018$2,775.00Nov 13 - 16, 2018$2,775.00Dec 11 - 14, 2018$2,775.00

Oracle Training: SQL for Data Definition & Extraction

The course SQL for Data Definition & Extraction (Oracle Training) 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 I of the course focusses on the essentials of the SQL language as it is applied to a variety of database platforms. This course will provide you with a comprehensive overview of the SQL language as it is defined by the ANSI standard. Training course titled Oracle Training: SQL for Data Definition & Extraction that will allow you to hone your professional skills.

Jun 5 - 8, 2018$2,775.00Sep 4 - 7, 2018$2,775.00Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00

PLSQL Training: Introduction to Data Design & Manipulation

The course Introduction to Data Design & Manipulation (PLSQL Training) is an introduction to PL/SQL programming. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction. Training course titled PLSQL Training: Introduction to Data Design & Manipulation that will allow you to hone your professional skills.

Jun 13 - 15, 2018$2,250.00Sep 26 - 28, 2018$2,250.00Oct 24 - 26, 2018$2,250.00Nov 21 - 23, 2018$2,250.00Dec 19 - 21, 2018$2,250.00

SQL Server Training: Core Administration Skills

The course Core Administration Skills (SQL Server Training) is an exploration of database administration with SQL Server. Every aspect of SQL Server database administration is covered from the creation of relational databases & tables to the development of powerful TSQL scripts to automate primary administrative tasks. The training includes SQL Server database security & monitoring , performance tuning, backup & recovery, security and indexing to name a few. Training course titled SQL Server Training: Core Administration Skills that will allow you to hone your professional skills.

Jun 12 - 15, 2018$2,775.00Sep 4 - 7, 2018$2,775.00Oct 2 - 5, 2018$2,775.00Oct 30 - Nov 2, 2018$2,775.00Nov 27 - 30, 2018$2,775.00