PL/SQL Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of SQL Programming




Total 197 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Oracle Database 11g: PL/SQL Fundamentals
Oracle PL/SQL
PL/SQL
oracle database 10g: program with pl/sql
oracle database 11g: program with pl/sql
Oracle 10g PL/SQL


PL/SQL

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

PL/SQL is Oracle&,#146,s extension language for standard SQL.

In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.

The Environment for PL/SQL Development
Prerequisites
File Naming Conventions
Connecting to Oracle
SQL*Developer
SQL*Plus
Executing PL/SQL Code
SQL Developer Configuration
The PL/SQL Development Cycle

PL/SQL Basics
PL/SQL Block
Anonymous Block Structure
Named Block Structure
Executing Blocks
Calling PL/SQL Functions
Executing PL/SQL Blocks and Functions

Declaring Variables
Variable Usage
Variable Data Types
Variable Naming
Variable Assignment
Variable Display
Complex Variable Types
More Information
Variable Declaration, Initialization and Display

Within the Block
Conditional Processing
The IF Statement
The CASE Statement
Iterative Processing
The LOOP Statement
The WHILE Statement
The FOR Statement
Salary C... [Read More]

Oracle Database 11g R2: PL/SQL Fundamentals

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming.

This course equips students to develop database server-side PL/SQL program units within an Oracle database. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Course Outline

Choosing a SQL &, PL/SQL Interface
Using SQL Developer
Using SQL *Plus
Using Application Express
Using JDeveloper Studio

Language Features
Understanding PL/SQL
Structure of a PL/SQL Program Block
Using PL/SQL from SQL *Plus

Declare Clause
About the Declare Clause
Declare Simple Types
Declare Complex Types
Type ... Table
Type ... Record

Begin Clause
About the Begin Clause
Performing Data Manipulation
Logic Control &, Branching
Loop
If-Then-Else
Case

Exception Cl... [Read More]

Oracle Database 11g R2: Advanced PL/SQL Programming & Tuning

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

This Oracle 11g course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. The PL/SQL programming language is at the core of most Oracle database applications.

First, we will explore the advanced features of the language which allow powerful and effective database applications to be built.

Next, we will discuss performance tuning techniques which allows these applications to run efficiently.

Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats. In addition to receiving the print copy of this course book, all students will receive e-Learning modules.

Among the specific topics contained within these training materials are:
Invoking external procedures and integrating these into PL/SQL applications. These include external Java classes using the JDBC interface and external C programs contained within DLL libraries.
Using dynamic SQL to extend the functionality and flexibility of database programs, including the DBMS_SQL() system-supplied package for maximum flexibility.
Identifyin... [Read More]

PL/SQL

Course Format: Online
School/Trainer: InfoSec Institute
Training Center(s)/Venue(s): Elmwood Park, United States
  V

PL/SQL is Oracle’s extension language for standard SQL. In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.
Class Goals
Understand the PL/SQL Development Environment.
Learn the basics of the PL/SQL language.
Learn to declare and work with variables.
Learn to use conditionals and loops in PL/SQL.
Learn to handle and create user-defined exceptions.
Learn to use SQL within PL/SQL.
Learn about nested blocks and variable scope.
Learn to create Subprograms, Stored Procedures and Functions.
Learn to work with Packages, Triggers and Cursors.
Learn to use Oracle Supplied Packages.

Prerequisites and Class Materials

