Oracle Training

Rate the Course:   
4.70 out of 5 - Based on 513 Ratings

Oracle database is widely used by all small and big organizations to store their critical data that helps them to plan their business strategies. The primary goal of Oracel DBA course is to prepare the students to pass the OCA and OCP exams. This Oracle10g/11g/12c course is designed by IT Expetrs to provide deep understanding of the DBA concepts. In addition, this course provides sample OCA & OCP exam sample questions.We offer a course on Oracle 11g/12c DBA OCA & OCP. Oracle 11g DBA training takes the database administrator beyond the basic tasks covered in the SQL NEW and Administration Workshop I and Workshop II.

With the expertise and experience in providing professional training, we, Croma Campus, are also providing efficiently designed Oracle Training in Noida. At our center, students are provided with Oracle database concepts thoroughly. Our experts provide the thorough knowledge of every topic giving easy to grab examples.

Additionally, our classrooms are well-designed and equipped with modern furniture to provide a comfortable sitting and ambience to our students, and we also have separate computer labs equipped with all latest computer systems. We are a certified institute actively involved in providing placement focused Oracle Training in Noida. Our syllabus is designed in an organized manner, keeping industry requirement in mind.

We have evening batches, weekend classes and regular sessions so that students can join the training according to their time schedule. Our training courses are provided by well-qualified professionals who have attained many awards from several institutes and universities. Supported by genius faculty, we have established ourselves as a most apparent Oracle Training Institute in Noida, Delhi & NCR and providing the best education to our students.

Key Features about Oracle Training:

  • Oracle SQL, PL Sql, Admin1, Admin2
  • Trainer having 10+ years Industrial Experience.
  • ASM(Automatic Storage Management)
  • Active dataguard 11g
  • Complete Study Material
  • Oracle 11g Certified Trainer
  • Certification Preparation
  • RMAN(Recovery Manager
  • Course updated regularly as per latest release
  • Interview calls till placement.

Croma Campus Oracle Training Map

Oracle Training Program
SQL Basic & Advance
DBA-11g/12c Workshop-1 & Workshop-2
Certification Prepration OCA & OCP
Advance Topics
*For B.Tech/MCA Industrial Training: Project Synopsis/Project for College Submission/Industrial Training Certificate.

Oracle Database 11G Architecture

  • Instance vs. Oracle Database 11G
  • Components of an Oracle Database 11G Instance
  • Components of an Oracle Database 11G
  • Data files, Control files and Redo Logs
  • Checkpoints, Roll Forward and Rollback
  • Redo log concepts, Instance and Media recovery
  • Buffer Cache Block Management – LRU List
  • SGA vs. PGA
  • Background processes

Software and Database Installation

  • Unix Kernel Parameters Setup
  • Important configuration files – sysctl.conf, limits.conf, meminfo ,cpuinfo
  • Installation of Oracle Software
  • Installation Oracle Database 11G using DBCA
  • Setting up of Environment
  • Startup and Shutdown of the Oracle Database 11G

Oracle Database 11G Init Parameters

  • Init parameters
  • Displaying init.ora values with v$parameter
  • Sizing SGA components
  • Shared pool concepts and components
  • Overview of PGA for sorting and pga_aggregate_target
  • Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile
  • Explaining the use of control files
  • File locations for control Files
  • Obtaining Control File Information
  • Multiplexing Control File
  • Convert Oracle Database 11G to Archive log Mode
  • Archiving the Oracle Redo Logs

Oracle Database 11G Tablespace Management

  • Managing Tablespaces – Create, alter, drop, rename, offline, online, read only, read write
  • Creating, Resizing, Renaming, offline Datafiles
  • Creating and Managing Temporary Tablespaces and Tempfiles
  • Creating and Managing Undo Tablespaces
  • Understanding Undo Retention
  • Free Space / Used Space in Tablespace
  • Troubleshooting Undo snapshot too old
  • Online redo log (log_buffer)
  • Dictionary queries

Oracle Database 11G Redo Management, Management of Database Segments

  • Redo log switch
  • Multiplexing the Online Redo Log Files
  • Dictionary and v$ views
  • The dba_, all_ and user_ structures
  • Querying the tables, indexes, and segments views
  • Monitoring the alert log
  • Oracle Database trace/dump files
  • Oracle Database tables : Creation and Maintenance Operations
  • Oracle Database Indexes : Creating B-Tree, bitmap and function-based Indexe
  • Oracle Database Views

Oracle Database 11G Reorg, Users, Roles , Profiles , Privileges

  • Reorganize Tables
  • Index rebuilding
  • Creating New Database Users
  • Managing Profiles
  • Identifying System and Object Privileges
  • Granting and Revoking Privileges
  • Creating and Modifying Roles
  • Displaying user security Information from the Data Dictionary

Oracle Database 11G Net configuration

  • Understanding the Listener and how connection takes place from Client to Server
  • Use Netca
  • Creating the listener.ora file
  • Creating the tnsnames.ora file
  • Verifying network connectivity with ping and tnsping
  • Testing Oracle Database 11G connection via Listener

Oracle Database 11G Backup & Recovery

  • Hot vs. Cold backups
  • Backup in Archivelog vs. Noarchivelog Mode
  • Taking Cold Backups
  • Taking Hot Backups
  • Concepts of Hot Backup
  • Complete and Incomplete Recovery
  • Restoration from cold Backup with complete data loss
  • Restoring and Recovering from loss of Datafiles – System and non-system ,loss of Read Only Tablespaces
  • Loss of Controlfiles
  • Loss of Redo Logs – Inactive and Active
  • Complete and Incomplete Recovery

Oracle Database 11G Backup and Recovery management using RMAN

  • Advantages of RMAN
  • Advantages of Catalog over Nocatalog
  • Catalog Creation
  • RMAN Closed Database and Hot Backups
  • RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile)
  • Viewing Backups using List
  • Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies)
  • Reporting Bacukups
  • Restoring and Recovering from loss of Datafiles – System and non system ,loss of Read Only Tablespaces
  • Loss of Controlfiles
  • Loss of Redo Logs – Inactive and Active
  • Complete and Incomplete Recovery

