Toad for Oracle DBAs - Database Maintenance - Free
-
Description
This self-paced, web-based training course is available for FREE to all users. This course is based on Toad for Oracle 12.5 or later. If you have an older release of Toad for Oracle, please visit our Support portal to upgrade. If you have any questions, please contact your local Sales Representative for further details contact us
This course is for Oracle DBAs who needs to learn how to best leverage the Toad DBA Suite for Oracle for diagnosing and resolving database performance issues and efficiently managing complex database environments.
There is a test that correlates to the course. This test is just a knowledge check of what you have learned.
Click Here to launch the test.
NOTE: The certificate of completion is currently NOT available at this point.
-
Duration: 2-3 hrs
-
Audience
Oracle DBAs managing Oracle instances and Real Application Cluster (RAC) environments -
Prerequisites
A good working knowledge of Toad for Oracle or the completion of the Toad for Oracle Fundamentals course is necessary. A solid understanding of Oracle database administration tasks is necessary.
Browser Requirements:
The courseware has been tested to run on the following browsers:
- Google Chrome v32 or higher
- FireFox 26 or higher
- Internet Explorer 9 or higherEnable automatic popups and adding the following sites to the exceptions list:
*.quest.com
*.software.quest.comhttps://www.wikihow.tech/Add-a-Website-to-Trusted-Sites
Re-launch browser
If the course or simulations within the course do not work, try to launch the course using a different web browser.
-
Objectives
This course will cover how to:
- Install and configure the Toad DBA Suite for Oracle
- Customize the look and feel of the various components to suit the needs of the participant
- Understand the components of the Toad DBA Suite for Oracle
- Use the DBA functions of the Suite to automate frequent and repetitive tasks, perform and schedule database maintenance operations
- Use the various browsers and monitoring components to view database activity
- Use Toad’s reporting utilities to manage and track database objects
-
Topics
Introduction
- Overview of the Toad DBA Suite for Oracle
- Navigating the course
Installation and Configuration Overview
- Installation requirements for each component of the Toad DBA Suite for Oracle
- User account configuration requirements, database objects and privileges required
- Understanding the interaction of the bundle of tools within the Suite
Maintenance Utilities (Health Check, Jump Search, RMAN, Database Browser, Backup Reporter)
- Collectively view all managed databases and enable the drill down to objects and execution of tasks all within the same window
- Simplify routine tasks, including the administration of users, roles, object privileges, storage and more
- Automate the management and maintenance reporting of overall database health (including security vulnerabilities), schemas, index rebuilds, etc.
- Collaborate on the use of shared scripts, etc. (Project Manager)
- Initiate RMAN backups on managed databases, report on RMAN backups
- Jump Search
Session Browser
- Identifying biggest consumers of resources with Top Session finder
- Starting and stopping Oracle trace and viewing trace file contents
- Pinpoint the source of long-running sessions & resource-intensive SQL
- Identify problematic SQL directly from source code
Toad AWR and StatsPack browsers
- Launching the AWR browser
- Launching the StatsPack browser
- Understanding the information presented by the AWR and StatsPack browsers
- Hands-on practice simulation to learn how to use and understand AWR and StatsPack browsers
-
Format
Students complete this course through self-paced, web-based training. The course presents product functionality and provides the participant the opportunity for hands-on practice resolving real-world problems through use case driven simulations. Each lesson contains closing questions allowing for a knowledge check. The lessons in the course build on each other and each new lesson allows the participant the opportunity to reinforce what they have learned in previous lessons. There is a test that correlates to the course. Upon passing this test, the participant has the opportunity to achieve a Toad for Oracle Advanced DBA Certificate of Completion.
-
Special Notes
This self-paced, web-based training course is available for FREE to all Toad World registered users. Upgrading your current Toad version to 12.5 or higher will entitle you to this offer. Please contact your local Sales Representative for further details contact us.
