Toad & Toad Data Point Training

Offering Toad and Toad Data Point Training Courses

TOAD TRAINING

LightSpeed PM

COURSE DESCRIPTION:

This is a 1 day class (6-hours in duration) that includes lecture, lab and testing for up to 12 students.

The instructor will illustrate the latest features of Toad necessary to view, extract and manipulate data within the Oracle database. This workshop covers all of the features necessary to develop, manipulate and debug PL/SQL code, develop and tune SQL statements, using Query Builder and ER (Entity Relationship) tools and discover useful features of Toad. Dan will also show how to see the data relationships of the application data and how to view and save this data.

Lectures are supported by hands on student lab exercises.

AUDIENCE:

This course is intended for Power Users and Business Analysts.

PREREQUISITES:

None.

ATTENDEES RECEIVE:

  • Study guide with useful real world examples that includes all presentations and relevant white papers.
  • White papers on using Toad, Toad Debugger and Toad Profiler​

TOPICS COVERED:

  • Installation, Migration and Connection Topics
  • Working with SQL: viewing and changing data, creating reports, extracting data, discoverin all of the help available, creating SQL with minimal key strokes using templates and auto-substitution)
  • Schema Browser Tips and Techniques (viewing and changing data, creating reports, extracting data, working with scripts, working with spreadsheets, etc.
  • Working with PL/SQL (develop, execute and debug PL/SQL routines, work with templates to create procedures, functions and triggers
  • Query Builder, ER Diagrammer, Master Detail Browser (viewing application data relationships and viewing related data)
  • Tuning with Toad including explain plans but more in areas of finding problem SQL using Toad's interface to wait events and Toad's session interface in SQL as well as using the Oracle Trace Facility
  • Additional SQL performance tuning topics that Toad is very useful for
  • Using the new Fast Reports reporting tool
  • Using the new Automation Designer
  • Miscellaneous topics include Toad configuration, Toad session monitoring, viewing useful data dictionary information, database compare, export, etc.
  • Various methods of creating DDL and data-oriented scripts.​
LightSpeed PM

COURSE DESCRIPTION:

This is a 2 day class (6-hours in duration) that includes lecture, lab and testing for up to 12 students.

This course introduces students to the querying and analytical capabilities of using Toad Data Point and Toad Intelligence central.

Students will learn to load, modify and save data; create spreadsheets and other delivers; and refine and run ad hoc queries. They will learn to produce individual ad hoc reports and make these reports and information easy to access via dash boards.

Lectures are supported by hands on student lab exercises.

AUDIENCE:

This course is intended for Power Users and Business Analysts.

PREREQUISITES:

None.

ATTENDEES RECEIVE:

Study guide with useful real world examples that includes all presentations and relevant white papers.

RECOMMENDED SUPPLEMENTAL COURSES:

SQL for End Users -- Includes SQL, ANSI SQL and an overview of Analytical SQL (Oracle database only)

TOPICS COVERED:

  • Introduction/Analytics Overview
  • Toad Data Point and data warehouse overview
  • Introduction to Toad Data Point and Toad Intelligence Central
  • Toad Data Point Quick Start
  • Working with various data sources
  • Transform and cleanse data
  • Accessing data in various data stores and formats
  • Apply Joins and Conditions
  • Introduction to Query Builder
  • Data Manipulation including transform, cleanse, views and snapshots
  • Working with SQL, functions and code snippets
  • Visualization Techniques in formatting Data, Views and Graphs
  • Export/Import of connections and other maintenance items
  • Automation and scheduling for any Toad Data Point task
  • Includes Data Compare, Snapshot management, Project Manager
  • Working with Toad Intelligence Central​
LightSpeed PM

COURSE DESCRIPTION:

This is a 1 day class (6-hours in duration) that includes lecture, lab and testing for up to 12 students.

This course is tailored for the topics needed to create Workflows as found in other BI tools such as Hyperion.  This course will cover Toad Data Point installation, the workflow itself, and the Query Builder.

This course is useful for the power user that needs to use TOAD Data Point to perform database queries and create spreadsheets and reports.  This hands-on course is aimed at the professional who wishes to increase their individual or their group’s productivity by utilizing Toad Data Point.

Lectures are supported by hands on student lab exercises.

AUDIENCE:

The focus of this course is to give a working knowledge of SQL to non-IT people, or to people who are new to the relational database world.

PREREQUISITES:

None.

ATTENDEES RECEIVE:

  • Study guide with presentations
  • A hands-on opportunity to learn more about SQL

​COURSE OUTLINE:

  • Introduction to SQL
    1. Introduction to Toad/Toad Data Point
    2. Introduction to SQL
  • Advanced SQL Topics
    1. Functions
    2. Advanced SQL
    3. Joins
    4. ANSI SQL Syntax
    5. Sub queries
    6. Group Functions
  • Referential Integrity
LightSpeed PM

COURSE DESCRIPTION:

This is a 2-day class (6-hours per day) that includes lecture, lab and testing for up to 12 students.

This course is tailored for the topics needed to create Workflows as found in other BI tools such as Hyperion.  This course will cover Toad Data Point installation, the Workflow itself, and the Query Builder.

This course is useful for the power user that needs to use Toad Data Point to perform database queries, create spreadsheets and reports.  This hands-on course is aimed at the professional who wishes to increase their individual or their group’s productivity by utilizing Toad Data Point.

Lectures and topics are enhanced with live illustrations and hands-on exercises.

AUDIENCE:

This course is intended for Power Users and Business Analysts.

PREREQUISITES:

None

ATTENDEES RECEIVE:

Study guide with useful real world examples that includes all presentations and relevant white papers.

COURSE OBJECTIVES:

  • Installation of Toad Data Point
  • Review of Configuration Options
  • Major Features of Toad Data Point Workflows (building up to 4 workflows together)
  • Toad Intelligence Central
  • Query Builder and SQL Editor

COURSE OUTLINE:

Day 1

  • Overview/Introduction to Toad Data Point and Data Warehouse
    • Analytics
    • Creating Workflows
  • Working with the Query Builder
  • Toad Data Point Tips and Techniques
  • Data best use practices to consider
  • Examples for Excel and Pivot Table worksheets
  • Dimensional Views, a hidden gem for data analysis
  • Query Editor
    • Adapt your SQL from other applications easily

Day 2

  • Traditional Interface
    • Storing your data in a subset form with automatic refresh
    • Automation
    • ODBC/Import/Export
    • Data Compare
  • Best Practices
  • Additional Toad Intelligence Central Topics

ABOUT THE TRAINER

​Our Oracle training solutions are built to empower DBAs and SQL Developers to be successful.

Training Specialist Dan Hotka is an Oracle ACE Director Alumni (a recognized outside expert/evangelist on Oracle Products) and has over three decades of experience with Oracle Products. Dan is well published with 14 Oracle books and over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs and speaks at Oracle conferences and user groups around the world.

New Project (31)
LightSpeed PM