Introduction
This course starts with an introduction to PL/SQL and proceeds to list the benefits of this powerful programming language. Through hands-on instruction from expert instructors, you’ll develop stored procedures, functions, packages and more.
Audience
- Forms Developer
- Portal Developer
- Database Administrators
- Developer
- Technical Consultant
- System Analysts
- Application Developers
- PL/SQL Developer
At Course Completion
You will learn To:
- Conditionally control code flow (loops, control structures).
- Use PL/SQL packages to group and contain related constructs.
- Generate triggers to solve business challenges.
- Create anonymous PL/SQL blocks, as well as stored procedures and functions.
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- Create anonymous PL/SQL blocks, functions and procedures.
- Declare PL/SQL variables.
- Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications.
- Debug functions and procedures using the SQL Developer Debugger.
- Use Dynamic SQL & understand design considerations when coding using PL/SQL.
- Understand and influence the PL/SQL compiler and manage dependencies.
- Manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions.
Prerequisites
- Oracle Database: Introduction to SQL (combination of Oracle Database: SQL Fundamentals I and Oracle Database: SQL Fundamentals II listed)
- Oracle Database: SQL Fundamentals I
- Oracle Database: SQL Fundamentals II
Professional Exam(s)
Exam 1Z0-144: Oracle Database – Program with PL/SQLCertification(s):
OCA – Oracle Certified Associate: PL/SQL Developer-
MODULES
- Introduction
- Introduction to PL/SQL
- Declare PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Server
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures
- Stored Functions and Debugging Subprograms
- Packages
- Deploying Packages
- Implement Oracle-Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Creating Compound, DDL, and Event Database Triggers
- PL/SQL Compiler
- Manage PL/SQL Code
- Manage Dependencies
- Nicosia
City
- Class A:
1. March 06 8:00 - 15:10
2. March 07 8:00 - 15:10
3. March 08 8:00 - 15:10
4. March 09 8:00 - 15:10
5. March 10 8:00 - 15:10
6. March 13 8:00 - 15:10
Dates and Times
- 40
Duration (Hours)
- 20 Louki Akrita street,
2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
- Class A:
1. March 06 8:00 - 15:10
2. March 07 8:00 - 15:10
3. March 08 8:00 - 15:10
4. March 09 8:00 - 15:10
5. March 10 8:00 - 15:10
6. March 13 8:00 - 15:10
Dates and Times
- 40
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(200 m. from the roundabout, near Agios Nikolaos church)
Location
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manual | Exam | |
| Course | Oracle Press | 1Z0-144 | |
| Amount | €550,00 | €70,00 | €212,00 |
| VAT * | €233,70 | €13,30 |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manual | Exam | |
| Course | Oracle Press | 1Z0-144 | |
| Amount | €875,00 | €70,00 | €212,00 |
| VAT | €166,25 | €13,30 | - |
Take advantage of our special offer by taking this course as part of a bundle of 2 courses leading to the OCA – Oracle Certified Associate: PL/SQL Developer certification:
For participants eligible for subsidy by the Human Resource Development Authority:
| Participation * | Course Manuals | Exams | |
| Courses PL/SQL & SQL Fund. | Oracle Press - 2 books | 1Z0-144 & 1Z0-061 | |
| Amount | €950,00 | €130,00 | €321,00 |
| VAT * | €438,90 | €24,70 |
For participants not eligible for subsidy by the Human Resource Development Authority:
| Participation | Course Manuals | Exams | |
| Courses PL/SQL & SQL Fund. | Oracle Press - 2 books | 1Z0-144 & 1Z0-061 | |
| Amount | €1,300,00 | €130,00 | €321,00 |
| VAT | €247,90 | €24,70 |
