0
SUBTOTAL :
empty cartcheckout
Oracle Database Administration – OCP/OCA Certification Course

Oracle Database Administration – OCP/OCA Certification Course

Size
Price:
Add to CartProduct Added View Cart Checkout

Read more

 

2Month/20 Hours                                                  Price:35,000

                                                                                      30,000

Oracle Database Administration  OCP/OCA 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 data files

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

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

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

Oracle Job Interview Preparation


Job Interview Preparation  (Questions & Answers)


Tough Open-Ended Job Interview Questions

What to Wear for Best Job Interview Attire

Job Interview Question- What are You Passionate About?

How to Prepare for a Job Promotion Interview


Stay Connected Even When You’re Apart

Join our WhatsApp Channel – Get discount offers

 500+ Free Certification Exam Practice Question and Answers

 Your FREE eLEARNING Courses (Click Here)

Internships, Freelance and Full-Time Work opportunities

 Join Internships and Referral Program (click for details)

Work as a Freelancer or Full-Time Employee (click for details)

Hire an Intern


Flexible Class Options

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




0 Reviews

Contact form

Name

Email *

Message *