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

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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

Course Info

Not Your Location? Change

Cost: $ 2,195

Length: 3.0 days (24 hours)

Level:

Next Available Classes:

Schedule select
30
Jan
Monday
10:00 AM ET -
6:00 PM ET
Full
Wait List
Schedule select
27
Mar
Monday
10:00 AM ET -
6:00 PM ET
Almost Full
5 seat(s) left
Schedule select
23
May
Tuesday
10:00 AM ET -
6:00 PM ET
Almost Full
5 seat(s) left
Schedule select
24
Jul
Monday
10:00 AM ET -
6:00 PM ET
Full
Wait List
Schedule select
25
Sep
Monday
10:00 AM ET -
6:00 PM ET
Full
Wait List
Loading...