Course Overview
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
This OD-19c-PW: Oracle Database 19c: PL/SQL Workshop course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.
What are the skills covered
- PLSQL programming structure
- Using Explicit and Implicit Cursors in PLSQL
- For, while and basic Loop Processing in PLSQL
- Programmer Defined Procedures and Functions
- Using UTL_FILE and Directories for I/O
- Exception Handling
Who should attend this course
- End users
- Business analysts
- Application developers
- Database administrators
Course Curriculum
Course Modules
Exam & Certification
Oracle Database 19c: PL/SQL Workshop Certification Training Course.
