Oracle DBA Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

890 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Introduction (Database Architecture)

  • Describe course objectives
  • Explore the Oracle 12c database architecture
  • Creating Oracle 12c CDB & PDB
  • Managing Oracle 12c CDB & PDB.

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.

Installing the Oracle Database Software

  • Explain core DBA tasks and tools
  • Plan an Oracle installation
  • Use optimal flexible architecture
  • Install software with the Oracle Universal Installer (OUI).

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
  • View the Alert log
  • Use the Data Dictionary.

Administering User Security

  • Create and manage database user accounts
  • Authenticate users
  • Assign default storage areas (tablespaces)
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles
  • Implement standard password security features
  • Control resource usage by users.

Managing Multi Container Databases and Pluggable Databases

  • Starting Up a CDB Instance 
  • Mounting a CDB 
  • Opening a CDB 
  • Opening a PDB 
  • Closing a PDB 
  • Shutting Down a CDB Instance 
  • Creating after Startup Trigger to Open All PDBs
  • Changing PDB Mode 
  • Changing PDB Mode with SQL Developer 
  • Instance Parameter Changes and its Impact on PDBs 

Oracle Data Pump, SQL*Loader, and External Tables

  • Full Transportable Export/Import Overview 
  • Full Transportable Export/Import Usage 
  • Full Transportable Export/Import Example 
  • Plugging a Non-CDB into CDB Using Data Pump 
  • Plugging a Non-CDB into CDB Using Replication
  • Transporting a Database over the Network Example 

Managing Undo Data

  • Explain DML and undo data generation
  • Monitor and administer undo
  • Describe the difference between undo and redo data
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor.

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
  • Maintain the audit trail.

Course Description

What are the objectives and learning outcomes of Oracle DBA course?

  • Creating backups with RMAN.
  • Managing Oracle Database & Software.
  • The Oracle Instance.
  • Storage Parameters.
  • The Oracle Network Environment (SAP).
  • Different Startup & Shutdown Modes.
  • Related Jobs and Positions in the Industry.
  • Oracke 11g Concepts. 

Who should Attend Oracle Database Administration 12c / 11g course?

  • Oracle Database Administrators
  • Oracle Network Administrators
  • Oracle Application Developers
  • Application Administrators
  • Database Users
  • Aspirants aiming for a career in the prospective field. 

What are the Pre-Requisites of this course?

Aspiring people must have basic understanding knowledge of databases, working knowledge of RDBMS concept and SQL will be added a great advantage to take up a course Oracle DBA.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Sandeep

Really i enjoyed the course i have learnt alot , i like the way of teaching , the examples , also using graphics and pictures to make the information follow more easier. Thank you LTB.

Avinash

I have learned a lot about Oracle which is important for my work. Now, I know how to manage database and I am using this knowledge in my business. This Course helped a lot. Thank you Live Trainings Bangalore.

Satish

The course itself is very useful because it can be seen that the instructor has practical knowledge.The lessons are interesting, useful, clear, and well organized. Thank you LTB.