• Support
• Educational Services
• Toad for Oracle
• Toad for Oracle Fundamentals Training - Free

Toad for Oracle Fundamentals Training - 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

  Self-paced, web-based course designed for Oracle professionals interested in learning how to use Toad. Contains 6-8 hours of material, instructing learners on the core features of Toad for Oracle, so they can make the most out of their investment in the product.

  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: 6-8 hrs

  Launch Course

• Audience

  General Oracle Users, Developers, and DBAs

• Prerequisites

  Prior knowledge of Toad for Oracle is not necessary but a high-level understanding of Oracle is required for this course.

   

  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 higher

  Enable automatic popups and adding the following sites to the exceptions list:

  *.quest.com
  *.software.quest.com

  https://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

  Upon completion of this course, the learner will be able to:

  • Install and configure TOAD for Oracle
  • Work with options and customizations
  • Use the core functions of the product including Schema Browser, Editor, Data Grids, Project Manager, Debugger, Search Utilities, Query Builder, Visual Object Editors, Script Manager and Community Sites.
  • Manage connections to the Database
  • Navigate the Oracle Database
  • Create and alter objects
  • Manage scripts and database artifacts
  • Work with Data Grids
  • Use the Editor to build better code faster
  • Build queries visually
  • Use Toad for data management
  • Use Toad reporting
  • Use time savings utilities

• Topics

  Introduction

  • Video introducing the business benefits of using Toad for Oracle
  • Overview of the Toad Family of products
  • Navigating the course

  Lesson 1 - Introduction to Toad Features

  • Help Function
  • Release Note
  • About ToadWorld
  • Hands-on practice simulation to learn how to use the Help Function, Release Notes, and ToadWorld

  Lesson 2 - Installation and Configuration

  • How to access SupportLink to download Toad
  • How to run the installer/installer options
  • Explanation of user guides
  • Hands-on practice simulation to learn how to access SupportLink to download Toad, how to run the installer/installer options, and explanation of user guides

  Lesson 3 - Managing Database Connections

  • How to create and configure database connections
  • How to edit/configure the oracle client settings
  • Hands-on practice simulation to learn how to create and configure database connections and edit/configure the oracle client settings

  Lesson 4 - Utilities

  • Automation Designer
  • Script Manager
  • Exporting data
  • File Control Logic
  • Quest Script Runner
  • Hands-on practice simulation to learn how to use Automation Designer, Script Manager, Exporting data, File Control Logic, and Quest Script Runner

  Lesson 5 – Navigating the Oracle Database

  • Project Manager
  • Code Road Map
  • ER Diagrammer
  • Object Compare
  • Schema Browser
  • Hands-on practice simulation to learn how to use Project Manager, Code Road Map, ER Diagrammer, Object Compare and Schema Browser

  Lesson 6 – Creating and Altering Objects

  • Expanding use of Schema Browser
  • Query Builder
  • Working with DDL scripts
  • Scheduling
  • Hands-on practice simulation to learn how to use Schema Browser, Query Builder, work with DDL scripts, and using the Toad scheduler

  Lesson 7 – Working with Data Grids

  • Sort/group/filter/edit/export data
  • Generate data reports
  • Use Automation Designer to schedule these tasks
  • Hands-on practice simulation to learn how to Sort/group/filter/edit/export data, Generate data reports, and Use Automation Designer to schedule these tasks

  Lesson 8 – Building Better Code Faster

  • Code Snippets
  • Executing sql scripts
  • Viewing Explain Plans
  • Formatter
  • Make/strip code
  • Sql recall
  • Debugger
  • Hands-on practice simulation to learn how to use Code Snippets, how to Execute sql scripts, View Explain Plans, use the Formatter, Make/strip code, use Sql recall, and use the Debugger

  Lesson 9 – Visual Query Building

  • Building sql statements
  • Reverse engineer sql statements
  • Create where clauses
  • Work with Bind Variables
  • Creating joins and sub-queries
  • Populating tables with sample data
  • Generate reports on data
  • Hands-on practice simulation to learn how to Build sql statements, Reverse engineer sql statements, Create where clauses in your sql statements, Work with Bind Variables, Create joins and sub-queries, Populate tables with sample data, and Generate reports on data

  Lesson 10 – Data Management

  • Importing/exporting data
  • Use the Data duplicates wizard
  • Compare data
  • Generate data
  • View and report on data
  • Hands-on practice simulation to learn how to Import/export data, Use the Data duplicates wizard, Compare data, Generate data, and View and report on data

• Format

  Self-paced, web-based training.

• Special Notes

  DOWNLOAD COURSE OUTLINE

  Please contact your local Sales Representative for further details contact us