Oracle

Is an object-relational database management system[3] produced and marketed by Oracle Corporation.

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.[4]

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, Tablespaces, 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

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
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
Correlated Subqueries
Applying Subqueries 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 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
Implement Streams
Security
Advanced PL/SQL

SUBSCRIBE NEWSLETTER

Subscribe to the free monthly newsletter.

You’ll receive notification of new courses and other news.

Copyright 2019 Kantipur Technical Institute - All Rights Reserved Design by Web Creation Nepal