Exploring Oracle Database Architecture

• Introducing Oracle Database
• Relation Database Models
• Oracle SQL and PL/SQL
• Oracle Database Server Architecture
• Connecting to Oracle Databases
• Oracle Database Tools
• Oracle-Supplied User Accounts
• Querying the Oracle Data Dictionary

Managing Database Instances

• Initialization Parameter Files
• Starting Up Oracle Databases
• Shutting Down Oracle Databases
• Opening and Closing PDBs
• Working with the Automatic Diagnostic Repository (ADR)
• Querying Dynamic Performance Views

Creating PDBs

• Methods and Tools to Create PDBs
• Creating PDBs from Seed with SQL*Plus
• Cloning PDBs with SQL*Plus
• Unplugging and Pluggin In PDBs with SQL*Plus
• Dropping PDBs with SQL*Plus

Configuring the Oracle Network Environment

• Oracle Net Services
• How Listeners Work
• Configuring Listeners for Dynamic Service Registration
• Configuring Listeners for Static Service Registration
• Configuring Local Naming for Connections
• Testing Oracle Net Connectivity with tnsping
• Configuring Communication Between Databases
• Dedicated Versus Shared Server Configurations

Administering User Security

• Creating Users
• Granting Privileges
• Creating and Granting Roles
• Revoking Privileges and Roles
• Creating and Assigning Profiles
• Authenticating Users
• Assigning Quotas to Users
• Applying the Principal of Least Privilege

Creating and Managing Tablespaces

• How Table Data is Stored
• Creating Tablespaces in SQL*Plus
• Altering and Dropping Tablespaces in SQL*Plus
• Viewing Tablespace Information in SQL*Plus
• Implementing Oracle Managed Files
• Moving and Renaming Online Data Files in SQL*Plus

Managing Storage Space

• Oracle Database Space Management Features
• Block Space Management
• Row Chaining and Migration
• Free Space Management Within Segments
• Types of Segments
• Allocating Extents
• Understanding Deferred Segment Creation
• Space-Saving Features

Managing UNDO Data

• Undo Data: Overview
• Transactions and Undo Data
• Storing Undo Information
• Comparing Undo Data and Redo Data
• Managing Undo
• Local Undo Mode Versus Shared Undo Mode
• Configuring Undo Retention
• Categories of Undo

Moving Data

• Moving Data: General Architecture
• Oracle Data Pump: Overview
• Oracle Data Pump: Benefits
• Data Pump Export and Import Clients
• Data Pump Utility: Interfaces and Modes
• Data Pump Import: Transformations
• SQL*Loader Overview
• Loading Methods

Backup and Recovery Concepts

• DBA Responsibilities
• Categories of Failure
• Understanding Instance Recovery
• Understanding Types of Backups
• Comparing Complete and Incomplete Recovery
• Oracle Data Protection Solutions
• Flashback Technology

Monitoring and Tuning Database Performance

• Managing Performance Activities
• Performance Planning Considerations
• Database Maintenance
• Automatic Workload Repository (AWR)
• Automatic Database Diagnostic Monitor
• Performance Monitoring
• Performance Tuning Methodology
• Database Server Statistics and Metrics

SQL Tuning

• SQL Tuning Process
• Oracle Optimizer
• Optimizer Statistics
• SQL Plan Directives
• Adaptive Execution Plans
• SQL Tuning Advisor
• SQL Access Advisor
• SQL Performance Analyzer

Oracle Database Resource Manager

• Oracle Database Resource Manager: Overview
• Resource Manager Elements
• Using Resource Manager to Allocate Resources
• Creating a Simple Resource Plan
• Creating a Complex Resource Plan
• Using the Active Session Pool Feature
• Limiting CPU Utilization at the Database Level
• Limiting CPU Utilization at the Server Level

Enterprise Manager Cloud Control

• Controlling the Enterprise Manager Cloud Control Framework
• Starting the Enterprise Manager Cloud Control Framework
• Stopping the Enterprise Manager Cloud Control Framework

Introduction to Oracle Database Cloud Service

• Oracle Cloud: Overview
• Database Cloud Service Offerings
• DBCS Architecture
• Features and Tooling
• Additional Database Configuration Options

