PLSQL Training: The Complete PL/SQL Programming Course


Course Delivery

Live Instructor-Led Training

Course Description

The course The Complete PL/SQL Programming Course (PLSQL Training) is a detailed exploration of the PL/SQL language and it many nooks and crannies. The course covers basic & advanced SQL techniques and PL/SQL programming fundamentals. The training also includes cursors, triggers, stored procedures & functions, sequences and packages. Finally, the course discusses object oriented programming, Java integration, XML processing & performance tuning with indexes. This PL/SQL course will teach you how to write great PL/SQL code.

Course Dates and Pricing


Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

Course Outline

The Oracle Development Environment

Learning Objectives
The Oracle RDBMS
Oracle Server Product Overview
PL/SQL Overview
Oracle Application Development Tools
What We Have Learned and the Real World

Configuring and Creating Oracle Databases

Learning Objectives
Oracle Relational DB Management System
Tablespaces, Datafiles and Control Files
Using the Oracle SQL*PLUS Utility
Optimizing Table Storage
What We Have Learned and the Real World

Creating Oracle Database Tables

Learning Objectives
Working with Schemas
Security
Creating and Managing Table
Creating Tables
Dealing with Time Zones
Datetime SQL Functions
What We Have Learned and the Real World

Structured Query Language (SQL) Basics

Learning Objectives
Retrieving Records
Retrieving Aggregate Values
Adding Table Records Using INSERT INTO
Advanced Sub-Queries
Deleting Data
What We Have Learned and the Real World

Constraints and Sequences

Learning Objectives
Database Integrity and Constraints
Integrity Constraints
Primary Key Constraints
Referential Integrity: Foreign Keys
Modifying Tables and Constraints
Sequence
Retrieving Table and Constraint Information
What We Have Learned and the Real World

Advanced SQL Querying

Learning Objectives
Multiple-Table Join Strategies
Using Multi-Table Joins
Creating and Using Sub-Queries
Creating and Using Stored Views
What We Have Learned and the Real World

PL/SQL Language Fundamentals

Learning Objectives
PL/SQL Programming Basics
Entering PL/SQL Using SQL*Plus
PL/SQL Script Development Basics
PL/SQL Blocks
PL/SQL Data Types
PL/SQL Variables
Controlling PL/SQL Program Flow
What We Have Learned and the Real World

PL/SQL Procedures and Functions

Learning Objectives
Overview
Creating Procedures and Functions
Simple Stored Procedures
Stored Procedures with Parameters
What We Have Learned and the Real World

PL/SQL Packages

Learning Objectives
Creating PL/SQL Packages
Oracle WRAP Utility
What We Have Learned and the Real World

Oracle Database Triggers

Learning Objectives
Triggers
Creating Triggers
Using Triggers for Logging
System Triggers

Working with PL/SQL Records

Learning Objectives
PL/SQL Records
Defining Record Types in PL/SQL
Defining Record Types as Object Types
What We Have Learned and the Real World

PL/SQL Collections

Learning Objectives
Introduction
PL/SQL Collections Overview/Types
Working with Varrays
Using Nested Tables
Using Associative Arrays
Collection Reference

PL/SQL Error Handling

Learning Objectives
Oracle Errors
Custom Errors
Exception Handling
Raising Exceptions
Handling User Exceptions
Handling PL/SQL Exception
Propagating Exception
What We Have Learned and the Real World

Object Oriented Programming with PL/SQL

Learning Objectives
PL/SQL and Object Oriented Programming
Creating Objects
Methods
Object Table
Using DML with Objects
What We Have Learned and the Real World

XML Processing

Learning Objectives
Processing XML Data
Creating XML Documents
Validating XML Data against a Schema
A Few Examples
What We Have Learned and the Real World

Oracle and Java

Learning Objectives
Preparing the Environment
Using loadjava and dropjava
Managing Java
Using DBMS_JAVA and DBMS_JAVA_TEST
Publishing and Using Java
A Few Useful Examples
What We Have Learned and the Real World

