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

Oracle Training


Course has been tailored to our needs. We are learning what we need for everyday work.
Comment from Giant Tiger

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


May 10 to May 12, 2017$2,250.00/person
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