SQL Data Analysis with TOAD

Course:   SQLT4
Duration:   4 Days
Level:   I
On our website at:   http://www.verhoef-training.com/courses/SQLT4.html
 
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.

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
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.

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.