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

PLSQL Training

Comment from Shared Services Canada

1. Title

  • Mastering SQL for Data Analysis with Oracle Toad (Intermediate-Advanced Level) (SQLTOA, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous experience in an Oracle environment and good understanding of PLSQL basics

3. Target Audience

  • IT professionals who want to learn how to use SQL for data analytics using Toad in an Oracle environment

4. Dates and Pricing

Aug 29 to Sep 1, 2017$2,775.00/person
Nov 7 to Nov 10, 2017$2,775.00/person

5. Outline

Module 1: Working with Toad (Brief Overview)

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: Retrieving Data

Topic 1: The Anatomy of the Retrieving Data

Topic 2: Writing Effective Where Statements

Topic 3: Working with Point and Range Queries

Topic 4: Writing Multi-Table Statements: Exploring Joins

Topic 5: Using Regular Sub-Queries

Topic 6: Using Correlated Sub-Queries

Topic 7: Comparing Performance Profiles

Module 4:  Mastering Aggregate Calculations

Topic 1: The Anatomy of Aggregate Value Calcualtions

Topic 2: Exploring Group By

Topic 3: Exploring Oracle Aggregate Functions

Topic 4: Dealing with Multiple Tables

Module 5: Modifying Data

Topic 1: Adding Data

Topic 2: Modifying Data

Topic 3: Removing Data

Topic 4: Working with Multiple Records

Topic 5: Performing Bulk Operations

Module 6: 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 7: 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 8: Mastering Oracle Analytics

Topic 1: About Statistics

Topic 2: About Regular Tables and IOTs

Topic 3: Generating Execution Plans

Topic 4: Performance Considerations: Exploring Sorting Strategies

Topic 5: Performance Considerations: Exploring Filtering Strategies

Topic 6: Performance Considerations: Exploring Join Strategies

Topic 7: Performance Considerations: Using Parallel Queries

Module 9: Working with Optimizer Hints

Topic 1: Overview of Optimizer Hints

Topic 2: Join Order Hints

Topic 3: Join Method Hints

Topic 4: Access Path Hints

Topic 5: Parallelization Hints

Module 10: 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