Best Practices and Performance Tuning

Learning Objectives
Overview
Optimization and Performance Tuning
Using Indexes
Common Mistakes and their Solutions
What We Have Learned and the Real World

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related Oracle Training

PLSQL Training: Mastering Database Programming with PL/SQL

The course Mastering Database Programming with PL/SQL (PLSQL Training) covers the essential elements of the PL/SQL language. The training includes the creation and deletion of tables and the use of SQL to display, insert, delete and modify relational data. The course also covers blocks, data types, variables, program flows, stored procedures & functions and PL/SQL packages. Training course titled PLSQL Training: Mastering Database Programming with PL/SQL that will allow you to hone your professional skills.

Dec 11 - 14, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

PLSQL Training: Objects, Librairies, XML, Java & More

The course Objects, Libraries, XML, Java & More (PLSQL Training) covers the advanced elements of PL/SQL. Beginning with stored procedures & functions, the training discusses database triggers, PL/SQL records, PL/SQL collections, PL/SQL error handling & object oriented programming in PL/SQL. The course concludes with XML processing, Java integration and performance tuning & optimization in Oracle. Training course titled PLSQL Training: Objects, Librairies, XML, Java & More that will allow you to hone your professional skills.

Dec 5 - 7, 2018$1,675.00Jan 16 - 18, 2019$1,675.00Feb 13 - 15, 2019$1,675.00Mar 13 - 15, 2019$1,675.00Apr 10 - 12, 2019$1,675.00

Oracle Training: A Complete Introduction to Forms & Reports

The course A Complete Introduction to Forms & Reports (Oracle Training) covers the essentials skills that are necessary to design. implement & troubleshoot Oracle Forms and Reports. Whether you need to build a report that highlights sales in the last quarter or build a form that allows sales to be entered into an Oracle database, this is the training course for you. Training course titled Oracle Training: A Complete Introduction to Forms & Reports that will allow you to hone your professional skills.

Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

Oracle Training: Building a Data Warehouse

The course Building a Data Warehouse (Oracle Training) focuses on the art, functionality and application of Data Mining and Data Warehousing with Oracle. Beginning with the definitions of facts and dimensions, the course discusses every aspect of the Data Warehouse creation process from data loading to data mining. Implementing a data warehouse has never been this intuitive. Training course titled Oracle Training: Building a Data Warehouse that will allow you to hone your professional skills.

Dec 4 - 7, 2018$3,350.00Jan 15 - 18, 2019$3,350.00Feb 12 - 15, 2019$3,350.00Mar 12 - 15, 2019$3,350.00Apr 9 - 12, 2019$3,350.00

Oracle Training: Database Administration A to Z

The course Database Administration A to Z (Oracle Training) targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part II of the course focusses on the components of a production environment that allow database professionals to excel in their mission critical responsibilities. Training course titled Oracle Training: Database Administration A to Z that will allow you to hone your professional skills.

Dec 4 - 7, 2018$2,775.00Jan 15 - 18, 2019$2,775.00Feb 12 - 15, 2019$2,775.00Mar 12 - 15, 2019$2,775.00Apr 9 - 12, 2019$2,775.00

Oracle Training: MySQL Core Administration

The course MySQL Core Administration (Oracle Training) :: database course introduces the MySQL Relational Database Management System. Every aspect of MySQL database administration is covered from the creation of relational databases and their tables to the development of powerful SQL scripts to automate primary administrative tasks. This complete course discusses the various security mechanisms that are provided by the MySQL database engine. This course also includes coverage of performance optimization, backup and recovery and indexing amongst others. If you want to implement a MySQL database in your organization, this is the course for you. Training course titled Oracle Training: MySQL Core Administration that will allow you to hone your professional skills.

Nov 27 - 30, 2018$3,350.00Jan 8 - 11, 2019$3,350.00Feb 5 - 8, 2019$3,350.00Mar 5 - 8, 2019$3,350.00Apr 2 - 5, 2019$3,350.00

