Language: English
Duration: 120 hours
Awarding Body: Oracle
Versions: 12c, 18c,19c
Exams: 1Z0-082: Oracle Database Administration I
1Z0-083: Oracle Database Administration II
Module 1: SQL Workshop
Course Description
The Oracle Database: Introduction to SQL training course equips participants with the skills to write subqueries, combine multiple queries using SET operators, and report aggregated data through group functions. Through interactive, hands-on exercises, learners gain a foundational understanding of SQL within the Oracle environment.
This course also introduces advanced SQL features that enable users to query and manipulate data effectively. Participants learn how to utilize dictionary views to retrieve metadata and generate reports about schema objects. Additionally, the course covers various date-time functions available in Oracle Database, enhancing the learner’s ability to handle time-based data efficiently
Pre Requisite
None
Course 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
Course Content
- 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
Module 2: Oracle Database 19c: Administration Workshop
Course Description
This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to manage your database resources effectively. 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. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
Pre Requisite
SQL Workshop
Course Objectives
- 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
Course Content
- Introduction
- Exploring the Oracle Database Architecture
- Oracle Software Installation Basics
- Installing Oracle Database Software
- Creating an Oracle Database by Using DBCA
- Oracle Database Management Tools
- Managing the Database Instance
- Configuring the Oracle Network Environment
- Administering User Security
- Managing Database Storage Structures
- Managing Space
- Managing Undo Data
- Managing Data Concurrency
- Implementing Oracle Database Auditing
- Backup and Recovery Concepts
- Backup and Recovery Configuration
- Performing Database Backups
- Performing Database Recovery
- Moving Data
- Performing Database Maintenance
- Managing Performance
- Oracle Database Cloud Service: Overview
Module 3: Oracle Database 19c: Backup and Recovery
Course Description
In this course, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.
Pre Requisite
- Knowledge of SQL and PL/SQL
- Knowledge of Oracle Database 19c Administration I
Course Objectives
- 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.
Course Content:
- Introduction
- Getting Started
- Configuring for Recoverability
- Using the RMAN Recovery Catalog
- Backup Strategies and Terminology
- Performing Backups
- Improving Your Backups
- Using RMAN-Encrypted Backups
- Diagnosing Database Failures
- Restore and Recovery Concepts
- Performing Recovery, Part 1
- Performing Recovery, Part 2
- RMAN and Oracle Secure Backup
- Performing Tape Backups and Restores
- Using Flashback Technologies
- Using Flashback Database
- Managing Backup Space or Transporting Data
- Duplicating a Database
