Prerequisites
There are no prerequisites for this course.
This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more. Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
There are no prerequisites for this course.
- Application Developers
- Database Administrators
- System Analysts
- Forms Developer
- Developer
- Technical Consultant
- Portal Developer
- PL/SQL Developer
- Conditionally control code flow (loops, control structures).
- Create stored procedures and functions.
- Use PL/SQL packages to group and contain related constructs.
- Create triggers to solve business challenges.
- Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
- Create custom packages for applications.
- Write Dynamic SQL code for applications.
- Working with Oracle Cloud Exadata Express Cloud Service
- Introduction to PL/SQL
- Declare PL/SQL Variables
- Write Anonymous PL/SQL Blocks
- SQL Statements in a PL/SQL block
- Control Structures
- Composite Data Types
- Explicit Cursors
- Exception Handling
- Stored Procedures
- Stored Functions
- Debugging Subprograms
- Packages
- Deploying Packages
- Implement Oracle-Supplied Packages in Application Development
- Dynamic SQL
- Design Considerations for PL/SQL Code
- Triggers
- Creating Compound, DDL, and Event Database Triggers
- PL/SQL Compiler
- Manage Dependencies