Oracle Database 11G DBA Utilities

  • Imp and exp utilities
  • Data pump (impdp and expdp
  • DB Verify for Corruption
  • Flashback Oracle Database, Flashback Drop , Flashback Query
  • Using opatch for Oracle Database Patching.

Oracle Cloning Of Oracle Database

  • Cloning using Hot Backup
  • Cloning Using RMAN Duplicate Database

Performance Management: Understand Problem , Check OS and Automated Reports

  • Understand the Performance Problem Scope
  • Discuss with the affected Users
  • Check dynamic performance views useful in tuning
  • Use dynamic performance views to view statistics and wait events
  • Create and manage AWR snapshots
  • Generate AWR reports
  • Generate ADDM reports
  • Log a performance Service Request with Oracle Support

Oracle Performance Management: Tuning the Oracle Database 11G Instance

  • Tuning SGA
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Checkpoint and Redo Tuning
  • Diagnose checkpoint and redo issues
  • Size the redo log file
  • Size the redo log buffer
  • Diagnose PGA memory issues
  • Size the PGA memory
  • Diagnose temporary space issues
  • Understanding Locks
  • Detect enqueue contention

Database 11G Performance Management: DBMS_STATS, Detect Fragmentation , SQL Tuning

  • Cost Based Optimizer
  • Using EXPLAIN PLAN
  • Using set autotrace
  • Interpreting EXPLAIN PLAN Output
  • Collecting Schema , table and index statistics (dbms_stats)
  • Checking Statistics
  • Tracing a Database Session
  • Using TKPROF to analyze a trace File

Oracle Database 11G Maintenance & Job Scheduling and Processes

  • Monitoring Systems
  • Commonly configured Oracle Database Alerts and Actions to be taken
  • Common Monitoring Problems Encountered and Resolution
  • Change Management Process , Approval Process
  • Ticket Management Process (Severity , Priority , SLAs,Communication Protocol).
  • Oracle Certified Associate Certification

    oca-logo

    Oracle Certified Associate Certification Exam :
    • Step 1 - Pass One Exam Oracle Database 11g: SQL Fundamentals I Exam Number : (1Z0-051) OR Oracle Database SQL Expert Exam Number : 1Z0-047
    • Step 2 - Pass Exam Oracle Database 11g: Administration I Exam Number : (1Z0-052)Complete the above 2 exams to become “Oracle Database 11g Administrator Certified Associate Certification-OCA”

    Syllabus for Oracle Certified Associate Certification Exam

    Oracle Database 11g: SQL Fundamentals I Exam Number : (1Z0-051)
    • Retrieving Data Using the SQL SELECT Statement
    • Restricting and Sorting Data
    • Using Single-Row Functions to Customize Output
    • Using Conversion Functions and Conditional Expressions
    • Reporting Aggregated Data Using the Group Functions
    • Displaying Data from Multiple Tables
    • Using Sub queries to Solve Queries
    • Using the Set Operators
    • Manipulating Data
    • Using DDL Statements to Create and Manage Tables
    • Creating Other Schema Objects
    Oracle Database 11g: Administration I Exam Number : (1Z0-052)
    • Exploring the Oracle Database Architecture
    • Preparing the Database Environment
    • Creating an Oracle Database
    • Managing the Oracle Instance
    • Configuring the Oracle Network Environment
    • Managing Database Storage Structures
    • Administering User Security
    • Managing Data and Concurrency
    • Managing Undo Data
    • Implementing Oracle Database Security
    • Database Maintenance
    • Performance Management
    • Intelligent Infrastructure Enhancements
    • Backup and Recovery Concepts
    • Performing Database Backups
    • Performing Database Recovery
    • Moving Data

    View Details

  • Oracle Certified Professional Certification

    ocp-logo

    Oracle Certified Professional Certification Exam :
    • Step 1 - Prior Certification Requirements Oracle Database 11g Administrator Certified Associate-OCA
    • Step 2 - Complete the training course Oracle Database 11g: SQL Fundamentals II
    • Step 3 - Pass Exam Oracle Database 11g: Administration II Exam Number : (1Z0-053)
    • Step 4 - Complete this form Complete the course submission form Complete the above exams to become “Oracle Database 11g Administrator Certified Professional Certification-OCP”

    Syllabus for Oracle Certified Professional Certification Exam

    Oracle Database 11g: SQL Fundamentals II
    • Controlling User Access
    • Managing Schema Objects
    • Data Dictionary Views and Large Data Sets
    • Managing Data in Different Time Zones
    • Using Sub queries and Regular Expressions
    Oracle Database 11g: Administration II Exam Number : (1Z0-053)
    • Database Architecture and ASM
    • Configuring for Recoverability
    • Using the RMAN Recovery Catalog
    • Configuring Backup Specifications
    • Using RMAN to Create Backups
    • Performing User-Managed Backup and Recovery
    • Using RMAN to Perform Recovery
    • Using RMAN to Duplicate a Database
    • Performing Table space Point-in-Time Recovery
    • Monitoring and Tuning RMAN
    • Using Flashback Technology
    • Additional Flashback Operations
    • Diagnosing the Database
    • Managing Memory
    • Managing Database Performance
    • Space Management
    • Managing Resources
    • Automating Tasks with the Scheduler
    • Administering the Scheduler

    View Details

Please write to us at info@cromacampus.com for the course price, schedule & location.

Enquire Now

Frequently Asked Questions:

All training courses offered by us are through IT Professional with 10+ years of experience. Freshers/College Students/Professionals(IT & Non-IT) can spot the quality of training by attending one lecture. Hence, we provide one free demo class to all our trainees so that they can judge on their own.

No, you don’t have to pay anything to attend the demo class. You are required to pay the training fee after free demo only if you are fully satisfied and want to continue the training.

To register for free demo, visit our campus or call our counsellors on the numbers given on contact us page.

Yes, all the trainees shall work on live projects provided by Croma Campus after completing their training part.

You will never lose any lecture. You can choose either of the two options:
View the recorded session of the class available in your LMS.
You can attend the missed session, in any other live batch.

Please note, access to the course material will be available for lifetime once you have enrolled into the course.

Yes, Training certificate & Project completion will be issued by Croma Campus(ISO 9001-2000 Certified Training Center)

Yes, Croma Campus conduct special training programs on week end for college students throughout the year.

Croma Campus is the largest education company and lots of recruitment firms contacts us for our students profiles from time to time. Since there is a big demand for this skill, we help our certified students get connected to prospective employers. We also help our customers prepare their resumes, work on real life projects and provide assistance for interview preparation. Having said that, please understand that we don’t guarantee any placements however if you go through the course diligently and complete the project you will have a very good hands on experience to work on a Live project.

Yes, Course Fee can be paid in two equal installments with prior Approval.

Yes, Croma Campus offer various group or special discounts.

No, Lab is open from 8 A.M. to 8 P.M. seven days a week. This time can be extended upto 11 PM if need arises.

Yes, students can take breaks during their exams and can resume it later without paying any fee. Apart from this, Students can attend batches for revision even after completion of their courses.

Batch strength differ from technology to technology. Minimum batch strength at Croma Campus is 10 and maximum batch strength is 30.

Drop us a query

Course Features

Get Practical and Well focused training from Top IT Industry experts.

Get Routine assignments based on learning from previous classes.

Live project, during or after the completion of the syllabus.

Lifetime access to the learning management system including Class recordings, presentations, sample code and projects

Lifetime access to the support team (available 24/7) in resolving queries during and after the course completion

Get certification after the course completion.

+91-9711526942 whatsapp

Testimonials