PLSQL Training: PLSQL Deep Dive


Course Delivery

Live Instructor-Led Training

Course Description

The course PLSQL Training: PLSQL Deep Dive for Operations will have you explore practical PLSQL for every day operations. The course starts with a quick review of Oracle database architecture and table structure for normalization. What follows is a truly exhaustive study of SQL syntax, indexes, aggregate data, and everything that you ever wanted to know about both regular and correlated sub-queries. The course ends with good old-fashioned PLSQL programming starting with the core language and ending with procedures and functions. If you want to learn how to write practical PLSQL, this is the PLSQL training course that you need.

Course Dates and Pricing


Jan 8 - 11, 2024$3,350.00Feb 5 - 8, 2024$3,350.00Mar 4 - 7, 2024$3,350.00

Course Outline

Oracle Databases and Tables

Overview of Oracle Database Architecture
About Database Tables and Data Normalization
About Domain Integrity
About Entity Integrity
About Referential Integrity
A Note on Performance

Structured Query Language (SQL) Basics

Understanding the Structure of Relational Data
Retrieving Data
Adding Table Records
Modifying Data
Deleting Data
The SQL Language: Working with Dates
The SQL Language: Working with NULL

Introduction to Indexing

Overview of Indexes: Ensuring Performance
Using Indexes the Correct Way: OLAP vs OLTP Servers
Creating and Maintaining Indexes
About Point and Range Queries
Choosing Indexes
Putting it All Together

Working with Aggregate Data

Aggregate Data: Essential Concepts
Working with Multiple Levels
Performance Considerations
CUBE and ROLLUP
Building crosstab reports
Utilizing the PIVOT operator in Oracle 11g
RANK and DENSE_RANK
Partitioning in multiple levels

Advanced SQL Querying

Multiple-Table Join Strategies
Using Multi-Table Joins
Working with Inner and Outer Joins
Adding filter conditions to OUTER JOINS
Working with CONNECT BY in a Join
Understanding Self Joins
Recursive Self-Joins and CONNECT BY
Working with INTERSECT

Mastering Sub-Queries

About Sub-Queries and Correlated Sub-Queries
Sub-Queries: Structure and Syntax
Working with Point Sub-Queries
Working with Range Sub-Queries
Working with NULL Values
Working with Multi-Row Sub-Queries
Working with Multi-Column Sub-Queries
Sub-Query Performance: Index Considerations

Sub-Queries Part II: Practical Considerations

Breaking up Complex Problem
Factoring Subqueries for Reusability
Applying Recursive Factored Subqueries
Subqueries as Parameters to Functions
Correlated and Non-Correlated Subqueries in Expressions

PL/SQL Language Fundamentals

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

PL/SQL Procedures and Functions

Overview
Creating Procedures and Functions
Simple Stored Procedures
Stored Procedures with Parameters
Working with Arrays and Collections
Working with Objects
Creating PL/SQL Packages

Course Locations

  • Ottawa

  • Montreal

  • Toronto

Related PLSQL 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, 2023$3,750.00Jan 22 - 25, 2024$3,750.00Feb 19 - 22, 2024$3,750.00Mar 18 - 21, 2024$3,750.00

PLSQL Training: The Complete PL/SQL Programming Course

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. Training course titled PLSQL Training: The Complete PL/SQL Programming Course that will allow you to hone your professional skills.

Dec 4 - 7, 2023$3,750.00Jan 15 - 18, 2024$3,750.00Feb 12 - 15, 2024$3,750.00Mar 11 - 14, 2024$3,750.00

Oracle Training: SQL Data Analysis with Toad Intermediate

The course SQL Data Analysis with Toad Intermediate (Oracle Training) explores the SQL language with Oracle and Toad. The training includes SQL basics including filtering, sorting, single and multi table join strategies, subqueries, correlated subqueries & more. The course also covers stored procedures and discusses common SQL tasks in an Oracle environment. Training course titled Oracle Training: SQL Data Analysis with Toad Intermediate that will allow you to hone your professional skills.

Dec 18 - 21, 2023$3,750.00Jan 29 - Feb 1, 2024$3,750.00Feb 26 - 29, 2024$3,750.00Mar 25 - 28, 2024$3,750.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.

Dec 6 - 8, 2023$3,350.00Jan 17 - 19, 2024$3,350.00Feb 14 - 16, 2024$3,350.00Mar 13 - 15, 2024$3,350.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 20 - 22, 2023$2,250.00Jan 31 - Feb 2, 2024$2,250.00Feb 28 - Mar 1, 2024$2,250.00Mar 27 - 29, 2024$2,250.00