Our Support: During the COVID-19 outbreak, we request learners to CALL US for Special Discounts!

Home » Courses » Oracle DBA

Oracle DBA & RAC Training and Certification

Looking for Oracle & RAC training and certification in live classes? JanBask Training offers six-week oracle database administrator training program. Real-time classes & live project to improve your Oracle DBA RAC skills. Be expert in Oracle & get complete Oracle DBA training which makes you a demanding IT resource. Free trial class also available

Next Class Begins in 17 days - 17 Nov 2020

Enroll For Free Demo

Enter your details to attend Course Demo Class

Why Oracle DBA Certification?

Why Should you Choose Oracle DBA as a Career

#1

Database administration platform

90%

of the fortune 500 use Oracle Database

Salesforce Growth

You Should Join Our Classes If You Are:

  • Just starting off & aren’t sure where to start from
  • In an established role but need to dive deep
  • Looking to brush up your skills & master the course
  • Willing to get better in your current or new job

2582

new jobs posted in the year 2018

$92,643

Oracle DBA professionals in the USA

Do You Know Why Oracle DBA Training is Necessary to Grow Your Career?

Instructor-led Live Online Oracle DBA Classes


Starting
Duration
Price

17 Nov

WEEKDAY - Filling Fast

6 Weeks

09.00 - 10.30 PM EST

USD 649

USD 552

Flat 15% Off

08 Dec

WEEKDAY

6 Weeks

09.00 - 10.30 PM EST

USD 649

07 Nov

WEEKEND

6 Weeks

08.00 - 11.00 AM EST

USD 649

29 Dec

WEEKDAY

6 Weeks

09.00 - 10.30 PM EST

USD 649

09 Feb

WEEKDAY

6 Weeks

09.00 - 10.30 PM EST

USD 649

USD 454

Flat 30% Off

Early Bird Discount

Easy Installments

Enroll Now and pay Later (on request)

Detail
WEEKDAY - Filling Fast

17 Nov


6 Weeks

09.00 - 10.30 PM EST

USD 649

USD 552

Flat 15% Off

Enroll Now
WEEKDAY

08 Dec


6 Weeks

09.00 - 10.30 PM EST

USD 649

WEEKEND

07 Nov


6 Weeks

08.00 - 11.00 AM EST

USD 649

WEEKDAY

09 Feb


6 Weeks

09.00 - 10.30 PM EST

USD 649

Easy Installments

Enroll Now and pay Later (on request)

Not Sure Which Oracle DBA Class to Join?  

Best-in-class content by leading faculty & industry leaders in the form of videos and projects, assignments & live sessions.

Career Counselling

Career Counselling

Resume Feedback

Resume Feedback

Interview Preparation

Interview Preparation

Oracle DBA Certification Training Course Roadmap

Get a glimpse of your Course Syllabus here!

Introduction & Oracle Database Software

  • Introduction to Oracle DBA

    • Introduction on Oracle DBA
    • Oracle 12c DBA Architecture
    • Explore the Oracle 11g database architecture
    • Oracle database Overview, DBA Responsibilities.

    Installing the Oracle Database Software

    • Install software with the Oracle Universal Installer (OUI)
    • Tasks of an Oracle Database Administrator
    • Tools Used to Administer an Oracle Database
    • Installation: System Requirements
    • Installing Oracle Grid Infrastructure
    • Installing Oracle Database Software
    • Install and configure 11g and 12c Oracle Database Software

Creating an Oracle Database

    • Create a database with the Database Configuration Assistant (DBCA)
    • Create a database design template with the DBCA
    • Generate database creation scripts with the DBCA
    • Using the DBCA to Create a Database
    • Password Management
    • Using the DBCA to Delete a Database

Managing the Oracle Instance

    • Start and stop the Oracle database and components
    • Use Enterprise Manager (EM)
    • Access a database with SQL*Plus and iSQL*Plus
    • Modify database initialization parameters
    • Understand the stages of database startup
    • Describe the stages of database startup
    • Describe database shutdown options
    • View the Alert log, Use the Data Dictionary

Managing Database Storage Structures

    • Using appropriate Storage settings, Types of segments.
    • Describe table data storage (in blocks)
    • Define the purpose of tablespaces and data files
    • Understand and utilize Oracle Managed Files (OMF)
    • Space Management in Tablespaces
    • Tablespaces in the Preconfigured Database
    • Automatic Storage Management (ASM)
    • Set up initialization parameter files for ASM instance
    • Managing Undo Data, Explain DML and undo data generation

Administering User Mangement

    • Create and manage database user accounts
    • Authenticate users, Predefined Administrative Accounts
    • Assign default storage areas (tablespaces)
    • Create and manage roles & profiles
    • Implement standard password security features
    • Control resource usage by users

Oracle Database Security & Oracle Network

  • Implementing Oracle Database Security

    • Describe DBA responsibilities for security
    • Apply the principal of least privilege
    • Enable standard database auditing
    • Specify audit options, Review audit information

    Configuring the Oracle Network Environment

    • Create additional listeners
    • Create Net Service aliases
    • Configure connect-time failover
    • Control the Oracle Net Listener
    • Test Oracle Net connectivity
    • Identify when to use shared versus dedicated servers
    • Use Enterprise Manager to create and configure the Listener
    • Enable Oracle Restart to monitor the listener
    • Use tnsping to test Oracle Net connectivity
    • Identify when to use shared servers and when to use dedicated servers

a

  • a

Course Curriculum

Get the Complete Course Curriculum

Why Learn at JanBask Training?

Answers to the most frequently asked questions from our learners!

Clear your confusion - Don't skip but just read them!