linkedin

Home - Courses - IT Academy - postTitle –

 

Oracle Data Base & Developer Certification Training Course

Oracle Certified Associate (OCA) certification students must take and pass the Oracle Database 11g: SQL Fundamentals (1Z0-051) and Oracle Database 11g: Administration I (1Z0-052) exams, and for the Oracle Certified Professional (OCP) certification students must additionally pass the Oracle Database 11g: Administration II (1Z0-053) exam.

  • About the Course
  • Certification Body
  • Download Brochure

Course 1: Oracle Database Certification program

Overview of Oracle Data Base Certification Program

The Oracle data base tutorial would teach the Oracle Certified Associate (OCA) certification students must take and pass the Oracle Database 11g: SQL Fundamentals (1Z0-051) and Oracle Database 11g: Administration I (1Z0-052) exams, and for the Oracle Certified Professional (OCP) certification students must additionally pass the Oracle Database 11g: Administration II (1Z0-053) exam.

To know about Oracle Data Base Platform: Click here

logo

Learning Outcome of Oracle Data Base Certification training:

The Oracle data base tutorial learning outcome given below:

  • Produce procedural programs using PL/SQL
  • Perform transactions using PL/SQL.
  • Manipulate data using advanced techniques including nested functions
  • Install Oracle Grid Infrastructure.
  • Create and manage users.
  • Install and configure an Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Understand the Oracle database architecture & how its
  • components work and interact with one another.
  • Perform backup and recovery.

Who needs the Oracle Database Certification Program?

The oracle data base tutorial is suitable for technical personnel involved in the development and maintenance of Oracle applications and databases and also who need to learn how to administrate and maintain Oracle 11g Databases.

The Oracle data base tutorial most beneficent for professionals and those have a beginners in  this career, learn oracle data base (DBA) from experts.

Detailed Course Content:

In this course, students learn how to design and build a variety of standard and custom Web and
paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative
environment of Reports Builder, students learn how to retrieve, display, and format data from
any data source in numerous reporting styles and publish the output to any destination.

During the course, students learn how to add dynamic content to a static Web page and publish
reports to the Web. Students also learn how to customize more complex reports, embed graphical
charts, and use OracleAS Reports Services to deploy your reports.

USE SUB-QUERIES TO SOLVE QUERIES

  • Use a Sub query to Solve a Problem
  • Execute Single-Row Sub-queries
  • Deploy Group Functions in a Sub-query
  • Multiple-Row Sub queries
  • Use ANY and ALL Operator in Multiple-Row Sub-queries
  • Use EXISTS Operator

SET OPERATORS

  • What are SET operators?
  • Use a SET operator to combine multiple queries into
    a single query
  • Use UNION, UNION ALL, INTERSECT & MINUS Operator
  • Use ORDER BY Clause in Set Operations

DATA MANIPULATION

  • Add New Rows to a Table
  • Change the Data in a Table
  • Use DELETE and TRUNCATE Statements
  • Save and discard changes with the COMMIT & ROLLBACK statements
  • Implement Read Consistency
  • Describe the FOR UPDATE Clause

USE DDL STATEMENTS TO CREATE AND MANAGE TABLES

  • Categorize Database Objects
  • Create Tables using the CREATE TABLE Statement
  • Create a table using a sub query
  • Identify the data types
  • Describe Constraints
  • How to alter a table?
  • Drop a table

OTHER SCHEMA OBJECTS

  • Create, modify, and retrieve data from a view
  • Perform Data manipulation language (DML) operations on a view
  • Create, use, and modify a sequence
  • Create and maintain indexes
  • Create and drop synonyms
  • Drop a view

The Oracle Data Base Tutorial covers difference  specific product, service and  technology training some portions are mentioned below:

  • EXPLORING THE ORACLE DATABASE ARCHITECTURE
  • INSTALLING YOUR ORACLE SOFTWARE
  • CREATING AN ORACLE DATABASE
  • MANAGING THE ORACLE DATABASE INSTANCE
  • MANAGE THE ASM INSTANCE
  • CONFIGURING THE ORACLE NETWORK ENVIRONMENT
  • MANAGING DATABASE STORAGE STRUCTURES
  • MANAGING UNDO DATA
  • ADMINISTERING USER SECURITY
  • MANAGING DATA CONCURRENCY
  • IMPLEMENTING ORACLE DATABASE AUDITING
  • DATABASE MAINTENANCE
  • PERFORMANCE MANAGEMENT
  • BACKUP AND RECOVERY CONCEPTS
  • PERFORMING DATABASE BACKUPS
  • PERFORMING DATABASE RECOVERY
  • MOVING DATA
  • WORKING WITH SUPPORT

PART II: ADMINISTRATION I

