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

Oracle Training


The instructor appeared to be very knowledgeable with regard to all aspects of the course. He was quick to point out features which were new or had changed since previous versions, and called specific attention to information he thought was particularly relevant to us.
Comment from DND

1. Title

  • The Complete PL/SQL Programming Course (ORASQLCP, 4 days)
    View PDF

2. Course Pre-requisites

  • Previous experience with SQL syntax

3. Target Audience

  • Programmers who want to learn PL/SQL

4. Dates and Pricing


Oct 30 to Nov 3, 2017$2,775.00/person

5. Outline

Module 1: The Oracle Development Environment

Topic 1: Learning Objectives

Topic 2: The Oracle RDBMS

Topic 3: Oracle Server Product Overview

Topic 4: PL/SQL Overview

Topic 5: Oracle Application Development Tools

Topic 6: What We Have Learned and the Real World

Module 2: Configuring and Creating Oracle Databases

Topic 1: Learning Objectives

Topic 2: Oracle Relational DB Management System

Topic 3: Tablespaces, Datafiles and Control Files

Topic 4: Using the Oracle SQL*PLUS Utility

Topic 5: Optimizing Table Storage

Topic 6: What We Have Learned and the Real World

Module 3: 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 4: Structured Query Language (SQL) Basics

Topic 1: Learning Objectives

Topic 2: Retrieving Records

Topic 3: Retrieving Aggregate Values

Topic 4: Adding Table Records Using INSERT INTO

Topic 5: Advanced Sub-Queries

Topic 6: Deleting Data

Topic 7: What We Have Learned and the Real World

Module 5: 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 6: 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 7: 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 8: 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 9: 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

Module 10: Oracle Database Triggers

Topic 1: Learning Objectives

Topic 2: Triggers

Topic 3: Creating Triggers

Topic 4: Using Triggers for Logging

Topic 5: System Triggers

Module 11: Working with PL/SQL Records

Topic 1: Learning Objectives

Topic 2: PL/SQL Records

Topic 3: Defining Record Types in PL/SQL

Topic 4: Defining Record Types as Object Types

Topic 5: What We Have Learned and the Real World

Module 12: PL/SQL Collections

Topic 1: Learning Objectives

Topic 2: Introduction

Topic 3: PL/SQL Collections Overview/Types

Topic 4: Working with Varrays

Topic 5: Using Nested Tables

Topic 6: Using Associative Arrays

Topic 7: Collection Reference

Module 13: PL/SQL Error Handling

Topic 1: Learning Objectives

Topic 2: Oracle Errors

Topic 3: Custom Errors

Topic 4: Exception Handling

Topic 5: Raising Exceptions

Topic 6: Handling User Exceptions

Topic 7: Handling PL/SQL Exception

Topic 8: Propagating Exception

Topic 9: What We Have Learned and the Real World

Module 14: Object Oriented Programming with PL/SQL

Topic 1: Learning Objectives

Topic 2: PL/SQL and Object Oriented Programming

Topic 3: Creating Objects

Topic 4: Methods

Topic 5: Object Table

Topic 6: Using DML with Objects

Topic 7: What We Have Learned and the Real World

Module 15: XML Processing

Topic 1: Learning Objectives

Topic 2: Processing XML Data

Topic 3: Creating XML Documents

Topic 4: Validating XML Data against a Schema

Topic 5: A Few Examples

Topic 6: What We Have Learned and the Real World

Module 16: Oracle and Java

Topic 1: Learning Objectives

Topic 2: Preparing the Environment

Topic 3: Using loadjava and dropjava

Topic 4: Managing Java

Topic 5: Using DBMS_JAVA and DBMS_JAVA_TEST

Topic 6: Publishing and Using Java

Topic 7: A Few Useful Examples

Topic 8: What We Have Learned and the Real World

Module 17: Best Practices and Performance Tuning

Topic 1: Learning Objectives

Topic 2: Overview

Topic 3: Optimization and Performance Tuning

Topic 4: Using Indexes

Topic 5: Common Mistakes and their Solutions

Topic 6: 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