Oracle Database 19c Administration Track
# Course Title Hours
1 Oracle Database 12c: Introduction to SQL
2 Oracle Database 19c: Administration Workshop
120
3 Oracle Database 19c: Backup & Recovery Workshop
4 Oracle Database 19c: Managing Oracle on Linux for DBAs
1- Oracle Database12c: Introduction to SQL
This Oracle Database: Introduction to SQL training helps you write subqueries, combine
multiple queries into a single query using SET operators and report aggregated data using
group functions. Learn this and more through hands-on exercises.
Learn To:
Understand the basic concepts of relational databases ensure refined code by
developers.
Create reports of sorted and restricted data.
Run data manipulation statements (DML).
Control database access to specific objects.
Manage schema objects.
Manage objects with data dictionary views.
Retrieve row and column data from tables.
Control privileges at the object and system level.
Create indexes and constraints; alter existing schema objects.
Create and query external tables.
Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database
workloads, lower IT costs and deliver a higher quality of service by enabling consolidation
onto database clouds.
Learn Advanced Features of SQL
This course will help you understand the advanced features of SQL. Learning these
features will help you query and manipulate data within the database, use the dictionary
views to retrieve metadata and create reports about their schema objects. Some of the
date-time functions available in the Oracle Database are also covered. This course also
discusses how to use the regular expression support in SQL through expert instruction.
Use Development Tools
The main development tool used in this training is Oracle SQL Developer. SQL*Plus is
available as an optional development tool. This is appropriate for a 10g, 11g and 12c
audience.
Course Bundle
Note: This course is a combination of Oracle Database: SQL Workshop I and Oracle
Database: SQL Workshop II courses.
Objectives
Identify the major structural components of the Oracle Database 12c
Create reports of aggregated data
Write SELECT statements that include queries
Retrieve row and column data from tables
Run data manipulation statements (DML) in Oracle Database 12c
Create tables to store data
Utilize views to display data
Control database access to specific objects
Manage schema objects
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Manage objects with data dictionary views
Write multiple-column sub-queries
Employ SQL functions to retrieve customized data
Use scalar and correlated sub-queries
Create reports of sorted and restricted data
Topics
Introduction
Retrieving Data using the SQL SELECT Statement
Restricting and Sorting Data
Using Single-Row Functions to Customize Output
Using Conversion Functions and Conditional Expressions
Reporting Aggregated Data Using the Group Functions
Displaying Data from Multiple Tables Using Joins
Using Subqueries to Solve Queries
Using the SET Operators
Managing Tables using DML statements
Introduction to Data Definition Language
Introduction to Data Dictionary Views
Creating Sequences, Synonyms, Indexes
Creating Views
Managing Schema Objects
Retrieving Data by Using Subqueries
Manipulating Data by Using Subqueries
Controlling User Access
Manipulating Data
Managing Data in Different Time Zones
2- Oracle Database 19c: Administration Workshop
This course provides detailed information on the architecture of an Oracle Database
instance and database, enabling you to effectively manage your database resources.
You 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.
To provide an acceptable response time to users and manage resources effectively, you
learn how to monitor your database and manage performance.
Objectives
Upon completion of this course, the student should be able to:
Describe Oracle Database architecture
Describe Oracle Database Cloud Service (DBCS) architecture and features
Create and manage DBCS database deployments
Configure the database to support your applications
Manage database security and implement auditing
Implement basic backup and recovery procedures
Move data between databases and files
Employ basic monitoring procedures and manage performance
Topics
Introduction
Oracle Database Architecture
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Accessing an Oracle Database
Managing DBCS Database Deployments
Managing Database Instances
Understanding Oracle Net Services
Administering User Security
Creating PDBs
Creating Master Encryption Keys for PDBs
Creating and Managing Tablespaces
Managing Storage Space
Managing Undo Data
Moving Data
Backup and Recovery Concepts
Backup and Recovery Configuration
Creating Database Backups
Performing Database Recovery
Monitoring and Tuning Database Performance
SQL Tuning
Miscellaneous
3- Oracle Database 19c: Backup & Recovery Workshop
The student begins by gaining a deeper understanding of possibly the most important job
of a DBA - backup and recovery. The concepts and architecture that support backup
and recovery, along with implementation in various ways and situations are covered in
detail. Students gain knowledge of the Recovery Manager (RMAN) command-line
interface for various backup, failure, restore, and recovery scenarios, including data
duplication.
Extensive hands-on practices and workshop scenarios provide the student with
experience in a realistic technical environment. This course includes an interactive
workshop that provide participants with opportunities to diagnose and recover from
several failure scenarios, based on backup and recovery case studies.
After completing this course, students should be able to evaluate their own recovery
requirements and develop an appropriate strategy for backup and recovery procedures.
Versions Supported: 19c, 18c, 12c
Learn To:
Develop appropriate backup and recovery procedures to address your business
needs.
Implement backup and recovery settings and perform backup operations to disk
and tape.
Employ Oracle Database recovery procedures to recover from media and other
failures.
Diagnose and repair data failures.
Use flashback technologies and data duplication to complement backup and
recovery procedures.
Secure the availability of your database by appropriate backup and recovery
strategies.
Benefits
The student benefits by gaining a deeper understanding of possibly the most important
job of a DBA - backup and recovery. The concepts and architecture that support backup
and recovery, along with implementation steps in various ways and situations, are
presented in detail.
Students gain knowledge of the Recovery Manager (RMAN) command-line interface for
various backup, failure, restore, and recovery scenarios, including data duplication.
Objectives
Upon completion of this course, the student should be able to:
Describe the Oracle Database architecture components related to backup and
recovery operations.
Plan effective backup and recovery procedures.
Describe Oracle Database backup methods and recovery operations that can be
used to resolve database failure.
Configure the database for recoverability.
Use Recovery Manager (RMAN) to create backups and perform recovery
operations.
Use the Data Recovery Advisor to diagnose and repair failures.
Use Oracle Flashback Technologies to recover from human error.
Perform an encrypted database backup and restore.
Perform tablespace point-in-time recovery.
Topics
Introduction and Configuration
o Introduction
o Getting Started
o Configuring for Recoverablility
o Using the RMAN Recovery Catalog
Backup
o Backup Strategies and Terminology
o Performing Backups
o Improving Your Backups
o Using RMAN-Encrypted Backups
Recovery
o Diagnosing Failures
o Restore and Recovery Concepts
o Performing Complete Recovery
o Performing Point-in-Time Recovery
o Performing Additional Recovery Operations
Additional Technologies
o Using Flashback Technologies
o Using Flashback Database
o Transporting Data
o Duplicating a Database
o RMAN Troubleshooting and Tuning
Hands-On
o Backup and Recovery Workshop
Terms and Conditions for Public Group:
1. Training Kits: The prices include the Oracle training kits from Oracle.
2. Number of attendees: Group Max 10 attendees
3. Certificates: After completion of course, students will receive a (Certificate of
Completion) from Global academy – Oracle Approved Education Partner.
4. Prices: The prices showed in proposal are in (EGP).
5. Payment: 100% two weeks prior the course start date.
6. Cancelation:
Global academy reserves the right to cancel or reschedule any course with
prior notice due to circumstances beyond its control without any liability on
its part.
Customers will be refunded for cancelled courses which they have already
prepaid upon request.
Cancellation requests must be sent by email at least 4 weeks before the
course start date, otherwise they will not refund the payment.
No course cancellations will be accepted within the 4 weeks before the
course start date.
7. No Show: will be due for payment in full and no refund.
