SQL Data Analysis with TOAD

Course: SQLT4

Duration: 4 Days

Level: I

Course Summary

SQL Data Analysis with Toad explores the SQL language with Oracle and Toad. The training includes SQL basics including filtering, sorting, single and multi-table join strategies, subqueries, correlated subqueries & more. The course also covers stored procedures and discusses common SQL tasks in an Oracle environment. Students will leave this course armed with the required skills to work with SQL and TOAD on the job, right after training ends.

« Hide The Details

Topics Covered In This Course

Working with Toad

Overview of the Toad Environment
Organizing File with Toad
Writing Scripts with Toad
Debugging Scripts with Toad
Exploring Toad?s Functional Capabilities
Configuring Toad to Work for You

Relational Database Essentials

Relational Database Concepts Tables, Fields and Rows
Understanding Data Normalization
About Entity Integrity: Primary Keys
About Referential Integrity: Foreign Keys
About Domain Integrity: Checks and Defaults
Overview of Oracle Data Storage Structures and Performance Implications

Mastering the Data Retrieval: The Basics

The Basic Structure
About Statement Processing
Working with Aliases and Headers
Writing Where Statements
Performing Pattern Matching
Querying for Ranges
Writing Predicates for Specific Data Types
Sorting Data
Retrieving Unique Values
Making use of Union

Mastering Data Retrieval: Working with Multiple Tables

The Anatomy of the Statement
Working with Point and Range Queries
Writing Multi-Table Statements: Exploring Joins
Exploring Join Types: Inner Outer and Cross
Optimizing Joins
Using Regular Sub-Queries
Using Correlated Sub-Queries
Comparing Performance Profiles

Mastering Aggregate Calculations

The Anatomy of Aggregate Value Statements
Exploring Group By
Exploring Oracle Aggregate Functions
Dealing with Multiple Tables

Modifying Data

Working with New Data
Working with Data Modification
Working with Data Suppression
Working with Multiple Records
Performing Bulk Operations

SQL Common Tasks

Working with Automatic Increments
Working with Strings
Working with Dates and Time
Working with NULL Values
Working with Numeric Data Types

Advanced Tasks

Identifying Duplicate Values
Generating Rank
Generating Median
Generating Running Totals
Generating Percent To Total
Generating Cumulative Percent To Total
Creating Stored Procedures
The Performance Advantages of Stored Procedures

Creating Stored Procedures

Working with Input Parameters
PLSQL Programming Essentials
Storing Stored Procedures
Putting it All Together

What You Can Expect

Working with Toad
Relational Database Essentials
Mastering the Data Retrieval: The Basics
Mastering Data Retrieval: Working with Multiple Tables
Mastering Aggregate Calculations
Modifying Data
SQL Common Tasks
Advanced Tasks
Creating Stored Procedures

Who Should Take This Course

This is an introductory-level course. Students do not require specific scripting or database knowledge to attend, however all attendees should be comfortable with working with a PC.

Recommended Prerequisites

This is an introductory-level course. Students do not require specific scripting or database knowledge to attend, however all attendees should be comfortable with working with a PC.

Training Style

This course is approximately 50% hands-on lab to 50% lecture ratio, combining engaging lecture, demos, group activities and discussions with machine-based student labs and exercises. Student machines are required.

« Hide The Details

Related Courses

Code	Course Title	Duration	Level
TOADAN	Toad Data Point	3 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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

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 [email protected]