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

Oracle Training


Great interaction with the instructor. The instructor was able to address my specific questions very well.
Comment from DND

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


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