This Oracle training syllabus is designed for Oracle 11g. However, we revise our curriculum with newer versions of Oracle. Oracle defines its certification into three major categories.
Oracle Certified Associate certification track covers two of the following areas: SQL Programming and Database Administration. To get this certification, one needs to pass the following examination.
Oracle Database 11g: SQL Foundations 1 which focuses in the SQL programming knowledge. The exam duration is 120 minutes, with a total number of 66 question. The passing score is 60 percent. The exam format is of multiple choices.
Oracle Database 11g: Administration 1 which focuses in the administration of the overall database of an organization. The exam duration is 90 minutes. There are a total of 70 question. Candidate has to achieve 66 percent to become certified. Question are asked i multiple choices format.
Oracle certified Professional: This course entails a broader knowledge of database administration tools and techniques. To get the certification of OCP, one should have passed the OCA tests and the exam of Oracle Database 11G: Administration II.
Exam Information
Exam Duration: 105 minutes
Number of Questions: 78
Passing Score: 66%
Format: Multiple choices
Oracle Certified Master: This is the highest certification of Oracle. To be certified as OCM, one should have passed the OCP and then pass the Oracle Database 11G: Certified Master Exam by completing two of the approved advanced courses.
Exam Information
Exam Duration: 2 days
Number of Questions: Performance-based
Passing Score: Performance-based
Format: Performance-based
OBJECTIVES
The objectives of learning Oracle are:
The primary objective of Oracle training is to provide knowledge to become an Oracle Certified Professional.
Students will learn to manage all aspects of database management system such as create, plan, backup, recover and manage databases. They can perform easy to complex SQL operation. They will gain skills to perform the responsibilities of a DBA.
WHO CAN JOIN ORACLE TRAINING?
The training can be undertaken by software developers and programmers who wish to develop application with the underlying business logic stored in database servers. Oracle training will be handy for professionals who work with enterprise applications developed in Oracle as they might need to generate reports for various analyses. Oracle certification training is like a compulsion for individuals seeking to work as Oracle Database Administrators in IT companies in Nepal and worldwide.
PREREQUISITES FOR JOINING ORACLE CERTIFICATION COURSE
There is no such requirement prior to joining Oracle training. However, it is good to have a concept of software applications and understand the importance of database before joining Oracle training.
If you have not registered for Oracle training, come be a part of our training network, you would appreciate our training services as the best Oracle training institute in Nepal.
SYLLABUS
MODULE 1: ORACLE CERTIFIED ASSOCIATE DATABASE ADMINISTRATION
Understanding Oracle Architecture
Installing Oracle
General Tools for DBA
Environment Variable
Installer Log
Creating and Managing Database with DBCA
Using Enterprise Manager
Accessing Database using Oracle Client like SQL Plus and ISQL Plus
Initialize Database Parameters
Database Startup and Shutdown
Blocks, Table spaces, Data Files
Granting Authorization for various user accounts
Profile Management, Role Management
Defining Privileges
Creating Schema, Constraints, Views, Sequences
Modifying Schema
Data Dictionary
B Tree
Auditing Database
Managing Undo Data
Concurrency Management
Database Backup and Recovery
Checkpoints, Log Files
MODULE 2: LEARNING SQL FUNDAMENTALS I WITH ORACLE
This module builds proficiency in the practitioner to implement business logic in the server-side.
Create and manage table structure
Index and Keys
Concept of Primary Key and Auto Increment
Manipulate data in tables
Select, Insert, Delete, Update
SQL Operators
Sort, Limit
Customizing Output using single row functions
Aggregate Functions
Retrieving records by grouping related data
HAVING Clause
String Functions
Date and Time Functions
Set Operators like Union, Union All, Intersect and Minus
Sub Queries for performing operations on multiple tables
Displaying Data from multiple table using sub queries
Multiple rows and column sub queries
Pairwise vs Non Pairwise Comparisons
Applying Sub queries in FROM and WHERE Clause
Correlated Sub queries
Applying Sub queries in Update and Delete Queries
Exists and With
Performing SQL Joins
Inner and Outer Join, Left and Right Join
Cross Join
Hierarchical SQL
START WITH, CONNECT BY, PRIOR keywords
Generating reports in Tree Structure
Displaying hierarchical relationship between rows
Formatting Data
Inserting data in multiple table with a single insert query
View
Creating View
Displaying Data from the View
Sequences
On completing this module, students can works as a database developer in large enterprise applications
The competition in IT industry is very intense. Oracle certification is a clear indication of qualified skill-sets to work in the software development platform. Thus employers seek to hire professional with an accredited degree.
Upon completion of the Oracle course training, you can approach for vacancies in the following job position with authority.
Database Administrators
Database Programmers
The career benefits of investing in Oracle certification are:
Highlighting Oracle Certification in your CV would give you a competitive advantage among others while apply for job
You will earn a respected credential among the software professionals after gaining certification.
Most employees report an increase in their salary after being Oracle certified.