Oracle Database 19C:Administration Workshop Certification Training Course

Download Course Contents

Oracle Database 19C:Administration Workshop Course Overview

Enroll for the 5-day Oracle Database 19C: Administration Workshop from Koenig Solutions accredited by Oracle. In this oracle certification will learn about Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle database.

Through a blend of hands-on labs and interactive lectures you will learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

Target Audience:

This Oracle Database 19c Administration course is for anyone who needs to administer, monitor and support an Oracle database.

Learning Objectives:

After completing this course, you will be able to you have knowledge required to maintain successful and efficient day-to-day operations of an Oracle database. The delegate will gain practical experience in administering and monitoring an Oracle database.
 

 

The 1-on-1 Advantage
Methodology
Flexible Dates
  • • Choose Start Date
  • • Reschedule After Booking
  • • Weekend / Evening Option
4-Hour Sessions

You will learn:

Module 1: Introduction to Oracle Database
  • Objectives
  • Oracle Database Server Architecture: Overview
  • Oracle Multitenant Container Database: Introduction
  • Oracle Multitenant Container Database: Architecture
  • Oracle Database Instance Configurations
  • Database Sharding: Introduction
  • Oracle Database Server: Interactive Architecture Diagram
  • Summary
  • Objectives
  • Connecting to an Oracle Database Instance
  • Oracle Database Tools
  • Database Tool Choices
  • SQL*Plus
  • Oracle SQL Developer
  • Oracle SQL Developer: Connections
  • Oracle SQL Developer: DBA Actions
  • Database Configuration Assistant (DBCA)
  • Oracle Enterprise Manager Database Express
  • Enterprise Manager Cloud Control 13c Features
  • Oracle Enterprise Manager Component Overview
  • Single Pane of Glass for Enterprise Management
  • Oracle Enterprise Manager Database Management
  • Summary
  • Objectives
  • Planning the Database
  • Choosing a Database Template
  • Choosing the Appropriate Character Set
  • How Are Character Sets Used?
  • Setting NLS_LANG Correctly on the Client
  • Using the Database Configuration Assistant
  • Using DBCA in Silent Mode
  • Summary
  • Practice Overview
  • Objectives
  • Creating a Container Database (CDB)
  • Creating a CDB by Using a SQL Command: Example
  • Using the SEED FILE_NAME_CONVERT Clause
  • Using the ENABLE PLUGGABLE DATABASE Clause
  • Summary
  • Practice Overview
  • Objectives
  • Starting the Oracle Database Instance
  • Shutting Down an Oracle Database Instance
  • Comparing SHUTDOWN Modes
  • Opening and Closing PDBs
  • Configuring PDBs to Automatically Open
  • Summary
  • Practice Overview
  • Objectives
  • Working with Initialization Parameters
  • Initialization Parameters
  • Modifying Initialization Parameters
  • Viewing Initialization Parameters
  • Working with the Automatic Diagnostic Repository
  • Automatic Diagnostic Repository
  • Viewing the Alert Log
  • Using Trace Files
  • Administering the DDL Log File
  • Querying Dynamic Performance Views
  • Considerations for Dynamic Performance Views
  • Data Dictionary: Overview
  • Querying the Oracle Data Dictionary
  • Summary
  • Practice Overview
  • Objectives
  • Connecting to the Database Instance
  • Oracle Net Services: Overview
  • Defining Oracle Net Services Components
  • Tools for Configuring and Managing Oracle Net Services
  • Oracle Net Listener: Overview
  • The Default Listener
  • Comparing Dedicated and Shared Server Architecture
  • Summary
  • Objectives
  • Establishing Oracle Network Connections
  • Connecting to an Oracle Database Instance
  • Name Resolution
  • Establishing a Connection
  • User Sessions
  • Naming Methods
  • Easy Connect
  • Local Naming
  • Directory Naming
  • Using Database Services to Manage Workloads
  • Creating Database Services
  • Summary
  • Practice Overview
  • Objectives
  • Review: Oracle Net Services Overview
  • Oracle Net Listener: Overview
  • The Default Listener
  • Configuring Dynamic Service Registration
  • Configuring Static Service Registration
  • Summary
  • Practice Overview
  • Objectives
  • Shared Server Architecture: Overview
  • Comparing Dedicated and Shared Server Architecture: Review
  • Enabling Shared Server
  • Controlling Shared Server Operations
  • SGA and PGA Usage
  • Shared Server Configuration Considerations
  • Summary
  • Practice Overview
  • Objectives
  • Oracle Connection Manager: Overview
  • Oracle Connection Manager Processes
  • Oracle Connection Manager: Architecture
  • Using Filtering Rules
  • Implementing Intranet Access Control
  • Implementing Internet Access Control
  • Using Session Multiplexing
  • Configuring Oracle Connection Manager
  • Configuring the cman.ora File
  • Example of a cman.ora File
  • Configuring Clients
  • Configuring the Database Server
  • Configuring the Database Server for Multiplexing (Optional)
  • Using the Oracle Connection Manager Control Utility
  • Review of Oracle Connection Manager Features
  • Summary
  • Practice Overview
  • Objectives
  • Provisioning New Pluggable Databases
  • Tools
  • Creating a New PDB from PDB$SEED
  • Using the FILE_NAME_CONVERT Clause
  • Using OMF or the PDB_FILE_NAME_CONVERT Parameter
  • Summary
  • Practice Overview
  • Objectives
  • Cloning Regular PDBs 3Migrating Data from a Non-CDB into a CDB
  • Plugging a Non-CDB into CDB Using DBMS_PDB
  • Replicating a Non-CDB into a CDB by Using GoldenGate
  • Cloning a Non-CDB or Remote PDB
  • Using DBCA to Clone a Remote PDB
  • Plugging an Unplugged Regular PDB into CDB
  • Plugging in a PDB Using an Archive File
  • Cloning Remote PDBs in Hot Mode
  • Near-Zero Downtime PDB Relocation
  • Using DBCA to Relocate a Remote PDB
  • Proxy PDB: Query Across CDBs Proxying Root Replica
  • Creating a Proxy PDB
  • Summary
  • Practice Overview
  • Objectives
  • Changing the PDB Mode
  • Modifying PDB Settings
  • Impact of Changing Initialization Parameters
  • Changing Initialization Parameters: Example
  • Using the ALTER SYSTEM Command in a PDB
  • Configuring Host Name and Port Number per PDB
  • Dropping PDBs
  • Summary
  • Practice Overview
  • Objectives
  • Database Storage Architecture
  • Logical and Physical Database Structures
  • Segments, Extents, and Blocks
  • Tablespaces and Data Files
  • Default Tablespaces in a Multitenant Container Database
  • SYSTEM and SYSAUX Tablespaces
  • Types of Segments
  • How Table Data Is Stored
  • Database Block Content
  • Understanding Deferred Segment Creation
  • Controlling Deferred Segment Creation
  • Monitoring Tablespace Space Usage
  • Summary
  • Objectives
  • Creating Tablespaces
  • Creating a Tablespace: Clauses
  • Creating Permanent Tablespaces in a CDB
  • Defining Default Permanent Tablespaces
  • Temporary Tablespaces
  • Altering and Dropping Tablespaces
  • Viewing Tablespace Information
  • Implementing Oracle Managed File (OMF)
  • Enlarging the Database
  • Moving or Renaming Online Data Files
  • Examples: Moving and Renaming Online Data Files
  • Summary
  • Practice Overview
  • Objectives
  • Space Management Features
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Allocating Extents
  • Using Unusable Indexes
  • Using Temporary Tables
  • Creating Global Temporary Tables
  • Creating Private Temporary Tables
  • Table Compression: Overview
  • Table Compression: Concepts
  • Compression for Direct-Path Insert Operations
  • Advanced Row Compression for DML Operations
  • Specifying Table Compression
  • Using the Compression Advisor
  • Resolving Space Usage Issues
  • Reclaiming Space by Shrinking Segments
  • Shrinking Segments
  • Results of a Shrink Operation
  • Managing Resumable Space Allocation
  • Using Resumable Space Allocation
  • Resuming Suspended Statements
  • What Operations Are Resumable?
  • Summary
  • Practice Overview
  • Objectives
  • Undo Data: Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Comparing SHARED Undo Mode and LOCAL Undo Mode
  • Configuring Undo Retention
  • Categories of Undo
  • Guaranteeing Undo Retention
  • Changing an Undo Tablespace to a Fixed Size
  • Temporary Undo: Overview
  • Temporary Undo Benefits
  • Enabling Temporary Undo
  • Monitoring Temporary Undo
  • Summary
  • Practice Overview
  • Objectives
  • Database User Accounts
  • Oracle-Supplied Administrator Accounts
  • Creating Oracle Database Users in a Multitenant Environment
  • Creating Common Users in the CDB and PDBs
  • Creating Schema Only Accounts
  • Authenticating Users
  • Using Password Authentication
  • Using Password File Authentication
  • Using OS Authentication
  • OS Authentication for Privileged Users
  • Assigning Quotas
  • Summary
  • Practice Overview
  • Objectives
  • Privileges
  • System Privileges
  • System Privileges for Administrators
  • Object Privileges
  • Granting Privileges in a Multitenant Environment
  • Granting Privileges: Example
  • Using Roles to Manage Privileges
  • Assigning Privileges to Roles and Assigning Roles to Users
  • Oracle-Supplied Roles
  • Granting Roles in a Multitenant Environment
  • Granting Roles: Example
  • Making Roles More Secure
  • Revoking Roles and Privileges
  • Granting and Revoking System Privileges
  • Granting and Revoking Object Privileges
  • Summary
  • Practice Overview
  • Objectives
  • Profiles and Users
  • Creating Profiles in a Multitenant Architecture
  • Creating Profiles: Example
  • Profile Parameters: Resources
  • Profile Parameters: Locking and Passwords
  • Oracle-Supplied Password Verification Functions
  • Assigning Profiles in a Multitenant Architecture
  • Summary
  • Practice Overvie
  • Objectives
  • Database Security
  • Monitoring for Compliance
  • Types of Activities to be Audited
  • Mandatorily Audited Activities
  • Understanding Auditing Implementation
  • Viewing Audit Policy Information
  • Value-Based Auditing
  • Fine-Grained Auditing
  • FGA Policy
  • Audited DML Statement: Considerations
  • FGA Guidelines
  • Archiving and Purging the Audit Trail
  • Purging Audit Trail Records
  • Summary
  • Practice Overview
  • Objectives
  • Moving Data: General Architecture
  • Oracle Data Pump: Overview
  • Oracle Data Pump: Benefits
  • SQL Loader: Overview
  • Summary
  • Objectives
  • SQL Loader: Review
  • Creating the SQL*Loader Control File
  • SQL*Loader Loading Methods
  • Protecting Against Data Loss
  • SQL*Loader Express Mode
  • Using SQL*Loader to Load a Table in a PDB
  • Summary
  • Practice Overview
  • Objectives
  • Data Pump Export and Import Clients
  • Data Pump Interfaces and Modes
  • Data Pump Import Transformations
  • Using Oracle Data Pump with PDBs
  • Exporting from a Non-CDB and Importing into a PDB
  • Exporting and Importing Between PDBs
  • Full Transportable Export/Import
  • Full Transportable Export/Import: Example
  • Transporting a Database Over the Network: Example
  • Using RMAN to Transport Data Across Platforms
  • RMAN CONVERT Command
  • Transporting Data with Minimum Down Time
  • Transporting a Tablespace by Using Image Copies
  • Determining the Endian Format of a Platform
  • Transporting Data with Backup Sets
  • Transporting a Tablespace
  • Transporting Inconsistent Tablespaces
  • Database Transport: Data Files
  • Transporting a Database
  • Transporting a Database: Conversion
  • Transporting a Database: Example
  • Transporting a Database: Considerations
  • Transporting a Database with Backup Sets
  • Summary
  • Practice Overview
  • Objectives
  • External Tables
  • External Tables: Benefits
  • ORACLE_LOADER Access Driver
  • ORACLE_DATAPUMP Access Driver
  • External Tables
  • Viewing Information About External Tables
  • Summary
  • Practice Overview
  • Objectives
  • Proactive Database Maintenance Infrastructure
  • Automated Maintenance Tasks: Components
  • Predefined Automated Maintenance Task
  • Maintenance Windows
  • Predefined Maintenance Windows
  • Viewing Maintenance Window Details
  • Automated Maintenance Tasks
  • Summary
  • Objectives
  • Configuring Automated Maintenance Tasks
  • Enabling and Disabling Maintenance Tasks
  • Creating and Managing Maintenance Windows
  • Resource Allocations for Automated Maintenance Tasks
  • Changing Resource Allocations for Maintenance Tasks
  • Summary
  • Practice Overview
  • Objectives
  • Performance Management Activities
  • Performance Planning Considerations
  • Database Maintenance
  • Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Configuring Automatic ADDM Analysis at the PDB Level
  • Advisory Framework
  • Performance Tuning Methodology
  • Summary
  • Objectives
  • Server-Generated Alerts
  • Setting Metric Thresholds
  • Reacting to Alerts
  • Alert Types and Clearing Alerts
  • Database Server Statistics and Metrics
  • Performance Monitoring
  • Viewing Statistics Information
  • Monitoring Wait Events
  • Monitoring Sessions
  • Monitoring Services
  • Summary
  • Practice Overview
  • Objectives
  • Process Architecture
  • Process Structures
  • Database Writer Process (DBWn & BWnn)
  • Log Writer Process (LGWR & LGnn)
  • Checkpoint Process (CKPT)
  • System Monitor Process (SMON)
  • Process Monitor Process (PMON)
  • Process Manager (PMAN)
  • Recoverer Process (RECO)
  • Listener Registration Process (LREG)
  • Manageability Monitor Process (MMON)
  • Archiver Processes (ARCn)
  • Interacting with an Oracle Database: Memory, Processes, and Storage
  • Summary
  • Practice Overview
  • Objectives
  • Managing Memory Components
  • Shared Pool
  • Database Buffer Cache
  • Redo Log Buffer
  • Large Pool
  • Java Pool
  • Streams Pool
  • Program Global Area (PGA)
  • Managing Memory Components
  • Efficient Memory Usage: Guidelines
  • Automatic Memory Management
  • Monitoring Automatic Memory Management
  • Automatic Shared Memory Management
  • Understanding Automatic Shared Memory Management
  • Oracle Database Memory Parameters
  • Managing the SGA for PDBs
  • Managing the Program Global Area (PGA)
  • Managing the PGA for PDBs
  • Summary
  • Practice Overview
  • Objectives
  • SQL Tuning Process
  • Oracle Optimizer
  • Optimizer Statistics
  • Optimizer Statistics Collection
  • Setting Optimizer Statistics Preferences
  • Optimizer Statistics Advisor
  • Optimizer Statistics Advisor Report
  • Executing Optimizer Statistics Advisor Tasks
  • SQL Plan Directives
  • Adaptive Execution Plans
  • SQL Tuning Advisor: Overview
  • SQL Access Advisor: Overview
  • SQL Performance Analyzer: Overview
  • Managing Automated Tuning Tasks
  • Summary
  • Practice Overview
