Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while formerly employed by Ampex.
Understanding Oracle Architecture
General Tools for DBA
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, Tablespaces, Data Files
Granting Authorization for various user accounts
Profile Management, Role Management
Creating Schema, Constraints, Views, Sequences
Managing Undo Data
Database Backup and Recovery
Checkpoints, Log Files
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
Customizing Output using single row functions
Retrieving records by grouping related data
Date and Time Functions
Set Operators like Union, Union All, Intersect and Minus
SubQueries for performing operations on multiple tables
Displaying Data from multiple table using subqueries
Multiple rows and column subqueries
Pairwise vs NonPairwise Comparisons
Applying Subqueris in FROM and WHERE Clause
Applying Subqueries in Update and Delete Queries
Exists and With
Performing SQL Joins
Inner and Outer Join, Left and Right Join
START WITH, CONNECT BY, PRIOR keywords
Generating reports in Tree Structure
Displaying hierarchical relationship between rows
Inserting data in multiple table with a single insert query
Displaying Data from the View
On completing this module, students can works as a database developer in large enterprise applications
The syllabus prescribed in this module helps candidate to sit for Oracle Database 11g Administrator Certified Professional Certification exam. However in order to sit for OCP certification exam, candidates are required to pass Oracle Database Administrator Certified Associate exam.
In order to appear for this certification exam, one must have passed Oracle Database Administrator Certified Professional exam.
If you want to achieve OCM certification, you must have completed any two courses from the following:
SQL Tuning Workshop
Performance Tuning DBA
Data Guard Administration
Question About This Course ?
For more information about courses, please send inquiry then our representatives will contact you:Inquiry Now
- Highlighting Oracle database 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.
- Database Administrators r
- Database Programmers
After finishing my training, I was hired by Kantipur Technical Institute as a Computer Instructor. I am currently working at Kantipur as a Computer Teacher. Thanks to Kantipur Technical Institute who helped me start my career as a Computer Instructor.