Prerequisites
A basic uderstanding of Oracle SQL
Class Materials Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Oracle 11g Advance PL/SQL Developer OCP (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, large objects, and collections, students learn to write powerful PL/SQL programs. Students also learn programming efficiency, use of external C and Java routines, fine-grained access and safeguarding code against SQL Injection attacks.

Course Objectives

Create collections (nested table, array and associative arrays, PL SQL tables)
Use collections methods
Manipulate collections
Describe SecureFile LOB features
Enable SecureFile LOB deduplication, compression, and encryption
Describe SQL injections
Reduce attack surfaces

Oracle 11g PL/SQL Developer OCA (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks as well as stored procedures and functions.

Students learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Students are introduced to the utilization of some of the Oracle-supplied packages.

To be a more effective Oracle Developer, we recommend basic knowledge of Oracle DBA. We can offer a 1 day customized course on Oracle DBA after the first module SQL Fundamentals.

Course Objectives

Create reports of sorted and restricted data


Employ SQL functions to generate and retrieve customized data


Display data from multiple tables using the ANSI SQL 99 JOIN syntax


Create reports of aggregated data
Read More]

Oracle Database: Program with PL/SQL

Course Format: Classroom
School/Trainer: Torque IT
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Pretoria, South Africa
  V

This five-day instructor-led course consists of PL/SQL Fundamentals (2 days) and PL/SQL Program Units (3 days) and introduces
participants to the fundamentals of PL/SQL. In this course participants learn about PL/SQL syntax, blocks, programming constructs
and about the advantages that PL/SQL provides. This course provides the essential skills that allow developers to write and execute
PL/SQL program units efficiently, develop reusable program units such as procedures and functions, package constructs and
database triggers. Participants will also learn how to use a subset of Oracle-supplied packages, identify various techniques that
impact PL/SQL design considerations, and how to manage PL/SQL code effectively.
This course, applicable to Oracle Database 10g and 11g users, will teach participants how to make use of Oracle SQL Developer
as the main tool (with SQL*Plus optionally available) for hands-on practice to reinforce the fundamental concepts and new skills
acquired.
Prerequisites
Before attending this course, students must have:
?A thorough knowledge of the SQL language
?Work with SQL *Plus and SQL Develope... [Read More]

Oracle Database 12c SQL and PL/SQL Fundamentals Workshop

Course Format: Classroom
School/Trainer: Torque IT
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Pretoria, South Africa
  V

This five-day instructor led course is a bundled course thqat consists of Oracle Database: SQL Workshop I and Oracle Database:
PL/SQL Fundamentals and will teach you the fundamentals of SQL and PL/SQL along with the benefits of the programming
languages using Oracle Database technology. You&,#146,ll explore the concepts of relational databases.
Prerequisites
Before attending this course, students must have:
?A familiarity with data processing concepts and techniques
?Master basic application features such as Open, Save, Close
?A proficiency with the use of a keyboard and mouse
At Course completion
After completing this course, students will be able to:
?Write queries against single and multiple tables, manipulate data in tables and create database objects.
?Use single row functions to customize output.
?Invoke conversion functions and conditional expressions.
?Use group functions to report aggregated data.
?Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
?Develop anonymous PL/SQL blocks, stored procedures and funct... [Read More]

Oracle Database 12c: Advanced PL/SQL

Course Format: Classroom
School/Trainer: Torque IT
Training Center(s)/Venue(s): Cape Town, Durban, Johannesburg, Pretoria, South Africa
  V

This three day Advanced PL/SQL training course teaches you how to use the advanced features of PL/SQL to design and tune
PL/SQL to interface with the database and other applications. Expert Oracle University instructors will help you explore advanced
features of program design, packages, cursors, extended interface methods and collections.
Discover how to write PL/SQL routines that analyse the PL/SQL applications and caching techniques that can improve performance.
By investing in this course, you&,#146,ll be introduced to the Virtual Private Database (VPD) to implement security policies and explore
techniques and tools to strengthen your applications against SQL injection attacks. Expand programming resources by creating
PL/SQL programs that interface with C and Java code.
Prerequisites
Before attending this course, students must have
?A thorough knowledge of the SQL language
?Working experience with SQL *Plus
?Working experience on developing applications with PL/SQL.
Oracle requires and recommends that delegates have attended the following courses prior to attending Oracle Database12c:
Advanced PL/S... [Read More]

Oracle PL/SQL (Certificate)

Course Format: Online
School/Trainer: Diya Technologies
Training Center(s)/Venue(s): Hyderabad, India
  V


Introduction to PL/SQL

◦Declaring PL/SQL variables

◦Writing Executable statements

◦Interaction with Oracle Server

?Writing control structure

◦Working with composite data types

◦Using Explicit cursors

◦Handling Exceptions

◦Stored procedures with functions

Oracle 11g DBA/Developer Workshop (Certificate)

Course Format: Classroom
School/Trainer: Synergy Education Services, A Division of Synergy Computers (Pvt.) Ltd.
Training Center(s)/Venue(s): Karachi, Pakistan
  V

Oracle 11g is a contemporary release of Oracle Database family of products. Besides retaining core concepts of its predecessor Oracle 10g, it has introduced certain new concepts and features to make it a most robust database system. This course develops skills required to manage Oracle 11g Databases efficiently with new functionality that makes many common operations tasks incredibly fast and simple. The course starts from teaching Oracle Database 11g fundamentals and moves on to the advanced level tasks a DBA has to exercise to keep the system up and running.

PL/SQL Programming

Course Format: Classroom
School/Trainer: VerticalDivers
Training Center(s)/Venue(s): Bangalore, India
  V

This course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.

Oracle SQL & PL/SQL

Course Format: Online
School/Trainer: BigClasses
Training Center(s)/Venue(s): Hyderabad, India
  V


Oracle Database Environment

Pseudo columns and functions

Character Functions

Date Functions

SET Operators

Group Functions

Sub queries

Transaction Control Language

Data Definition Language

Declarative Constraints

Database Objects

Database Security

PL-SQL

Blocks

Variables

Control Structures

Cursors

Error handling

Procedures

Functions

Packages

Triggers

Dynamic SQL

Oracle Supplied Packages

Collection Data types

PL/SQL

Course Format: Classroom
School/Trainer: Houston Community College
Training Center(s)/Venue(s): Houston, United States

A continuation of Oracle SQL. Topics include hierarchical queries, set based queries, correlated subqueries, scripting, and scripting generation.

Oracle Database 11g: Advanced PL/SQL (Certificate)

Course Format: Classroom
School/Trainer: PT OPTIMA BISNIS INTEGRA
Training Center(s)/Venue(s): Jakarta, Indonesia
  V

In this Oracle Database 11G Advanced PL/SQL training, expert Oracle University instructors will help you explore the advanced features of PL/SQL to design and tune PL/SQL. You&,#146,ll learn how it interfaces with the database and other applications in the most efficient manner.

Benefits to You
Extend the functionality of the SQL language with PL/SQL language to write application code. This will help your organization realize the full benefit of utilizing Oracle best practices.

Duration : 3 days

Oracle Database: Program with PL/SQL (Certificate)

Course Format: Classroom
School/Trainer: PT OPTIMA BISNIS INTEGRA
Training Center(s)/Venue(s): Jakarta, Indonesia
  V

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you&,#146,ll learn to develop stored procedures, functions, packages and more.

Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Duration : 5 days

Oracle Database: SQL and PL/SQL Fundamentals (Certificate)

Course Format: Classroom
School/Trainer: PT OPTIMA BISNIS INTEGRA
Training Center(s)/Venue(s): Jakarta, Indonesia
  V

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You&,#146,ll explore the concepts of relational databases.

Benefits to You
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Duration : 5 days

Oracle Database 11g: PL/SQL Fundamentals

Course Format: Classroom
School/Trainer: St. Edwards University
Training Center(s)/Venue(s): Austin, United States
  V

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database.

Prerequisites:
?Oracle Database 11g: SQL Fundamentals

Course Outline

CHOOSING A SQL &, PL/SQL INTERFACE
?USING SQL DEVELOPER
?USING SQL*PLUS
?USING APPLICATION EXPRESS
?USING JDEVELOPER STUDIO

LANGUAGE FEATURES
?UNDERSTANDING PL/SQL
?STRUCTURE OF A PL/SQL PROGRAM BLOCK
?USING PL/SQL FROM SQL*PLUS

DECLARE CLAUSE
?ABOUT THE DECLARE CLAUSE
?DECLARE SIMPLE TYPES
?DECLARE COMPLEX TYPES
?TYPE ... TABLE
?TYPE ... RECORD

BEGIN CLAUSE
?ABOUT THE BEGIN CLAUSE
?PERFORMING DATA MANIPULATION
?LOGIC CONTROL &, BRANCHING
?LOOP
?IF-THEN-ELSE
?CASE

EXCEPTION CLAUSE
?ABOUT THE EXCEPTION CL... [Read More]

Oracle Database 11g PL/SQL

Course Format: Classroom
School/Trainer: Sheridan College
Training Center(s)/Venue(s): Brampton, Mississauga, Oakville, Canada
  V

Students build complex business logic in a modular fashion - reusable. Students focus on building anonymous PL/SQL blocks, work with implicit and explicit cursors, create stored procedures and functions in a database and create and work with database packages. The students also learn how to write database triggers that get executed automatically whenever the triggering event happens. Students write and debug scripts.

PL/SQL

Course Format: Classroom
School/Trainer: CUA Metropolitan School of Professional Studies
Training Center(s)/Venue(s): Washington DC, United States
  V

This course offers students an extensive introduction to data server technology. The class covers the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students are taught to create and maintain database objects to store, retrieve, and manipulate data. Demonstration and hands-on practice reinforce the fundamental concepts. This class is preparation for both Oracle Application Developer and Database Administration certification exams.

Pages: 1 2 3 4 5 6 ...


Find PL/SQL training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Tips:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.



- Other Topics -
- Online/E-learning -
PL/SQL
Ask for Training
Add Courses