Oracle Training: Oracle Administration Complete

The course Oracle Administration Complete (Oracle Training) is an exploration of Oracle database administration from A to Z. We learn all about Oracle installation, configuration, databases, tablespaces, files & more. The course discusses Oracle enterprise manager, fault tolerance, high availability, security, partitioning, & flashback management. The training also includes a discussion on performance tuning through configuration, PLSQL tuning & database indexing. Training course titled Oracle Training: Oracle Administration Complete that will allow you to hone your professional skills.

Nov 27 - 30, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

Oracle Training: Oracle Core Administration

The course Oracle Core Administration (Oracle Training) is an exploration of the installation, configuration and maintenance of Oracle servers on Linux. The training includes an architecture overview, performance optimization through caching/tuning, backup & recovery and security. This comprehensive course discusses every aspect of Oracle database administration. Training course titled Oracle Training: Oracle Core Administration that will allow you to hone your professional skills.

Nov 27 - 30, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

Oracle Training: Professional Database Tuning & Optimization

The course Professional Database Tuning & Optimization (Oracle Training) is a detailed exploration of Oracle database performance tuning and optimization. The training includes a discussion of the tools of the performance tuning trade and quickly proceeds to coverage of structural SQL optimization techniques and PL/SQL code optimization. The course covers database indexing and server & memory optimization techniques. Fine tune your Oracle database to make them lightning fast. Training course titled Oracle Training: Professional Database Tuning & Optimization that will allow you to hone your professional skills.

Dec 11 - 14, 2018$2,775.00Jan 22 - 25, 2019$2,775.00Feb 19 - 22, 2019$2,775.00Mar 19 - 22, 2019$2,775.00Apr 15 - 18, 2019$2,775.00

Oracle Training: SQL for Data Definition & Extraction

The course SQL for Data Definition & Extraction (Oracle Training) targets database management systems such as MySQL, Oracle, SQL Server, PostgreSQL. This course is designed to be a practical study into the management of a multi-platform database work environment. Though the focus will be on the Oracle platform, the content will be discussed in a platform generic way to allow practical application to SQL Server, MySQL and PostgreSQL environments. Part I of the course focusses on the essentials of the SQL language as it is applied to a variety of database platforms. This course will provide you with a comprehensive overview of the SQL language as it is defined by the ANSI standard. Training course titled Oracle Training: SQL for Data Definition & Extraction that will allow you to hone your professional skills.

Nov 27 - 30, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00

PLSQL Training: Introduction to Data Design & Manipulation

The course Introduction to Data Design & Manipulation (PLSQL Training) is an introduction to PL/SQL programming. Beginning with the creation of database tables, the course presents a variety of PL/SQL language features in a logical and sequential order beginning with SQL syntax and ending with packages and functions. If you need to work with PL/SQL, this course will get you started in the right direction. Training course titled PLSQL Training: Introduction to Data Design & Manipulation that will allow you to hone your professional skills.

Nov 21 - 23, 2018$2,250.00Dec 19 - 21, 2018$2,250.00Jan 30 - Feb 1, 2019$2,250.00Feb 27 - Mar 1, 2019$2,250.00Mar 27 - 29, 2019$2,250.00Apr 24 - 26, 2019$2,250.00

SQL Server Training: Core Administration Skills

The course Core Administration Skills (SQL Server Training) is an exploration of database administration with SQL Server. Every aspect of SQL Server database administration is covered from the creation of relational databases & tables to the development of powerful TSQL scripts to automate primary administrative tasks. The training includes SQL Server database security & monitoring , performance tuning, backup & recovery, security and indexing to name a few. Training course titled SQL Server Training: Core Administration Skills that will allow you to hone your professional skills.

Nov 27 - 30, 2018$2,775.00Jan 8 - 11, 2019$2,775.00Feb 5 - 8, 2019$2,775.00Mar 5 - 8, 2019$2,775.00Apr 2 - 5, 2019$2,775.00