Oracle Database 12c: SQL Fundamentals I

• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• 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 with the SELECT statement
• Run data manipulation statements (DML) to update data in the Oracle Database 12c
• Create tables to store data
• Utilize views to display and retrieve data
• Write multiple-column sub-queries
• Use scalar and correlated sub-queries Use
• the regular expression support in SQL
• Create reports of sorted and restricted data

Oracle Database 12c: Admin, Install and Upgrade Accelerated

• Install Oracle Database 12c software
• Upgrade database to Oracle Database 12c
• Create an Oracle Database
• Create a container database
• Monitor the Database
• Manage Database Performance
• Implement Database Auditing
• Configure the Database Instance Such That Resources Are Appropriately Allocated Among Sessions and Tasks
• Schedule Jobs to Run Inside or Outside of the Database
• Configure Oracle Net Services
• Configure your Database For Backup and Recovery Operations
• Describe Oracle Database Architecture
• Manage the Oracle Database Instance
• Manage Oracle Database Storage structures

Oracle Database 12c: Backup and Recovery Workshop

• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
• Describe the Oracle Database architecture components related to backup and recovery operations.
• Plan effective backup and recovery procedures.
• 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.
• Describe additional high availability features such as Oracle Data Guard.

Oracle Database 12c: Managing Multitenant Architecture

• Manage the multitenant container database and pluggable databases performance
• Configure resource manager to share resources within a multitenant container database between
• containers and within a pluggable database
• Implement unified auditing in a multitenant container database and its pluggable databases
• Use Oracle Data Pump, SQL*Loader in pluggable databases
• Monitor the multitenant container database and pluggable databases
• Describe the multitenant architecture
• Create a multitenant container database
• Create a pluggable database using different methods
• Plug a non-CDB into a multitenant container database
• Manage multitenant container databases and pluggable databases
• Administer multitenant container database and pluggable database storage structures
• Create and administer common and local user accounts
• Manage common and local privileges and roles
• Configure multitenant container databases and pluggable databases backup and recovery operations