EXPLORING THE ORACLE DATABASE ARCHITECTURE

  • Oracle Database Architecture Overview
  • Oracle ASM Architecture Overview
  • Process Architecture
  • Memory structrues
  • Logical and physical storage structures
  • ASM storage components

INSTALLING YOUR ORACLE SOFTWARE

  • Tasks of an Oracle Database Administrator
  • Tools Used to Administer an Oracle Database
  • Installation: System Requirements
  • Oracle Universal Installer (OUI)
  • Installing Oracle Grid Infrastructure
  • Installing Oracle Database Software
  • Silent Install

CREATING AN ORACLE DATABASE

  • Planning the Database
  • Using the DBCA to Create a Database
  • Password Management
  • Creating a Database Design Template
  • Using the DBCA to Delete a Database

MANAGING THE ORACLE DATABASE INSTANCE

  • Start and stop the Oracle database and components
  • Use Oracle Enterprise Manager
  • Access a database with SQLPlus
  • Modify database installation parameters
  • Describe the stages of database startup
  • Describe database shutdown options
  • View alert log
  • Access dynamic performance views

MANAGE THE ASM INSTANCE

  • Set up initialization parameter files for ASM instance
  • Start up and shut down ASM instances
  • Administer ASM disk groups

CONFIGURING THE ORACLE NETWORK ENVIRONMENT

  • Use Enterprise Manager to create & configure the
    Listener
  • Enable Oracle Restart to monitor the listener
  • Use tnsping to test Oracle Net connectivity
  • Identify when to use shared servers & when to use dedicated
    servers

MANAGING DATABASE STORAGE STRUCTURES

  • Storage Structures
  • How Table Data Is Stored
  • Anatomy of a Database Block
  • Space Management in Tablespaces
  • Actions with Tablespaces
  • Oracle Managed Files (OMF)
  • Tablespaces in the Preconfigured Databa

MANAGING UNDO DATA

  • Data Manipulation
  • Transactions & Undo Data
  • Configuring Undo Retention
  • Undo Data Versus Redo Data

ADMINISTERING USER SECURITY

  • Predefined Administrative Accounts
  • Database User Accounts
  • Predefined Roles
  • Benefits of Roles
  • Implementing Profiles

MANAGING DATA CONCURRENCY

  • Data Concurrency
  • Enqueue Mechanism
  • Resolving Lock Conflicts
  • Deadlocks

IMPLEMENTING ORACLE DATABASE AUDITING

  • Describe DBA responsibilities for security
  • Enable standard database auditing
  • Specify audit options
  • Review audit information
  • Maintain the audit trail

DATABASE MAINTENANCE

  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Manage optimizer statistics
  • Use automated tasks
  • Set alert thresholds
  • Use server-generated alerts

PERFORMANCE MANAGEMENT

  • Invalid and Unusable Objects
  • Enabling Automatic Memory Management
  • Performance Monitoring
  • Managing Memory Components
  • Automatic Shared Memory Advisor
  • Using Memory Advisors
  • Dynamic Performance Statistics
  • Troubleshooting and Tuning Views

BACKUP AND RECOVERY CONCEPTS

  • Understanding Instance Recovery
  • Part of Your Job
  • Statement Failure
  • Phases of Instance Recovery
  • Using the MTTR Advisor
  • User Error
  • Media Failure
  • Archive Log Files

PERFORMING DATABASE BACKUPS

  • Oracle Secure Backup
  • Terminology
  • Backup Solutions: Overview
  • User-Managed Backup
  • Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Backing Up the Control File to a Trace File
  • Monitoring the Flash Recovery Area

PERFORMING DATABASE RECOVERY

  • Opening a Database
  • Data Recovery Advisor Loss of a Control File
  • Loss of a Redo Log File
  • Data Recovery Advisor
  • Data Failures Listing Data Failures
  • Data Recovery Advisor Views

MOVING DATA

  • Describe ways to move data
  • Create and use directory objects
  • Use SQL*Loader to move data
  • Use external tables to move data
  • General architecture of Oracle Data Pump
  • Use Data Pump export and import to move data

WORKING WITH SUPPORT

  • Use the Enterprise Manager Support Workbench
  • Work with Oracle Support
  • Log service requests (SR)
  • Manage patches

Course 2: Oracle Forms and Reports Developer 2000

Course Modules:

Module 1 Oracle 11g: program with PL/SQL
Module 2 Oracle Forms Developer: Build Internet applications
Module 3 Oracle Reports Developer 10g: Build Reports

Module 1: Oracle Database 11g PL/SQL Programming