Creating DBCS Database Deployments

• Automated Database Provisioning
• Creating a Database Deployment
• How SSH Key Pairs are Used
• Creating an SSH Key Pair
• Storage Used for Database Files

Managing DBCS Database Deployments

• Cloud Tooling
• Accessing Tools and Features from the DBCS Console
• Managing the Compute Node Associated With a Database Deployment
• Managing Network Access to DBCS
• Enabling Access to a Compute Node Port
• Scaling a Database Deployment

Backing Up and Restoring DBCS Database Deployments

• Backing Up and Recovering Databases on DBCS
• Backup Destination Choices
• Backup Configuration
• Creating an On-Demand Backup
• Customizing the Backup Configuration
• Performing Recovery by Using the Console
• Performing Recovery by Using the dbaascli Utility

Patching DBCS Database Deployments

• Patching DBCS
• Using the DBCS Console to Manage Patches
• Using the dbaascli Utility to Manage Patches

Creating Master Encryption Keys for PDBs

• CDB and PDB Master Encryption Keys
• Determining Whether You Need to Create and Activate and Encryption Key for a PDB
• Creating and Activating an Encryption Key

Tablespace Encryption by Default

• Tablespace Encryption by Default in DBCS
• Transparent Data Encryption (TDE) Overview
• Components of TDE
• Using TDE
• Defining the Keystore Location
• Controlling Tablespace Encryption by Default
• Managing the Software Keystore and Master Encryption Key
• Managing the Keystore in CDBs and PDBs

Additional course details:

Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward.

This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts.

Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success.

While we feel this is the best course for the Oracle Database 12c R2 - Administration Workshop Ed 3 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you.

Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

FAQ for the Oracle Database 12c R2 - Administration Workshop Ed 3 Course

Available Delivery Options for the Oracle Database 12c R2 - Administration Workshop Ed 3 training.

• Live Instructor Led Classroom Online (Live Online)
• Traditional Instructor Led Classroom (TILT/ILT)
• Delivery at your offices in London or anywhere in the UK
• Private dedicated course as works for your staff.

How many CPD hours does the Oracle Database 12c R2 - Administration Workshop Ed 3 training provide?

The 5 day. Oracle Database 12c R2 - Administration Workshop Ed 3 training course give you up to 30 CPD hours/structured learning hours. If you need a letter or certificate in a particular format for your association, organisation or professional body please just ask.

What is the correct audience for the Oracle Database 12c R2 - Administration Workshop Ed 3 training?

Data Warehouse Administrator
Database Administrators
Database Designers
Support Engineer
Technical Administrator

Do you provide training for the Oracle Database 12c R2 - Administration Workshop Ed 3.

Yes we provide corporate training, dedicated training and closed classes for the Oracle Database 12c R2 - Administration Workshop Ed 3. This can take place anywhere in UK including, England, Scotland, Cymru (Wales) or Northern Ireland or live online allowing you to have your teams from across UK or further afield to attend a single training event saving travel and delivery expenses.

What is the duration of the Oracle Database 12c R2 - Administration Workshop Ed 3 program.

The Oracle Database 12c R2 - Administration Workshop Ed 3 training takes place over 5 day(s), with each day lasting approximately 8 hours including small and lunch breaks to ensure that the delegates get the most out of the day.

Why are Nexus Human the best provider for the Oracle Database 12c R2 - Administration Workshop Ed 3?

Nexus Human are recognised as one of the best training companies as they and their trainers have won and hold many awards and titles including having previously won the Small Firms Best Trainer award, national training partner of the year for UK on multiple occasions, having trainers in the global top 30 instructor awards in 2012, 2019 and 2021. Nexus Human has also been nominated for the Tech Excellence awards multiple times. Learning Performance institute (LPI) external training provider sponsor 2024.

Is there a discount code for the Oracle Database 12c R2 - Administration Workshop Ed 3 training.

Yes, the discount code PENPAL5 is currently available for the Oracle Database 12c R2 - Administration Workshop Ed 3 training. Other discount codes may also be available but only one discount code or special offer can be used for each booking. This discount code is available for companies and individuals.