Oracle 19c PL/SQL Fundamentals

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 19c.

This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs.

Attendees should have incoming basic SQL experience, as well as an understanding of databases (required to manipulate it with PL/SQL).

Take Before: Attendees should have skills equivalent to the topics in the course listed below:

TTSQL003 Introduction to Writing SQL Queries