Offering Toad and Toad Data Point Training Courses
TOAD TRAINING
TOAD Data Point Workflow Interface (2 Days)
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 End Users, Power
Users and Business Analysts.
PREREQUISITES:
None
RECOMMENDED
SUPPLEMENTAL COURSES:
SQL for End Users: An advanced
ANSI SQL training course that
utilizes Toad Data Point.
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
- These lectures include labs for hands-on training and group exercises
COURSE OUTLINE:
Day 1
- Overview and Introduction to Toad Data Point Workflow Interface
- Group exercises building workflows
- Building data access via the Query Builder
- Transform and Cleanse Data
- Save data to Local Storage and to the Central Repository (Toad Intelligence Central)
- Creating and Emailing Spreadsheets/PDF reports
- Learn about Dimensional Views – a hidden gem for analytical reporting
- Saving and Scheduling workbooks
- Toad Data Point Best Practices
Day 2
- Deep dive into more advanced topics
- Storing data in a subset form with automatic refresh
- SQL Editor Topics
- Automation
- Sub Query Processing
- Date Processing
- Data Compare
- SQL Editor
- Reports
- Toad Intelligence Administration Topics
- Data Compare
- Snapshot Management
TOAD Data Point Traditional Interface (2 Days)
COURSE DESCRIPTION:
This course consists of two 6-hour days that includes lectures, labs and testing for up to 12 students per class.
This course introduces students to the querying and analytical capabilities of using Toad Data Point and Toad Intelligence central.
Attendees 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: End-Users, Power Users, and Business Analysts.
PREREQUISITES:
None.
RECOMMENDED SUPPLEMENTAL COURSES:
SQL for End Users: An advanced ANSI SQL training course that utilizes Toad Data Point.
Course Outline:
Day 1
- Overview/Introduction to Toad Data Point Traditional Interface
- Group exercises building results
- Building data access via the Query Builder
- Transform and Cleanse Data
- Save data to Local Storage and to the Central Repository (Toad Intelligence Central)
- Creating and Emailing Spreadsheets/PDF reports
- Dimensional Views
- Saving and Scheduling workbooks
- Toad Data Point Best Practices
Day 2
- Deep dive into more advanced topics
- Storing data in a subset form with automatic refresh
- SQL Editor Topics
- Automation
- Sub Query Processing
- Date Processing
- Data Compare
- SQL Editor
- Workflow Interface
- Build a simple Workflow to illustrate this interface
- Reports
- Toad Intelligence Administration Topics
- Data Compare
- Snapshot Management
SQL for End-Users (1-Day)
COURSE DESCRIPTION:
This is a 1-Day class (6 hours) that includes lecture, lab and testing for up to 12 attendees.
The more your staff knows about SQL, the better they will be able to perform their job.
This course is tailored for the person who needs to know more about the SQL language. This SQL course utilizes Toad Data Point, but the topics learned can be utilized in any Relational Database and some Microsoft Office products.
This hands-on course is aimed at the professional who wishes to increase their individual or their group’s productivity with a working knowledge of the SQL query language.
AUDIENCE:
This course is intended for: End-Users, Power Users, and Business Analysts.
PREREQUISITES:
None.
COURSE OUTLINE:
- Introduction to SQL
- Introduction to Toad Data Point
- Introduction to SQL
- Advanced SQL Topics
- Functions
- Advanced SQL
- Joins
- ANSI SQL Syntax
- Sub queries
- Group Functions
- Referential Integrity
Toad Tips and Tricks
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:
Intended for Developers and Database Administrators
PREREQUISITES:
None.
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.
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.