Design Feature-Rich PL/SQL Applications

Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You’ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance.

  • Create, debug, and manage Oracle-driven PL/SQL programs
  • Use PL/SQL structures, delimiters, operators, variables, and statements
  • Identify and eliminate errors using PLSQL_WARNINGS and exception handlers
  • Work with functions, procedures, packages, collections, and triggers
  • Define and deploy varray, nested table, and associative array data types
  • Handle external routines, object types, large objects, and secure files
  • Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE
  • Call external procedures through Oracle Net Services and PL/SQL wrappers
  • Integrate internal and server-side Java class libraries using Oracle JVM
  • Develop robust Web applications using PL/SQL Gateway and Web Toolkit

Module 2: Oracle Forms Developer 2000- Build Internet Applications

Learning Outcome:

Leverage your investment by taking advantage of web technologies to easily and quickly
construct sophisticated database forms and business logic with minimal effort. This course
focuses on teaching students to use Oracle Forms Developer 10g (10.1.2.0.2) to rapidly build
scalable, high-performance applications for the Internet.

In this course students build, test, debug, and deploy interactive Internet applications. Working in
a graphical user interface (GUI) environment, they develop an order entry application from the
ground up. This application incorporates several advanced features that provide a rich user
experience while implementing business rules.

This course counts towards the Hands-on course requirement for the Oracle Forms Developer
Certified Professional Certification. Only instructor-led inclass or instructor-led online formats
of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and
Knowledge Center courses are excellent study and reference tools but DO NOT meet the Handson
Requirement for certification.

Learn To:

  • Customize forms with user input items such as check boxes, list items, radio groups,
    and Pluggable Java Components
  • Integrate Java into Forms applications by using JavaBeans
  • Control navigation, data access, validation, and transactions by creating event-related
    triggers
  • Enable Forms applications running on the Web to access files and applications on the
    client computer
  • Display Forms elements and data in multiple canvases and windows
  • Deploy Forms applications to the Web

Who needs the course?

  • Application Developers
  • Developer
  • Forms Developer
  • PL/SQL Developer
  • Support Engineer
  • Technical Consultant

Prerequisites:

  • A good familiarity with Graphical User Interface (GUI)
  • Working experience with the Web browser
  • Oracle Database 11g: Introduction to SQL
  • Oracle Database 11g: Program with PL/SQL
  • Oracle Database 11g: Develop PL/SQL Program Units

Detailed Course Content:

  • Introducing Oracle Forms Developer and Forms Services
  • Creating Forms Modules
  • Working with Data Blocks and Frames
  • Working with Input Items
  • Working with Non Input Items
  • Working with Windows and Canvases
  • Producing Triggers
  • Debugging Triggers
  • Adding Functionality to Items
  • Run-Time Messages and Alerts
  • Query Triggers
  • Validation
  • Navigation

Module3: Oracle Reports Developer : Build Reports

Learning Outcome:

In this course, students learn how to design and build a variety of standard and custom Web and
paper reports using Oracle Reports Developer (9.0.4.0.1). Working in the declarative
environment of Reports Builder, students learn how to retrieve, display, and format data from
any data source in numerous reporting styles and publish the output to any destination.

During the course, students learn how to add dynamic content to a static Web page and publish
reports to the Web. Students also learn how to customize more complex reports, embed graphical
charts, and use OracleAS Reports Services to deploy your reports.

Who needs the course?

Technical Consultant
Reports Developer
Business Intelligence Developer

Detailed Course Content:

  • Introduction to Oracle Reports Developer
  • Designing and Running Reports
  • Working in Oracle Reports Developer
  • Creating a Paper Report
  • Enhancing a Basic Paper Report
  • Managing Report Templates
  • Creating a Web Report
  • Enhancing Reports Using the Data Model: Queries and Groups
  • Enhancing Reports Using the Data Model: Data Sources
  • Enhancing Reports Using the Data Model: Creating Columns
  • Enhancing Reports Using the Paper Layout
  • Controlling the Paper Layout: Common Properties
  • Controlling the Paper Layout: Specific Properties
  • Web Reporting
  • Extending Functionality Using XML
  • Creating and Using Report Parameters
  • Embedding a Graph in a Report
  • Enhancing Matrix Reports
  • Coding PL/SQL Triggers
  • Extending Functionality Using the SRW Package
  • Maximizing Performance Using OracleAS Reports Services
  • Building Reports: Efficiency Guidelines

About Certification and Awarding Body

KHDA Certificate :

Course completion certificate attested by KHDA(Knowledge and Human Development Authority, UAE)

The Knowledge and Human Development Authority (KHDA) is responsible for the growth and quality of private education in Dubai. We support schools, universities, parents, students, educators, investors and government partners to create a high quality education sector focused on happiness and well being.

Title : ORACLE DBA / ORACLE DEVELOPER

For application process, please contact us.

Kindly fill the below details to download the Brochure

whatsaapnow
Quick Enquiry