Course Duration

30 Hrs.

Live Project

02 Project

Certification Pass

Guaranteed

Training Format

Live Online /Self-Paced/Classroom

Watch Live Classes

oracle-dba-10g11g-12c

Speciality

prof trained

500+

Professionals Trained
batch image

4+

Batches every month
country image

20+

Countries & Counting
corporate

100+

Corporate Served
Croma Campus provides the excellence training for Oracle-DBA in Delhi NCR. Our trainers are oracle certified professionals and handling real time Oracle projects. The importance of Oracle DBA training is increasing in the market as well as the opportunities are also vast. Oracle DBA converts all IT solutions like storage, middleware and Operating System by obtaining leading technology. It provides very unique solutions to the customers Database Administrators (DBAs) is responsible for designing, support and implementation, maintenance of computerized databases in today’s organizations.

BENEFITS OF ORACLE DBA:

    • Ensures Credibility and reliability in the market
    • Better knowledge and understanding of technology stack
    • You can do testing against some standards
    • Better communications network with developers
    • High earnings

After learning Introduction to SQL section of this course, the learners will be able to:

  • Understand the features and basic concepts of relational databases.
  • Use data manipulation statements for performing various operations such as sorting, modifying, and retrieving data.
  • Customize output using single-row functions, conversion functions and conditional expressions.
  • Consolidate and display data from multiple tables using Joins and Group functions.
  • Use data definition language to create and manage tables.
  • Manage schema objects and control database access to specific objects.
  • Create indexes and constraints; and use regular expression.
  • Perform data management in different time zones.

On the completion of Administration Workshop I section of this course, the students will be able to:

  • Understand Oracle database architecture.
  • Install Oracle Grid Infrastructure and Oracle database software.
  • Configure Oracle Network Environment using Enterprise Manager.
  • Create and manage database, storage structures, and users.
  • Manage data manipulation and data concurrency.
  • Implementing Oracle Database Auditing.
  • Perform backup and recovery of the database

By undergoing the Administration Workshop II section of the training, participants will be able to

  • Understand backup and recoverability and use Recovery manager (RMAN) to perform it.
  • Use flashback technology to diagnose and repair data failures.
  • Perform memory management operations to use available space in optimized way and create room for growing requirements.
  • Identify and tune poorly performing SQL and database session by using SQL Tuning Advisor
  • Monitor and manage performance and resources.
  • Automate DBA tasks with the scheduler.
  • Clone a database and carry all operations on it for optimal use
Target audience
  • PL/SQL Developer
  • Forms Developer
  • Application Developer
  • Support Engineer
  • Database administrator
  • Technical Administrator
  • Data Warehouse Administrator
Prerequisites : The candidates having familiarity with data processing + SQL Basic concepts and techniques are eligible to go through this training. Exams for Certifications :
Level Exam Name Exam Code
OCA Oracle Database11g: SQL Fundamental 1Z0-051
Oracle Database 11g: Administration I 1Z0-052
OCP Oracle database 11g:Administration II 1Z0-053
 

Why to Choose this Course

Request more information

By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy

BATCH TIMINGS

Oracle - DBA Upcoming Batches

WEEKDAY

calendar

03-Oct-2022 *

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

FASTRACK

calendar

01-Nov-2022*

Running lack of time? Join Fastrack classes to speed up your career growth.

Materials and guidance on certifications

Register for FREE demo before signing up.

WEEKDAY

calendar

05-Oct-2022*

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

WEEKDAY

calendar

03-Nov-2022*

Take class during weekdays and utilize your weekend for practice.

Get regular training by Industry Experts.

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

WEEKEND

calendar

08-Oct-2022*

More Suitable for working professionals who cannot join in weekdays

Get Intensive coaching in less time

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

WEEKEND

calendar

15-Oct-2022*

More Suitable for working professionals who cannot join in weekdays

Get Intensive coaching in less time

Get Proper guidance on certifications.

Register for FREE demo before signing up.

10% OFF

Timings Doesn't Suit You ?

We can set up a batch at your convenient time.

Batch Request

enter date
email
mobile

CURRICULUM & PROJECTS

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).
Need Customized curriculum?

Mock Interviews

Prepare & Practice for real-life job interviews by joining the Mock Interviews drive at Croma Campus and learn to perform with confidence with our expert team. Not sure of Interview environments? Don’t worry, our team will familiarize you and help you in giving your best shot even under heavy pressures.Our Mock Interviews are conducted by trailblazing industry-experts having years of experience and they will surely help you to improve your chances of getting hired in real.
How Croma Campus Mock Interview Works?

Projects

Validate your skills and knowledge by working on industry-based projects that includes significant real-time use cases.Gain hands-on expertize in Top IT skills and become industry-ready after completing our project works and assessments. Our projects are perfectly aligned with the modules given in the curriculum and they are picked up based on latest industry standards.Add some meaningful project works in your resume, get noticed by top industries and start earning huge salary lumps right away.
Request more information

By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy

Phone (For Voice Call)

+91-971 152 6942
indian

WhatsApp (For Call & Chat)

+919818014543
international

self assessment

Learn, Grow & Test your skill with Online Assessment Exam to achieve your Certification Goals

laptop
Are you satisfied with our Training Curriculum?

If yes, Register today and get impeccable Learning Solutions!


By registering here, I agree to Croma Campus Terms & Conditions and Privacy Policy

man

Training Features

instructore

Instructor-led Sessions

The most traditional way to learn with increased visibility,monitoring and control over learners with ease to learn at any time from internet-connected devices.

real life

Real-life Case Studies

Case studies based on top industry frameworks help you to relate your learning with real-time based industry solutions.

assigment

Assignment

Adding the scope of improvement and fostering the analytical abilities and skills through the perfect piece of academic work.

life time access

Lifetime Access

Get Unlimited access of the course throughout the life providing the freedom to learn at your own pace.

expert

24 x 7 Expert Support

With no limits to learn and in-depth vision from all-time available support to resolve all your queries related to the course.

certification

Certification

Each certification associated with the program is affiliated with the top universities providing edge to gain epitome in the course.

Training Certification

Earn your certificate

Your certificate and skills are vital to the extent of jump-starting your career and giving you a chance to compete in a global space.

Share your achievement

Talk about it on Linkedin, Twitter, Facebook, boost your resume or frame it- tell your friend and colleagues about it.

Video Reviews

Testimonials & Reviews

testimonials
×

For Voice Call

+91-971 152 6942

For Whatsapp Call & Chat

+91-9818014543
1