Oracle Database Administration 11g/12c Fundamentals

Oracle Database 11g/12c OCP Certification Course

The goal of this Oracle Database 11g/12c DBA program training is to help students to became a Database Administrators by passing OCP certification exam, students will learn how to install the Oracle Database software and perform the tasks required to manage an Oracle database. Enterprise Manager is used exclusively throughout to teach you how to quickly accomplish the required task. This course designed as per the Hands-on course guidelines of Oracle DBA track for maximum benefits of students.

Complete Oracle Database Administration (DBA All-in-One Course) – with FREE Practice Exams

OCP Exam Number: 1Z0-051 – Oracle Database 11g: SQL Fundamentals I
OCP Exam: 1Z0-052 – Oracle Database 11g: Administration I
OCP Exam: 1Z0-053 – Oracle Database 11g: Administration II

1Z0-051 – Oracle Database 11g: SQL Fundamentals I

Retrieving Data Using the SQL SELECT Statement

List of SQL SELECT statements
Execute SELECT statements
Restricting and Sorting Data with clauses

Limit the rows using Select Statement

Sort the rows retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output

Types of functions available in SQL

Use character, number, and date functions in SELECT statements
Using Conversion Functions and Conditional Expressions

Conversion functions that are available in SQL

Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions

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

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

Subqueries with SQL Statement
Types of subqueries
Single-row and multiple-row subqueries
Set Operators

Set operators

Set operator to combine multiple queries into a single query
Control the order of rows returned
Manipulating Data

Data manipulation language (DML) statement

Insert rows, Update rows, Delete rows into a table
Control transactions
Using DDL Statements to Create and Manage Tables

Categorize database objects

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
Schema objects
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

1Z0-052 – Oracle Database 11g: Administration I

Oracle Database Architecture

Oracle 11g Database Memory Structures
Oracle Database Process Structures
Overview of Storage Structures
Oracle Database Environment

Tools for Administering an Oracle Database

Oracle Database installation
Install the Oracle software by using Oracle Universal Installer (OUI)
Creating an Oracle Database
Create a database by using the Database Configuration Assistant (DBCA)
Managing the Oracle Instance

Setting database initialization parameters

Stages of database startup and shutdown
Alert log and trace files
Using data dictionary and dynamic performance views
Configuring the Oracle Network Environment

Configure and Manage the Oracle Network

Oracle Shared Server architecture
Managing Database Storage Structures

Tablespace and datafiles

Create and manage tablespaces
Space management in tablespaces
Administering User Security

Create and manage database user accounts

Grant and revoke privileges
Create and manage roles
Create and manage profiles
Managing Data and Concurrency

Monitor and resolve locking conflicts

Managing Undo Data

Overview of Undo Data and Transaction

Transactions and undo data
Managing undo
Implementing Oracle Database Security

Database Security and Principle of Least Privilege

Work with Standard Database Auditing
Database Maintenance

Use and manage optimizer statistics

Automatic Workload Repository (AWR)
Use advisory framework
Manage Alerts and Thresholds
Performance Management

Automatic Memory Management

Use Memory Advisors
Troubleshoot invalid and unusable objects
Intelligent Infrastructure Enhancements

Enterprise Manager Support Workbench

Managing Patches
Backup and Recovery Concepts

Failure that can occur in an Oracle database

Tune instance recovery
Checkpoints, redo log files, and archived log files
Flash recovery area
Configure ARCHIVELOG mode
Performing Database Backups

Create consistent database backups

Back up your database without shutting it down
Create incremental backups
Automate database backups
Manage backups, view backup reports and monitor the flash recovery area
Performing Database Recovery

Data Recovery Advisor

Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
Moving Data

Move data (Directory objects, SQL*Loader, External Tables)

General architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases

1Z0-053 – Oracle Database 11g: Administration II

Database Architecture and ASM

Describe Automatic Storage Management (ASM)
Set up initialization parameter files for ASM and database instances
Start up and shut down ASM instances
Administer ASM disk groups
Configuring for Recoverability

Configure multiple archive log file destinations to increase availability

Define, apply and use a retention policy
Configure the Flash Recovery Area
Use Flash Recovery Area
Using the RMAN Recovery Catalog

RMAN recovery catalog

Create and configure a recovery catalog
Synchronize the recovery catalog
Create and Use RMAN stored scripts
Back up the recovery catalog
Create and use a virtual private catalog
Configuring Backup Specifications

Configure backup settings

Allocate channels to use in backing up
Configure backup optimization
Using RMAN to Create Backups

Create image file backups

Create a whole database backup
Enable fast incremental backup
Create duplex backup and back up backup sets
Create an archival backup for long-term retention
Create a multisection, compressed and encrypted backup
Report on and maintain backups
Performing User-Managed Backup and Recovery

Perform complete recovery from a critical or noncritical data file loss using RMAN

Perform incomplete recovery using RMAN
Recover using incrementally updated backups
Switch to image copies for fast recovery
Restore a database onto a new host
Recover using a backup control file
Perform Disaster recovery
Using RMAN to Duplicate a Database

Target Audience

Students will to start Career in Database Admin
Database Administrators / Business Analyst
Functional Analyst
Technical Developers

🥇 Pass Oracle Database Exams

🎥 Your Team FREE eLEARNING Courses (Click Here)

International Student Fee : 500$ | 1,875 AED | 1,875 SAR (Discounts available for Group)

Find Oracle DBA Jobs and Salaries (click on URL)

Oracle Job Interview Preparation

International Student Fee : 300$

Flexible Class Options

Corporate Training | Evening Classes | | Fast-Track
Week End Classes For Professionals SAT | SUN
Online Classes – Live Virtual Class (L.V.C), Online Training

Recommended Courses (Advanced Certification Tracks)

Oracle Database 11g Admin-I DBA Training Course
Oracle Database 11g Admin-II DBA Training Course
Oracle Database 11g SQL Fundamentals

Oracle BI 11g : OBIEE – Build Repository
Oracle BI 11g : OBIEE – Create Analyses and Dashboards
Oracle Forms Developer Course – Build Internet Applications

Oracle APEX – Application Express

Oracle ERP Implantation & Support Services

Need Oracle ERP E-Business Suite | Fusion Cloud Implementation Services
[/vc_column_text]

Oracle Database Administration – OCP/OCA Certification Course