Live Online Training (Duration : 40 Hours)    View Sample Class Fee On Request
We Offer :
  • 1-on-1 Public - Select your own start date. Other students can be merged.
  • 1-on-1 Private - Select your own start date. You will be the only student in the class.

4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Group Training
Date On Request
Course Prerequisites
  • Should have an understanding of relational database concepts and good operating system knowledge.
  • Should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL.

 

Request More Information

Add Name and Email Address of participant (If different from you)

FAQ's


Yes, fee excludes local taxes.
Yes, we do.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
  • Remote Labs
Yes, Koenig Solutions is a Oracle Learning Partner
Schedule for Group Training is decided by Koenig. Schedule for 1-on-1 is decided by you.
In 1-on-1 you can select your own schedule, other students can be merged but you select the schedule. Choose 1-on-1 if published schedule do not meet your requirement. If you also want a private session, opt for 1-on-1 Public.
Yes.
No, it is not included.
In both, you choose the schedule. In public, other participants can join, Private other participants want to join.
Yes, course requiring practical include hands-on labs.
You can buy online from the page by clicking on "Buy Now". You can view alternate payment method on payment options page.
Yes, you can pay from the course page and flexi page.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
You can request a refund if you do not wish to enroll in the course.
To receive an acknowledgment of your online payment, you should have a valid email address. At the point when you enter your name, Visa, and other data, you have the option of entering your email address. Would it be a good idea for you to decide to enter your email address, confirmation of your payment will be emailed to you.
After you submit your payment, you will land on the payment confirmation screen. It contains your payment confirmation message. You will likewise get a confirmation email after your transaction is submitted.
We do accept all major credit cards from Visa, Mastercard, American Express, and Discover.
Credit card transactions normally take 48 hours to settle. Approval is given right away; however, it takes 48 hours for the money to be moved.
Yes, we do accept partial payments, you may use one payment method for part of the transaction and another payment method for other parts of the transaction.
Yes, if we have an office in your city.
Yes, we do offer corporate training More details
Yes, we do.
Yes, we also offer weekend classes.
Yes, Koenig follows a BYOL(Bring Your Own Laptop) policy.
It is recommended but not mandatory. Being acquainted with the basic course material will enable you and the trainer to move at a desired pace during classes. You can access courseware for most vendors.
Yes, this is our official email address which we use if a recipient is not able to receive emails from our @koenig-solutions.com email address.
Buy-Now. Pay-Later option is available using credit card in USA and India only.
You will receive the digital certificate post training completion via learning enhancement tool after registration.
Yes you can.
Yes, we do. For details go to flexi
You can pay through debit/credit card or bank wire transfer.
Dubai, Goa, Delhi, Bangalore.
Yes you can request your customer experience manager for the same.
Yes of course. 100% refund if training not upto your satisfaction.

