Toad Data Point

Course:  TOADAN
Duration:  3 Days
Level:  I
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.

« Hide The Details
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.

« Hide The Details
Related Courses
Code Course Title Duration Level
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.

Schedule For This Course
11/17/2014
Philadelphia, PA
11/17/2014
Memphis, TN
12/1/2014
Charleston, WV
2/9/2015
Indianapolis, IN
4/6/2015
Pittsburgh, PA
6/1/2015
Phoenix, AZ
Notify me the next time this course is confirmed!
Can't find the course you want?
Call us at 800.533.3893, or
email us at info@verhoef.com