Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle
* Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore:
Using PL/SQL programming language for database applications and development
incorporating PL/SQL modules within the application architecture from the initial design and planning phase
The essentials of building executable PL/SQL program units
Each of the major segments of a working program and how these interact with each other during program execution
Important error or exception handling capabilities of the language.
How database-resident program units can be used as part of the overall database application architecture
Applying these new skills to the development of PL/SQL packages.
Advanced database programming capabilities and benefits
How database triggers can be used as part of an advanced database application design
Length: 3.0 days (24 hours)
6:00 PM ET