Prices & Payments

Yes of course.
Yes, We are

Travel and Visa

Yes we do after your registration for course.

Food and Beverages

Yes.

Others

Says our CEO-
“It is an interesting story and dates back half a century. My father started a manufacturing business in India in the 1960's for import substitute electromechanical components such as microswitches. German and Japanese goods were held in high esteem so he named his company Essen Deinki (Essen is a well known industrial town in Germany and Deinki is Japanese for electric company). His products were very good quality and the fact that they sounded German and Japanese also helped. He did quite well. In 1970s he branched out into electronic products and again looked for a German name. This time he chose Koenig, and Koenig Electronics was born. In 1990s after graduating from college I was looking for a name for my company and Koenig Solutions sounded just right. Initially we had marketed under the brand of Digital Equipment Corporation but DEC went out of business and we switched to the Koenig name. Koenig is difficult to pronounce and marketeers said it is not a good choice for a B2C brand. But it has proven lucky for us.” – Says Rohit Aggarwal (Founder and CEO - Koenig Solutions)
All our trainers are fluent in English . Majority of our customers are from outside India and our trainers speak in a neutral accent which is easily understandable by students from all nationalities. Our money back guarantee also stands for accent of the trainer.
Medical services in India are at par with the world and are a fraction of costs in Europe and USA. A number of our students have scheduled cosmetic, dental and ocular procedures during their stay in India. We can provide advice about this, on request.
Yes, if you send 4 participants, we can offer an exclusive training for them which can be started from Any Date™ suitable for you.