Oracle Database: Program with PL/SQL
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 DeveloperCourse Features
- Lectures 21
- Quizzes 0
- Duration 50 hours
- Skill level All levels
- Language English
- Students 0
- Assessments Yes
-
MODULES
- Nicosia
City
- Class A
1. July 06 8:30 - 16:00
2. July 07 8:30 - 16:00
3. July 08 8:30 - 16:00
4. July 09 8:30 - 16:00
5. July 10 8:30 - 16:00
6. July 11 8:30 - 13:45 (review)
Dates and Times
- 40
Duration (Hours)
- 20 Louki Akrita street,
2064 Strovolos
(behind Kykko secondary schools)
Location
- Limassol
City
- Class A
1. July 06 8:30 - 16:00
2. July 07 8:30 - 16:00
3. July 08 8:30 - 16:00
4. July 09 8:30 - 16:00
5. July 10 8:30 - 16:00
6. July 11 8:30 - 13:45 (review)
Dates and Times
- 40
Duration (Hours)
- 22 Griva Digeni Avenue, 3106 Agios Nikolaos
(near Hellenic branch - ex Coop - and 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 |
