Certified PL-SQL Developer
Course
Online
*Indicative price
Original amount in USD:
$ 4,129
Description
-
Type
Course
-
Level
Intermediate
-
Methodology
Online
-
Duration
Flexible
-
Start date
Different dates available
This PL/SQL Developer certification for Oracle database assesses the candidate for a company’s needs for developing PL/SQL based applications in Oracle database. The
certification tests the candidates on various areas of PL/SQL development which includes syntax, semantics, exception handling and transaction control.
Facilities
Location
Start date
Start date
About this course
Job seekers looking to find employment in IT department of various companies, students generally wanting to improve their skill set and make their CV stronger and existing employees looking for a better role can prove their employers the value of their skills through this certification.
Reviews
Subjects
- PL/SQL
- Database
- SQL
- Database training
- Programming
- Software
- Configuration
- Hardware
- Defining
- Cursor variables
- Code Management
- Advanced Datatypes
Teachers and trainers (1)
Name Name
Teacher
Course programme
PL/SQL Introduction
- Relational database, oracle and PL/SQL
- PL/SQL need and benefits
Configuration
- Hardware and software pre-requisites
- Oracle environment configure and test
PL/SQL programming constructs
- Lexical elements and basic data types
- Constants, variables, operators and expressions
- Conditional and loop construct
- Overloading and recursion
Code Block
- Procedure and functions
- Packages, INSTEAD OF and triggers
- Compilation errors
- Exception handling and custom exception
Cursors
- Declaration and defining
- Implicit cursors
- Cursor variables, using PL/SQL functions, record updates and shortcuts
Code Management
- Packaging and placement of code and triggers in database
- Code placement in application server
- Naming standard basics, need and norms
Advanced Datatypes
- Clob, blob and bfile
- Custom data types
- Varray and bulk collect
- Commit and rollback
- Autonomous transactions
Additional information
Certified PL-SQL Developer
*Indicative price
Original amount in USD:
$ 4,129