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

Oracle Training


Trainer was well prepared. Course was very interesting.
Comment from Shared Services canada

1. Title

  • An Introduction to PL/SQL Development for Professional Developers (PLIDEV, 3 days)
    View PDF

2. Course Pre-requisites

  • Previous relational database development experience.

3. Target Audience

  • Professional developers who want to use PL/SQL

4. Dates and Pricing


Sep 27 to Sep 29, 2017$2,250.00/person
Dec 6 to Dec 8, 2017$2,250.00/person

5. Outline

Module 1: Creating Oracle Database Tables

Topic 1: Learning Objectives

Topic 2: Working with Schemas

Topic 3: Security

Topic 4: Creating and Managing Table

Topic 5: Creating Tables

Topic 6: Dealing with Time Zones

Topic 7: Datetime SQL Functions

Topic 8: What We Have Learned and the Real World

Module 2: Constraints and Sequences

Topic 1: Learning Objectives

Topic 2: Database Integrity and Constraints

Topic 3: Integrity Constraints

Topic 4: Primary Key Constraints

Topic 5: Referential Integrity: Foreign Keys

Topic 6: Modifying Tables and Constraints

Topic 7: Sequence

Topic 8: Retrieving Table and Constraint Information

Topic 9: What We Have Learned and the Real World

Module 3: Advanced SQL Querying

Topic 1: Learning Objectives

Topic 2: Multiple-Table Join Strategies

Topic 3: Using Multi-Table Joins

Topic 4: Creating and Using Sub-Queries

Topic 5: Creating and Using Stored Views

Topic 6: What We Have Learned and the Real World

Module 4: PL/SQL Language Fundamentals

Topic 1: Learning Objectives

Topic 2: PL/SQL Programming Basics

Topic 3: Entering PL/SQL Using SQL*Plus

Topic 4: PL/SQL Script Development Basics

Topic 5: PL/SQL Blocks

Topic 6: PL/SQL Data Types

Topic 7: PL/SQL Variables

Topic 8: Controlling PL/SQL Program Flow

Topic 9: What We Have Learned and the Real World

Module 5: PL/SQL Procedures and Functions

Topic 1: Learning Objectives

Topic 2: Overview

Topic 3: Creating Procedures and Functions

Topic 4: Simple Stored Procedures

Topic 5: Stored Procedures with Parameters

Topic 6: What We Have Learned and the Real World

Module 6: PL/SQL Packages

Topic 1: Learning Objectives

Topic 2: Creating PL/SQL Packages

Topic 3: Oracle WRAP Utility

Topic 4: What We Have Learned and the Real World

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