This Oracel PL/SQL training course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL/SQL programs in Oracle, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.
You Will Learn How To
- Develop efficient PL/SQL programs to access Oracle databases
- Create stored procedures and functions for reuse and maintenance
- Design modular applications using packages
- Manage data retrieval for front-end applications
- Invoke native dynamic SQL to develop high-level abstract code
-
Requirements
- Knowledge at the level of:
- Course 2226, Oracle Database 12c Introduction, or
- Course 925, SQL Programming Language Introduction
- Knowledge at the level of:
-
Software
- This course is currently running on Oracle 12c