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

PLSQL Training

It was an excellent course, great deal of learning and instructor is very motivated and knowledgeable to present this course. Thank you!
Comment from Statistics 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