Certificate in PL/SQL
- Offered byVSkills
Certificate in PL/SQL at VSkills Overview
Total fee | ₹3,499 |
Mode of learning | Online |
Credential | Certificate |
Future job roles | Cocoa, COBIT |
Certificate in PL/SQL at VSkills Highlights
- Earn a certificate of completion from Vskills
- Get Lifelong e-learning access
Certificate in PL/SQL at VSkills Course details
- In the PL/SQL program the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data & control the program flow
- This certification will teach you programming in Oracle PL/SQL
Certificate in PL/SQL at VSkills Curriculum
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
Transaction Processing
Commit and rollback
Autonomous transactions
Other courses offered by VSkills
Student Forum
Anything you would want to ask experts?