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

Oracle Training

Instructor very good at answering questions and is taking a "pulse" to see where we are at.
Comment from Shared Services Canada

1. Title

  • Mastering Relational Database Programming with PL/SQL (PLS201, 4 days)
    View PDF

2. Course Pre-requisites

  • Participants should have a good working knowledge of relational database theory and of the SQL language

3. Target Audience

  • Technology professionals who want to understand the structure and use of PL/SQL to manipulate the elements of a relational database.

4. Dates and Pricing

Jul 31 to Aug 3, 2017$2,775.00/person
Nov 6 to Nov 9, 2017$2,775.00/person

5. Outline

Module 1: The Oracle Development Environment

Topic 1: The Oracle RDBMS

Topic 2: Oracle Server Product Overview

Topic 3: PL/SQL Overview

Topic 4: Oracle Application Development Tools

Module 2: Configuring and Creating Oracle Databases

Topic 1: Oracle Relational DB Management System

Topic 2: Tablespaces, Datafiles and Control Files

Topic 3: Using the Oracle SQL*PLUS Utility

Topic 4: Optimizing Table Storage

Module 3: Creating Oracle Database Tables

Topic 1: Working with Schemas

Topic 2: Security

Topic 3: Creating and Managing Table

Topic 4: Creating Tables

Topic 5: Dealing with Time Zones

Topic 6: Datetime SQL Functions

Module 4: Structured Query Language (SQL) Basics

Topic 1: The SELECT Statement

Topic 2: Retrieving Aggregate Values

Topic 3: Adding Table Records Using INSERT INTO

Topic 4: Advanced Sub-Queries

Topic 5: Deleting Data

Module 5: Constraints and Sequences

Topic 1: Database Integrity and Constraints

Topic 2: Integrity Constraints

Topic 3: Primary Key Constraints

Topic 4: Referential Integrity: Foreign Keys

Topic 5: Modifying Tables and Constraints

Topic 6: Sequence

Topic 7: Retrieving Table and Constraint Information

Module 6: Advanced SQL Querying

Topic 1: Multiple-Table Join Strategies

Topic 2: Using Multi-Table Joins

Topic 3: Creating and Using Sub-Queries

Topic 4: Creating and Using Stored Views

Module 7: PL/SQL Language Fundamentals

Topic 1: PL/SQL Programming Basics

Topic 2: Entering PL/SQL Using SQL*Plus

Topic 3: PL/SQL Script Development Basics

Topic 4: PL/SQL Blocks

Topic 5: PL/SQL Data Types

Topic 6: PL/SQL Variables

Topic 7: Controlling PL/SQL Program Flow

Module 8: PL/SQL Procedures and Functions

Topic 1: Overview

Topic 2: Creating Procedures and Functions

Topic 3: Simple Stored Procedures

Topic 4: Stored Procedures with Parameters

Topic 5: What We Have Learned and the Real World

Module 9: PL/SQL Packages

Topic 1: Creating PL/SQL Packages

Topic 2: Oracle WRAP Utility

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