After completing the in class portion, you will receive an email to access the Hands on University course. The Hands on University course is "On Demand" and accessible for 90 days. This class must be completed within the 90 days for you to become DBA certified.

With Oracle Database 12c, you will experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Oracle Database 12c: Installation and Administration

Course Outline

With Oracle Database 12c, you will experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c certifications emphasize the full set of skills that DBAs need in today's competitive marketplace.

Exam 1Z0-062 - Oracle Database 12c: Installation and Administration2

Oracle Database Administration

Exploring the Oracle Database Architecture

List the architectural components of Oracle Database

Explain the memory structures

Describe the background processes

Explain the relationship between logical and physical storage structures

Oracle Database Management Tools

Use database management tools

Oracle Database Instance

Understand initialization parameter files

Start up and shut down an Oracle database instance

View the alert log and access dynamic performance views

Configuring the Oracle Network Environment

Configure Oracle Net Services

Use tools for configuring and managing the Oracle network

Configure client-side network

Configure communication between databases

Managing Database Storage Structures

Describe the storage of table row data in blocks

Create and manage tablespaces

Administering User Security

Create and manage database user accounts

Grant and revoke privileges

Create and manage roles

Create and manage profiles

Managing Space

Explain how Oracle database server automatically manages space

Save space by using compression

Proactively monitor and manage tablespace space usage

Use the Segment Advisor

Reclaim wasted space from tables and indexes by using the segment shrink functionality

Manage resumable space allocation

Managing Undo Data

Explain DML and undo data generation

Monitor and administer undo data

Describe the difference between undo data and redo data

Configure undo retention

Managing Data Concurrency

Describe the locking mechanism and how Oracle manages data concurrency

Performing Post-Upgrade Tasks

Migrating Data by Using Oracle Data Pump

Oracle SQL Expert

Course Outline

Oracle Database SQL Certified Experts demonstrate the complete set of skills required for working with the powerful SQL programming language and have mastered the key concepts of a relational database. SQL Experts understand how to use the advanced features of SQL in order to query and manipulate data within the database, control privileges at the object and system level, and use advanced querying and reporting techniques. They are able to manipulate large data sets and understand storing and retrieving dates according to different time zones. They are also knowledgeable about the concepts of controlling access and privileges for schema objects.

Exam 1Z0-071 - Oracle Database SQL Expert

Course Outline

Retrieving Data Using the SQL SELECT Statement

List the capabilities of SQL SELECT statements

Execute a basic SELECT statement

Describe how schema objects work

Restricting and Sorting Data

Limit the rows that are retrieved by a query

Sort the rows that are retrieved by a query

Using Single-Row Functions to Customize Output

Describe various types of functions that are available in SQL

Use character, number, and date functions in SELECT statements

Describe the use of conversion functions

Reporting Aggregated Data Using the Group Functions

Identify the available group functions

Describe the use of group functions

Group data by using the GROUP BY clause

Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

Write SELECT statements to access data from more than one table using equijoins and nonequijoins

Join a table to itself by using a self-join

View data that generally does not meet a join condition by using outer joins

Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

Define subqueries

Describe the types of problems that subqueries can solve

List the types of subqueries

Write single-row and multiple-row subqueries

Using the Set Operators

Describe set operators

Use a set operator to combine multiple a single query

Control the order of rows returned

Manipulating Data

Describe each data manipulation language (DML) statement

Insert rows into a table

Update rows in a table

Delete rows from a table

Control transactions

Using DDL Statements to Create and Manage Tables

Categorize the main database objects

Review the table structure

List the data types that are available for columns

Create a simple table

Explain how constraints are created at the time of table creation

Creating Other Schema Objects

Create simple and complex views

Retrieve data from views

Create, maintain, and use sequences

Create and maintain indexes

Create private and public synonyms

Managing Objects with Data Dictionary Views

Use the data dictionary views to research data on your objects

Query various data dictionary views

Controlling User Access

Differentiate system privileges from object privileges

Grant privileges on tables

View privileges in the data dictionary

Grant roles

Distinguish between privileges and roles

Managing Schema Objects

Add constraints

Create indexes

Create indexes using the CREATE TABLE statement

Creating function-based indexes

Drop columns and set column UNUSED

Perform FLASHBACK operations

Create and use external tables

Manipulating Large Data Sets

Manipulate data using subqueries

Describe the features of multitable INSERTs

Use the following types of multitable INSERTs (Unconditional, Conditional and Pivot)

Merge rows in a table

Track the changes to data over a period of time

Generating Reports by Grouping Related Data

Use the ROLLUP operation to produce subtotal values

Use the CUBE operation to produce crosstabulation values

Use the GROUPING function to identify the row values created by ROLLUP or CUBE