Home oracle

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.