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

PLSQL Training

The instructor is skillful and is very excited and interested to know that student understands and benefits from the course. He never leaves any question unanswered.
Comment from Statistics 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

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