Oracle Training: Mastering Oracle Database Administration


Course Delivery

Live Instructor-Led Training

Course Description

The course Mastering Oracle Database Administration (Oracle Training) is a complete study of Oracle database administration. We learn all about Oracle installation, configuration, databases, tablespaces, control files, data files, log files and more. The course discusses Oracle troubleshooting and diagnostics, fault tolerance, security, partitioning, and flashback management. The training also includes a discussion on performance tuning through an introduction to the use of indexes and statistics in Oracle database operations.

Course Dates and Pricing


Oct 30 - Nov 2, 2023$3,500.00Nov 27 - 30, 2023$3,500.00Jan 8 - 11, 2024$3,500.00Feb 5 - 8, 2024$3,500.00Mar 4 - 7, 2024$3,500.00

Course Outline

Oracle Architecture

The Database Instance and the Database
The Oracle Physical Architecture: Oracle, Cloud Control and More
Databases and Container Databases
About the Physical Layer: Data Files and Redo Log Files
The Structure of Physical Storage: Segments, Extents and Blocks
About the Logical Layer: Tablespaces
About the Control File
The Role of the pfile and the spfile
About Oracle Memory: The SGA and the PGA
About Processes: DBWn, CKPT, LGWR and More
Exploring the Data Modification Process from Request to Disc Write

Installing Oracle

Exploring Installation Options
Exploring the Response File and the DBCA
Configuring Preparing Oracle Linux for and Oracle installation
Creating Security Accounts and Groups
Setting Environment Variables
Running the Oracle Installation in Silent Mode

Creating the Database

Understanding the role of the Listener
Interacting with the Listener using lsnrctl
Setting Installation Options
Creating the Database in Silent Mode
Exploring the Artifacts Created by the Installation

Oracle Startup and Shutdown

Connecting for the First Time with SQL*Plus
Configuring SQL*Plus: Configuring History and the Prompt
Exploring the Oracle Startup-Shutdown Lifecycle: Start, Mount and Open
Exploring Startup Options
Exploring Shutdown Options
About Parameter Files and Server Parameter Files
About Modifying the System Run Time Configuration
Modifying the SPFILE: SPFILE, MEMORY or BOTH

Oracle Memory Management and the Shared Server Architecture

About Oracle Memory Management: Automatic Versus Manual
Revisiting the Data Modification Lifecycle: The Database Buffer Cache
Understanding the Role of the SGA and the PGA
Configuring Memory Thresholds
Understanding the Shared Server Architecture
Configuring the Shared Server Architecture
Configuring Dispatchers for Scalability

Mastering Control Files

How Control Files Are Used During Oracle Startup
About Control Files and The Default Oracle Tablespaces
About Control Files, Log Files and Data Files
Creating Additional Control Files
Viewing Alert and Log Data
Creating Control File Backups

managing tables and tablespaces

Logical Data Structures Versus Physical Data Structures
Exploring Oracle Data Blocks
About Oracle Default Tablespaces
Getting Tablespace Information
Creating Tablespaces
Adding Files to and Dropping Files from Tablespaces

Creating Encrypted Tablespaces

About Asymmetric Encryption and Linux
Understanding the Role of the Oracle Wallet
Creating and Opening an Oracle Wallet
Creating a Key in the Wallet
Creating an Encrypted Tablespace
Creating an Encrypted Table

Creating and Managing Online Redo Log Files

Exploring the Log Archive Process
ARCHIVELOG VS NOARCHIVELOG
Revisiting the Data Modification Workflow
Understanding Failure Scenarios and the Critical Role of the Log Archive
Working with Log Files and Log File Groups
Working With Archive Redo Log Files
Protecting Against Failure with Archive Redo Log File Groups
Exploring Undo Tablespace Management
Configuring Flashback Operations

Troubleshooting Oracle

Options For Writing to and Viewing The Log Files and The Trace Files
Diagnosing the Reason for an Oracle Instance Startup Failure
Generating a pfile from a Running Instance
Starting Oracle By Specifying A pfile
Generating a spfile from a pfile

Oracle Security

About Oracle User Security Architecture
Creating and Managing Profiles
Exploring Administrative Privileges
Creating Users
Creating Roles and Assigning System Privileges
Assigning Object Privileges
Creating Default Roles
Understanding Schemas and Their Relationship to Users
Exploring Ownership Chains

Creating Tables

Creating Tables and Specifying Tablespaces
Adding Primary Keys and Foreign Keys
About Execution Plans
Exporting Execution Plans to The Trace File
Working With Stored Outlines

Managing Statistics

The Importance of Statistics
Viewing The Statistics
Updating Table Statistics
Creating Schedule Tasks to Update Statistics

Managing Indexes

Exploring Indexes and Their Use In Relational Databases
Oracle index types: Bitmap, B-Tree, Index Organized and More
Creating B-Tree Indexes
Creating Index Organized Tables
Viewing Index Information
The Benefits of Covering Indexes
Revisiting Execution Plans when Indexes are Present

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.

Oct 16 - 19, 2023$3,750.00Nov 13 - 16, 2023$3,750.00Dec 11 - 14, 2023$3,750.00Jan 22 - 25, 2024$3,750.00Feb 19 - 22, 2024$3,750.00Mar 18 - 21, 2024$3,750.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.

Oct 9 - 12, 2023$3,750.00Nov 6 - 9, 2023$3,750.00Dec 4 - 7, 2023$3,750.00Jan 15 - 18, 2024$3,750.00Feb 12 - 15, 2024$3,750.00Mar 11 - 14, 2024$3,750.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.

Oct 16 - 19, 2023$3,750.00Nov 13 - 16, 2023$3,750.00Dec 11 - 14, 2023$3,750.00Jan 22 - 25, 2024$3,750.00Feb 19 - 22, 2024$3,750.00Mar 18 - 21, 2024$3,750.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.

Oct 9 - 12, 2023$3,350.00Nov 6 - 9, 2023$3,350.00Dec 4 - 7, 2023$3,350.00Jan 15 - 18, 2024$3,350.00Feb 12 - 15, 2024$3,350.00Mar 11 - 14, 2024$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.

Oct 9 - 12, 2023$3,750.00Nov 6 - 9, 2023$3,750.00Dec 4 - 7, 2023$3,750.00Jan 15 - 18, 2024$3,750.00Feb 12 - 15, 2024$3,750.00Mar 11 - 14, 2024$3,750.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.

Oct 16 - 19, 2023$3,350.00Nov 13 - 16, 2023$3,350.00Dec 11 - 14, 2023$3,350.00Jan 22 - 25, 2024$3,350.00Feb 19 - 22, 2024$3,350.00Mar 18 - 21, 2024$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.

Oct 23 - 26, 2023$3,750.00Nov 20 - 23, 2023$3,750.00Dec 18 - 21, 2023$3,750.00Jan 29 - Feb 1, 2024$3,750.00Feb 26 - 29, 2024$3,750.00Mar 25 - 28, 2024$3,750.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.

Oct 16 - 19, 2023$3,750.00Nov 13 - 16, 2023$3,750.00Dec 11 - 14, 2023$3,750.00Jan 22 - 25, 2024$3,750.00Feb 19 - 22, 2024$3,750.00Mar 18 - 21, 2024$3,750.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.

Oct 30 - Nov 2, 2023$3,750.00Nov 27 - 30, 2023$3,750.00Jan 8 - 11, 2024$3,750.00Feb 5 - 8, 2024$3,750.00Mar 4 - 7, 2024$3,750.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.

Oct 11 - 13, 2023$3,350.00Nov 8 - 10, 2023$3,350.00Dec 6 - 8, 2023$3,350.00Jan 17 - 19, 2024$3,350.00Feb 14 - 16, 2024$3,350.00Mar 13 - 15, 2024$3,350.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.

Oct 25 - 27, 2023$2,250.00Nov 22 - 24, 2023$2,250.00Dec 20 - 22, 2023$2,250.00Jan 31 - Feb 2, 2024$2,250.00Feb 28 - Mar 1, 2024$2,250.00Mar 27 - 29, 2024$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.

Oct 9 - 12, 2023$3,750.00Nov 6 - 9, 2023$3,750.00Dec 4 - 7, 2023$3,750.00Jan 15 - 18, 2024$3,750.00Feb 12 - 15, 2024$3,750.00Mar 11 - 14, 2024$3,750.00