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

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

🥇 Pass Oracle Database Exams

• SQL Fundamentals (Click FREE Exam Practice Exam Questions)
• Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-I
• Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-II
• Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-III
• Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-IV
• Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-V
• Oracle Database 12c: SQL Fundamentals – (Course: 1z0-061 Exam) Part-V
• Oracle DataBase 11g: Administration I Oracle 1z0-051 Exam PART 1
• Oracle DataBase 11g: Administration I Oracle 1z0-051 Exam PART 2
• Oracle DataBase 11g: Administration I Oracle 1z0-051 Exam PART 3
• Oracle DataBase 11g: Administration I Oracle 1z0-052 Exam PART 1
• Oracle DataBase 11g: Administration I Oracle 1z0-052 Exam PART 2
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-I
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-II
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-II
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-III
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-IV
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-V
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-VI
• Oracle Database 11g Administration II (Course: 1z0-053 Exam) Part-VII

Find Oracle DBA Jobs and Salaries (click on URL)

• Oracle DBA Jobs in Dubai
• Oracle DBA Jobs in Saudi Arabia 
• Oracle DBA Jobs in Pakistan
• Oracle DBA Jobs in UK
• Oracle DBA Jobs in Canada

Oracle Job Interview Preparation

Oracle DBA Interview Questions and Answers

Oracle Fusion Cloud Technical Interview Questions

Oracle Fusion Cloud Techno Functional Interview Questions

Oracle Fusion Financials Cloud Interview Questions

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]