Toad Data Point
Course: TOADAN
Duration: 3 Days
Level: I
On our website at:
http://www.verhoef-training.com/courses/TOADAN.html
Course Summary
This course teaches the student how to use TOAD with Data Warehouses and Analytical reports. The student will learn how to save time in Query development and simplify daily tasks. Greater value and performance from their database environment will be one of the major benefits to the student. Time will be saved in Data exploration and quantitative analysis.
Every day tips and tricks are included that will cover the Object Explorer, Connections, Queries, Reports, and Automation. Best practices in Query and Report are included throughout the course.
Topics Covered In This Course
Overview
- Toad's Big Picture
- Tasks
- Typical flow
- Setup
- Database considerations
- Analytics and Toad
- SQL review
- Time saving considerations
Connections
- ODBC
- Other options
- Vendor specifics
- Shared Connections
- Performance considerations
Working with Objects
- Steps to Locate Objects
- Object Explorer
- Filter Databases and Objects
- The Database Explorer and tables
- Search
- Database Diagram
- Query Template
- Browsing Related Tables
- Best practices
Query Processing
- Building a Query visually
- Variables
- Filters
- Cross-Connections
- Design Considerations
- Performance options
- Limitations
- Reverse Engineer Queries
- Query Builder options
- Subqueries and Joins
- Editing SQL
- SQL recall
- Editor Options
- Shortcuts
- Viewing Result Sets
- Code Snippets
- Troubleshooting
- Best Practices
- Comparing Differences in Data
- Exporting Data
Report Considerations
- Report Wizard
- Updating Fields
- Formatting
- Report Bands
- Report Controls
- Report Management by Database Type
- DB2
- ODBC
- Oracle
- SQL Server
- Publishing Reports
Automation and other Options
- Queries
- Email
- Tasks
- Macros
- Database Tasks
- File Tasks
- System Tasks
- Variables
- Loops
- Row Count Field Logic Syntax
- Executing Scripts
- OLAP Cubes
- SQL Trace usage
- Explain Plan
- Job Manager
What You Can Expect
At the end of this course, students will be able to:
- Create and modify Cross-Platform Queries.
- Use Advanced Analytics Library for mathematical and statistical functions for pattern discovery, clustering, and regression.
- Use an Embedded Data Store to store and automate frequently analyzed data through an embedded database.
- Work with Automation Engine to schedule routine tasks to increase productivity and develop sophisticated workflows to support advanced projects.
- Compare and synchronize data between different data sources to ensure validity.
- Use the Visual Query Builder to develop single-source and cross-platform SQL queries without extensive SQL experience.
- Use the SQL IDE to write SQL statements in a customizable editor that provides SQL Complete, automatic formatting, instant SQL recall, as well as a variety of other features to make writing SQL easier.
- Use the Data Cleansing Area to transform and cleanse result sets including calculations, columns, and groupings, and find duplicates.
- Work with the Entity Relationship Diagrammer and Data Browsers to visualize and annotate tables, create relationship templates, view master-detail relationships and browse database tables and objects.
- Create Charts and Reports.
- Profile data.
- Use the Import/Export Utility Wizard to load and unload data efficiently using a variety of formats.
Who Should Take This Course
Business Intelligence Professionals, Data Analysts, and anyone interested in using Toad with Data Warehouses.
Training Style
Instructor led with 50% lecture and 50% lab.
About the instructor:
The course is taught by an instructor with experience in SQL, Dimensional Modeling, Analytical Reporting, KPI's, and OLAP usage. Experience in TOAD is over 10 years starting with Oracle 8i / TOAD version 6.
Related Courses
| Code |
Course Title |
Duration |
Level |
|
SQLT4 |
SQL Data Analysis with TOAD |
4 Days |
I |
Details |
TOADOR |
Toad For Oracle |
3 Days |
I |
Details |
Every student attending a Verhoef Training class will receive
a certificate good for $100 toward their next public class taken
within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a
single student in any of our public or web-based classes.
Contact your account manager or our sales office for details.
