0

  • An empty cart

    You have no item in your shopping cart

0

  • An empty cart

    You have no item in your shopping cart

WCC -

Enter your keyword

Oracle 11g OCA Certification Training Course

Oracle 11g OCA Certification Training Course

Course Overview

Oracle 11g Database certified will broaden your knowledge and skills by exposing you to a variety of important database features, functions and tasks. Oracle Database certification will teach you how to perform complex, hands-on activities through labs, study and practice. Oracle certification exams will validate your capabilities using real-world, scenario-based questions that will assess and challenge your ability to think and perform.  Our course will not only teach you the skills to make you a oracle database specialist, but also will prepare you for the Oracle Certified Associate level exams.

COURSE START DATES

Start DateTimeDaysDurationLocation
05/05/202018.00-21.00Tue/Thu10 ClassesBrentford
25/08/202018.00-21.00Tue/Thu10 ClassesBrentford
15/12/202018.00-21.00Tue/Thu10 ClassesBrentford
23/03/202118.00-21.00Tue/Thu10 ClassesBrentford

Prerequisites

  • Basic Database fundamental
  • Basic SQL
  • Database design

Target Audience

  • Programmers
  • Forms Developer
  • Functional Implementer
  • Portal Developer
  • Technical Consultant
  • Reports Developer
  • End Users
  • Application Developers
  • PL/SQL Developer

Course Content

Oracle Database/ SQL Expert: Exam 1Z0-147
Introduction to Oracle SQL

  • Relational Database Systems
  • Testing SQL
  • SQL Developer and SQL Plus
  • Testing the Database and Schema

Select Statements

  • Basic Select Statements
  • Selecting Columns and Using Arithmetic Operators
  • Operator Precedence
  • Concatenation Operator
  • Displaying the Table Structure

Where and Order By Clauses

  • Implementing the Where Clause
  • Comparison Operators
  • Logical Operators
  • Rules of Precedence
  • Substitution Variables

Functions

  • Types of Single Row Functions
  • Working with Dates
  • Types of Group Functions
  • Creating Groups of Data
  • Multi Column Grouping

Joins

  • Natural Joins
  • Nonequijoins and Outer Joins
  • Cartesian Joins

Sub-Queries

  • Single Row Subqueries
  • Multiple Row Subqueries
  • Null Values

Set Operators

  • Union and Union All Operators
  • Intersect and Minus Operators
  • Select Statements and the Order By Clause

Oracle OCA Exam 1Z0-152
Database Architecture

  • Architectural Components of the Oracle Database
  • Memory Structures
  • Server and Background Processes
  • Logical and Physical Storage Structures

Installing the Oracle Software

  • Database Administrator Tasks and Tools
  • Planning a Oracle Database Installation
  • Using Optimal Flexible Architecture
  • Installing the Oracle Software using OUI

Creating an Oracle Database & Instance

  • Planning for Database Creation
  • Configuring the Listener
  • Creating a Database
  • Starting and Stopping the Oracle Database
  • Using the Oracle Enterprise Manager
  • Access a Database with SQL*Plus
  • Modify Database Initialization Parameters
  • Database Startup
  • Database Shutdown
  • Viewing the Alert Log and Dynamic Performance Views

Oracle Network Environment

  • Creating and Configuring Additional Listeners
  • Creating Oracle Net Service Aliases
  • When to Use Shared and Dedicated Servers

Database Storage Structures

  • Describe Table Row Data and Define Tablespaces
  • Creating and Managing Tablespaces
  • Automatic Storage Management

User Security

  • Create and Manage User Accounts
  • Grant and Revoke Privileges
  • Create and Manage Roles
  • Create and Manage Profiles

Schema ObjectsM

  • Defining Schema Objects and Data Types
  • Creating and Modifying Tables
  • Defining Constraints
  • Viewing Columns and Contents of a Table
  • Creating Indexes
  • Creating Views
  • Creating Sequences
  • Using Temporary Tables

Data and Concurrency

  • Managing data Using SQL
  • Identifying and Administering PL/SQL Objects
  • Monitoring and Resolving Locking Conflicts
  • Implementing Undo Data
  • Working with Undo Data

Security

  • DBA Security and Privileges
  • Enabling Auditing
  • Audit Options and Information
  • Fine Grained Auditing
  • Auditing the DBA and Maintaining the Audit Trail

Maintenance & Oracle Performance

  • Managing Optimizer Statistics
  • Managing Automatic Workload Repository
  • Using the Automatic Database Diagnostic Monitor
  • Setting Alerts and Thresholds
  • Performance Monitoring with the Enterprise Manager
  • Using Automatic Memory Management
  • Viewing Performance Related Dynamic Views
  • Troubleshooting invalid and Unusable Objects

Backup and Recovery

  • Types of Database Failure
  • Checkpoints| Redo Log Files| and Archive Log Files
  • Instance Recovery
  • Configuring for Recoverability
  • Configuring Archive Log Mode
  • Database Backups
  • Backup Solutions Overview
  • Configuring Backup Settings
  • Scheduling Backups
  • Backing up Control Files to a Trace File
  • Managing Backups and the Flash Recovery Area
  • Using the RMAN Command Line
  • Recovering From a Lost Control File
  • Recovering Redo Log Files
  • Recovering Non Critical and Critical Data Files
  • Using the Data Recovery Advisor

Moving Data

  • Moving Data and Creating Directory Objects
  • Loading Data with the SQL Loader
  • Creating and Reading External Tables
  • Using Oracle Data Pump Export and Import
  • Data Pump Performance and Monitoring

Database Maintenance

  • Using the Enterprise Manager Support Workbench
  • Metalink Integration and Managing Patches
  • Monitoring index partition usage
  • Rebuilding unusable indexes

Reviews Statistic

0
0 out of 0
0 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

Reviews

There are no reviews yet.

Be the first to review “Oracle 11g OCA Certification Training Course”

Duration 10 Classes
Price £990.00

Start Date *

Share our course