+91-9051092035 +91-8420594969(24x7) palium.skills@gmail.com
DBA WS2 Training and Certification

 

DBA WS2

®

Training & Certification

Home Oracle DBA WS2

 DBA Workshop2 Training & Certification Course

Applies to: 11g/12c

Audience:

  • Database Administrators
  • Sales Consultants
  • Support Engineer
  • Project Manager
  • Database Designers
  • Technical Consultant

Required Prerequisites:

  • Oracle Database 11g/12c: Administration Workshop I

Suggested Prerequisites:

  • Oracle Database 11g/12c: SQL Fundamentals I
  • Oracle Database 11g/12c: SQL and PL/SQL Fundamentals

Course Objectives:

  • Use RMAN to create and manage backup sets and image copies
  • Recover the database to a previous point in time
  • Use Oracle's Flashback technology to recover your database
  • Detect block corruptions and take appropriate measures to correct them
  • Use the various Database advisors and views to monitor and improve database performance
  • Control database resource usage with the Resource Manager
  • Simplify management tasks by using the Scheduler
  • Improve the security of the listener
  • Review database log files for diagnostic purposes
  • Customize language-dependent behavior for the database and individual sessions

Course Outline:

TOPIC NAME

TOPIC NAME
  1. Using Globalization Support
  1. Dealing with Database Corruption
  • Datetimes with Timezones
  • What is block corruption?
  • Specifying Language-Dependent Behavior
  • Interpreting DBVERIFY
  • Locale Variants
  • The ANALYZE command
  • Linguistic Sorting
  • How to Handle Corruptions
  • Case and Accent Insensitive Sorts
  • The DBMS_REPAIR Package
  • Linguistic Comparisons
  • Block Media Recovery (BMR)
  • Obtaining Information about the Current NLS Configuration
  • Detecting Database Corruptions Using DBVERIFY

  • Using RMAN to Repair Corrupt Blocks
  1. Securing the Oracle Listener

  • Listener Password Authentication
  1. Automatic Database Management
  • Controlling Database Access
  • Automatic Optimizer Statistics Collection
  • Securing the EXTPROC Service Entry
  • Workload Repository

  • Database Control and Advisors
  1. Configuring Recovery Manager
  • Using the SQL Tuning Advisor
  • Using a Flash Recovery Area with RMAN
  • Using the SQL Access Advisor
  • Setting Parameters for RMAN
  • Automatic Undo Retention Tuning
  • Starting RMAN

  • Configuring Persistent Settings for RMAN
  1. Monitoring and Managing Storage
  • Control File Autobackups
  • Redo Logfile Size Advisor
  • Retention Policies
  • Resumable Statements

  • Tablespace Space Usage Monitoring
  1. Using Recovery Manager
  • Accessing the Segment Advisor
  • Issuing Recovery Manager Commands
  • Shrinking Segments Using SQL
  • Parallelization of Backup Sets
  • Segment Resource Estimation
  • Compressed Backups
  • Monitoring Index Space
  • Copying the Whole Database
  • Identifying Unused Indexes
  • Making Incremental Backups

  • Block Change Tracking
  1. Automatic Storage Management
  • Incrementally Updating Backups
  • ASM Concepts
  • Monitoring RMAN Backups
  • ASM General Architecture

  • Creating an ASM instance
  1. Diagnostic Sources
  • Creating tablespaces that use ASM storage
  • The Alert Log
  • Viewing ASM information
  • Viewing Alerts with EM
  • Migrating a tablespace to use ASM storage
  • Alerts Notification

  • Editing Thresholds
  1. Monitoring and Managing Memory
  • Trace Files
  • Oracle Memory Structures

  • Automatic PGA Memory Management
  1. Recovering from non-critical losses
  • Using the Memory Advisor
  • Creating New Temporary Tablespace
  • Using Automatic Shared Memory Management to avoid long running query issues
  • Recreating Redo Log Files

  • Recovering an Index Tablespace
  1. Managing Resources
  • Read-Only Tablespace Recovery
  • Creating a New Resource Plan
  • Loss of Password Authentication File
  • Creating Resource Consumer Groups

  • Assigning Users to Resource Consumer Groups
  1. Database Recovery
  • Adaptive Consumer Group Mapping
  • Recovery Steps
  • Using Sub-Plans to limit CPU Utilization
  • User-Managed Recovery Procedures: RECOVER Command
  • Administering the Resource Manager
  • Types of incomplete recovery
  • Resource Plan Directives
  • Incomplete Recovery Best Practices

  • Recovery Using EM
  1. Automating Tasks with the Scheduler
  • Simple Recovery Through RESETLOGS
  • Creating a Scheduler Job
  • Point-in-time recovery using RMAN
  • Using Scheduler Programs

  • Creating and Using Schedules
  1. Flashback database
  • Creating a Job Class
  • When to Use Flashback Technology
  • Prioritizing Jobs within a Window
  • Configuring Flashback Database
  • Viewing Job Execution Details
  • Monitoring Flashback Database
  • Creating a job that runs a program outside of the database
  • Best Practices for the Database and Flash Recovery Area

  • Flash Recovery Area Space Usage

  • Flashback Database Examples

  1. Recovering from User Errors

  • Recycle Bin

  • Flashback Dropped Tables Using EM

  • Querying Dropped Tables

  • Flashback Versions Query

  • Flashback Transaction Query

  • Using Flashback Versions Query and Flashback Transaction Query

  • Flashback Table

  • Using EM To Flashback Tables

Certification Details®
Course Name Exam No of (days)
Oracle SQL SQL Certification Exam 12c or 11g 1
Total 1
Course/Exam Name Duration Fees
DBA WS2 Course 40 hours or 15-20 classes Rs. 10,000 + 18% GST
Oracle WS2 Certification 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
Home SitemapTerms of Service Privacy Policy