Oracle PL/SQL
Oracle PL/SQL (Procedural Language/Structured Query Language) is a powerful extension of SQL designed specifically for Oracle databases. It allows users to create stored procedures, functions, triggers, and packages, enabling the development of complex business logic within the database. PL/SQL enhances the capabilities of SQL by providing procedural constructs such as loops, conditional statements, and exception handling, thereby enabling developers to write more flexible and sophisticated database applications. It offers tight integration with Oracle Database, providing access to database objects and data manipulation capabilities directly within the procedural code. PL/SQL is highly efficient for data processing tasks, as it minimizes network traffic by executing operations on the server side. Its robust error handling mechanisms ensure data integrity and application reliability.
| Time Slot | ||
|---|---|---|
| 9.00 AM to 1.00PM | 2.00 PM to 6.00PM | 6.00 PM to 9.00PM |
Oracle PL/SQL Syllabus
Oracle PL/SQL
Module Objectives:
Learn the basics of PL/SQL syntax, including variables, control structures, and loops, to effectively manipulate data and implement business logic within the Oracle database.
- Explore advanced PL/SQL topics such as cursors, exception handling, stored procedures, functions, and triggers to develop robust database applications with improved performance, security, and maintainability.
Overview:
Oracle PL/SQL is a powerful extension of SQL for developing procedural logic within the Oracle database.It enables the creation of stored procedures, functions, triggers, and packages for efficient data manipulation and business logic implementation.Learning PL/SQL equips you with essential skills for building scalable, secure, and high-performance database applications.
Platform
-
Linux (Fedora / Mandriva / Ubuntu) or Windows Host system
- Firefox, Chrome
Detailed Course Contents:
- Introduction to Oracle Database
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data From Multiple Tables Using Joins
- Use Sub-Queries to Solve Queries
- The SET Operators
- Data Manipulation Statements
- Use of DDL Statements to Create and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data Dictionary Views
- Manipulate Large Data Sets
- Data Management in Different Time Zones
- Retrieve Data Using Sub-queries
- Regular Expression Support
- Introduction to PL/SQL
- PL/SQL Identifiers
- Write Executable Statements
- Interaction with the Oracle Server
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures and Functions
- Create Stored Procedures
- Create Stored Functions
- Create Packages
- Packages
- Implement Oracle-Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Create Compound, DDL, and Event Database Triggers
- The PL/SQL Compiler
- Manage PL/SQL Code
- Manage Dependencies