SETC Training844-434-7382
 Find a Course: 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

PLSQL Training

This was a great learning experience.
Comment from Public Safety Canada

1. Title

  • Mastering SQL for Data Analysis with Oracle Toad (Beginner Level) (SQLTO, 4 days)
    View PDF

2. Course Pre-requisites

  • General understanding of relational database concepts

3. Target Audience

  • IT Professionals who want to learn how to write PLSQL for an Oracle environment using TOAD

4. Dates and Pricing

Jun 13 to Jun 16, 2017$2,775.00/person
Sep 5 to Sep 8, 2017$2,775.00/person
Dec 5 to Dec 8, 2017$2,775.00/person

5. Outline

Module 1: Working with Toad

Topic 1: Overview of the Toad Environment

Topic 2: Organizing File with Toad

Topic 3: Writing Scripts with Toad

Topic 4: Debugging Scripts with Toad

Topic 5: Exploring Toad’s Functional Capabilities

Topic 6: Configuring Toad to Work for You

Module 2: Relational Database Essentials

Topic 1: Relational Database Concepts » Tables, Fields and Rows

Topic 2: Understanding Data Normalization

Topic 3: About Entity Integrity: Primary Keys

Topic 4: About Referential Integrity: Foreign Keys

Topic 5: About Domain Integrity: Checks and Defaults

Topic 6: Overview of Oracle Data Storage Structures and Performance Implications

Module 3: Mastering the Data Retrieval: The Basics

Topic 1: The Basic Structure

Topic 2: About Statement Processing

Topic 3: Working with Aliases and Headers

Topic 4: Writing Where Statements

Topic 5: Performing Pattern Matching

Topic 6: Querying for Ranges

Topic 7: Writing Predicates for Specific Data Types

Topic 8: Sorting Data

Topic 9: Retrieving Unique Values

Topic 10: Making use of Union

Module 4: Mastering Data Retrieval: Working with Multiple Tables

Topic 1: The Anatomy of the Statement

Topic 2: Working with Point and Range Queries

Topic 3: Writing Multi-Table Statements: Exploring Joins

Topic 4: Exploring Join Types: Inner Outer and Cross

Topic 5: Optimizing Joins

Topic 6: Using Regular Sub-Queries

Topic 7: Using Correlated Sub-Queries

Topic 8: Comparing Performance Profiles

Module 5: Mastering Aggregate Calculations

Topic 1: The Anatomy of Aggregate Value Statements

Topic 2: Exploring Group By

Topic 3: Exploring Oracle Aggregate Functions

Topic 4: Dealing with Multiple Tables

Module 6: Modifying Data

Topic 1: Working with New Data

Topic 2: Working with Data Modification

Topic 3: Working with Data Suppression

Topic 4: Working with Multiple Records

Topic 5: Performing Bulk Operations

Module 7: SQL Common Tasks

Topic 1: Working with Automatic Increments

Topic 2: Working with Strings

Topic 3: Working with Dates and Time

Topic 4: Working with NULL Values

Topic 5: Working with Numeric Data Types

Module 8: Advanced Tasks

Topic 1: Identifying Duplicate Values

Topic 2: Generating Rank

Topic 3: Generating Median

Topic 4: Generating Running Totals

Topic 5: Generating Percent To Total

Topic 6: Generating Cumulative Percent To Total

Module 9: Creating Stored Procedures

Topic 1: The Performance Advantages of Stored Procedures

Topic 2: Creating Stored Procedures

Topic 3: Working with Input Parameters

Topic 4: PLSQL Programming Essentials

Topic 5: Storing Stored Procedures

Topic 6: Putting it All Together

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette