Oracle DBA 11g Training Course

Oracle DBA 11g Training Course

Click on the buttons inside the tabbed menu:

Course Description

The Pl-SQL program is designed to help the participant to understand the installation of database in a RDBMS environment and to successfully work in this domain.

There are multiple courses available to fit the requirement of students and working Professionals.

1. Oracle DBA Administration 12c.

2. Oracle DBA Administration 11g

;
What skills will the student gain?
After the completion of this course, the student will be able to:

  • Understand the installation of Oracle Database.
  • ·   Creation of database instances
  • ·   Maintenance of databases
  • ·   Making backups and restore of databases
  • ·   Understand different types of delivered features by Oracle
  • ·   Use Pl-SQL programs to insert, update and delete multiple records through a single program.

Mode of Training

The Pl-SQL training is delivered in the following modes - Regular Classroom, Fast-track, Self-Study and Online live trainer

Locations:

The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.

To know more about the schedules in those cities click here -->

Schedule for Kolkata

Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.

The course outline delivered during the class is as follows -

  • TOPIC NAME

    TOPIC NAME

    1. Installing the Oracle Database Software

    9. Implementing Oracle Database Security

    • Explain core DBA tasks and tools
    • Describe DBA responsibilities for security
    • Plan an Oracle installation
    • Apply the principal of least privilege
    • Use optimal flexible architecture
    • Enable standard database auditing
    • Install software with the Oracle Universal Installer (OUI)
    • Specify audit options

    • Review audit information
    1. Creating an Oracle Database
    • Maintain the audit trail
    • Create a database with the Database Configuration Assistant (DBCA)

    • Create a database design template with the DBCA

    10. Configuring the Oracle Network Environment

    • Generate database creation scripts with DBCA
    • Use Enterprise Manager for configuring the Oracle network environment

    • Create additional listeners
    1. Managing the Oracle Instance
    • Create Net Service aliases
    • Start and stop the Oracle database & components
    • Configure connect-time failover
    • Use Enterprise Manager (EM)
    • Control the Oracle Net Listener
    • Access a database with SQL*Plus and iSQL*Plus
    • Test Oracle Net connectivity
    • Modify database initialization parameters
    • Identify when to use shared versus dedicated servers
    • Understand the stages of database startup

    • View the Alert log

    11. Proactive Maintenance

    • Use the Data Dictionary
    • Use statistics

    • Manage the Automatic Workload Repository (AWR)
    1. Managing Database Storage Structures
    • Use the Automatic Database Diagnostic Monitor (ADDM)
    • Describe table data storage (in blocks)
    • Describe advisory framework
    • Define the purpose of tablespaces & data files
    • Set alert thresholds
    • Understand & utilize Oracle Managed Files
    • Use server-generated alerts
    • Create and manage tablespaces
    • Use automated tasks
    • Obtain tablespace information

    • Describe the main concepts and functionality of Automatic Storage Management (ASM)

    12. Performance Management

    • Use Enterprise Manager pages to monitor performance
    1. Administering User Security
    • Use the SQL Tuning Advisor
    • Create and manage database user accounts
    • Use the SQL Access Advisor
    • Authenticate users
    • Use Automatic Shared Memory Management
    • Assign default storage areas (tablespaces)
    • Use the Memory Advisor to size memory buffers
    • Grant and revoke privileges
    • Use performance related dynamic views
    • Create and manage roles
    • Troubleshoot invalid or unusable objects
    • Create and manage profiles

    • Implement standard password security features

    13. Backup and Recovery Concepts

    • Control resource usage by users
    • Identify the types of failure that may occur in an Oracle Database

    • Describe ways to tune instance recovery
    1. Managing Schema Objects
    • Identify the importance of checkpoints, redo log files, and archived log files
    • Define schema objects and data types
    • Configure ARCHIVELOG mode
    • Create and modify tables

    • Define constraints

    14. Performing Database Backups

    • View the columns and contents of a table
    • Create consistent database backups
    • Create indexes, views and sequences
    • Back your database up without shutting down
    • Explain the use of temporary tables
    • Create incremental backups
    • Use the Data Dictionary
    • Automate database backups

    • Monitor the flash recovery area
    1. Managing Data and Concurrency

    • Manage data through SQL

    15. Performing Database Recovery

    • Identify and administer PL/SQL Objects
    • Recover from loss of a control file
    • Describe triggers and triggering events
    • Recover from loss of a redo log file
    • Monitor and resolve locking conflicts
    • Perform complete recovery following the loss of a data file

    1. Managing Undo Data

    16. Performing Flashback

    • Explain DML and undo data generation
    • Describe Flashback database
    • Monitor and administer undo
    • Restore the table content to a specific point in the past with Flashback Table
    • Describe the difference between undo and redo data
    • Recover from a dropped table
    • Configure undo retention
    • View the contents of the database as of any single point in time with Flashback Query
    • Guarantee undo retention
    • See versions of a row over time with Flashback Versions Query
    • Use the undo advisor
    • View the transaction history of a row with Flashback Transaction Query

Schedule

If you are located outside Kolkata or would like to attend our session during your visit to Kolkata then please feel free to write us at palium.skills@gmail.com for any queries related to program,
upcoming schedule and fee. Call: +91-9051092035 or WhatsApp: +91-9051092035

Schedule for AWS Training in 2018 is as follows:
Month Dates No of Hours
January Completed
February Completed
March Completed
April Completed
May Completed
June Completed
July Completed
August 26th Aug (Fast-track) 30
September 4th - weekday, 23rd - fast-track 30
October TBA 30
November 4th - fast-track,6th - weekday 30
December 2nd - fast-track, 4th - weekday 30

Study Mode & Fees

Course/Certification Name Delivery Mode Fees Special Offers
Oracle DBA Administration 12c Classroom Rs. 10,000+ 18% GST best offers for 2+ enrollments
Oracle DBA Administration 12c Online Exam Rs. 11,000 + 18% GST Payable directly to Oracle, discounts available from time to time
Oracle DBA Administration 12c Fast-track Classroom training talk to us best offers available
Oracle DBA Administration 12c Online live trainer Rs. 10,000+ 18% GST best offers available for multiple enrollments

FAQs

The commonly asked questions pertaining to Oracle Pl-SQL training are -

Q: What are the pre-requisites for taking the DBA course?

A: Good knowledge of SQL Fundamentals is a must. Besides, if one were to get Oracle certified then the first exam is the SQL exam.

Q: Which version of Oracle Database will be covered?

A: The latest version of Oracle database is 12c which will be covered in the course. If 11g is required then the same can be arranged on request.

Q: Will this be theoretical or hands-on?

A: This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

Q: Will I get access to the database?

A: Yes, trainer will demonstrate how to access the instance.

Q: Will I incur any charges for accessing the application?

A: The standard features are available for free. There are some premium services for which charges maybe imposed by service provider.

Q: What if I have doubts after completing the class?

A: You can gather your doubts and come by prior appointment to get your doubts cleared.

Q: What help will I get for clearing the Certification Exam?

A: Our trainer is a Certified person and will provide guidance and tips for clearing the exam. Besides, you will get access to question bank for preparing for the exam

Q: Will I receive a certificate for the course?

A: Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Get help now
CONTACT US +91-9051092035 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customized Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Palium Skills