DBA Training and Certification

 

DBA

®

Training & Certification

 DBA WS1 Training & Certification Course

DBA WS1 is the first course required for those seeking a career as a Oracle DBA.

DBA WS1 certification exam is the second exam that one needs to clear to achieve OCA certification in DBA track.

Audience:

  • Data Warehouse Administrator
  • Database Administrators
  • System Analysts
  • Business Analysts
  • Application Developers
  • PL/SQL Developer

Course Objectives

  • 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
Certification Details®
Course Name Exam No of (days)
Oracle SQL SQL Certification Exam 12c or 11g 1
Total 1
Course/Exam Name Duration Fees
SQL Course 40 hours or 15-20 classes Rs. 10,000 + 18% GST
Oracle Database Workshop1 Exam Payable to Oracle at time of certification exam Rs.10,900

If you have more Comments or questions then you are welcome to our center.


Accordions

The commonly asked questions pertaining to PMP Certification exam are -

There are no mandatory Prerequisites for taking the ITIL Certification exam - however the following helps to facilitate the process

  • Atleast one year of work experience in IT Service Management is recommended

    OR

    Understanding of the processes relating IT Service Management is helpful for successful certification

  • Yes, we recommend all participants to do our training as that will help them to assimilate all aspects of this domain and make their certification more meaningful - what is the use of certification if you cannot explain basic concepts.

  • We will provide you access to an Online Question Bank which has 4 mock exams. As you start with the first mock exam and move towards the other ones then you will find your score improving.

  • One can take either the online or the paper mode of exam. If you opt for online then we will provide you with the exam voucher and book your slot for the online proctored exam and you can appear for the exam. If however, you want to take the paper exam then the same will be held on the second day of the exam.

  • The exam will be conducted at our center under examination conditions in the presence of an invigilator.

Chat with Expert
CONTACT US +91-8420594969 (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
  • Customize Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Send us Your Query