COURSE OVERVIEW
Overview of PL/SQL
PL/SQL language fundamentals
PL/SQL Data Types
PL/SQL Control Statements
PL/SQL Static SQL
PL/SQL Subprograms
PL/SQL Error Handling
PACKAGE
TRIGGER
Design Considerations for PL/SQL Code
Oracle Supplied Packages
COLLECTION
Dynamic SQL and Meta Data
Managing Dependencies
RECORD Variable
COLLECTION
Large Objects
Administering Secure File LOBs
Advance Interface Methods
Fine-Grained Access Control for VPD
Performance and Tuning
Improving Performance with Caching
Analyzing PL/SQL Code
Profiling and Tracing PL/SQL Code
Safeguarding Code Against SQL Injection Attacks
Course Outcomes
-
Understand PL/SQL fundamentals including data types, control statements, and static SQL for efficient database programming.
-
Develop and manage PL/SQL subprograms such as procedures, functions, packages, and triggers to automate database operations.
-
Handle exceptions and ensure code security using error handling, fine-grained access control, and safeguards against SQL injection.
-
Work with advanced PL/SQL features like collections, records, large objects (LOBs), dynamic SQL, and Oracle-supplied packages.
-
Optimize PL/SQL performance through caching, profiling, tracing, and best design practices.
-
Build job-ready database solutions capable of handling secure, scalable, and maintainable enterprise applications.
