| Class Dates and Times | ||
| 04/14/2025 | Monday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
| 04/15/2025 | Tuesday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
| 04/16/2025 | Wednesday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
| 04/17/2025 | Thursday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
| 04/18/2025 | Friday | 10:00-4:45 EDT |
| 9:00-3:45 CDT | ||
| 8:00-2:45 MDT | ||
| 7:00-1:45 PDT | ||
Early Notice Class
Early Notice classes have enrollments that suggest that the class will run as scheduled.
| Last Reg Date | 4/9 |
Follow the link to our self-service price quote form to generate an email with a price quote.
We can deliver this class for your group. Follow the link to request more information.
Receive an email when this class is available as "Ready to Run" or "Early Notice" status.
If you have high-speed internet and a computer you can likely take this class from your home or office.
This course introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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.
PL/SQL may be considered as one of the basic skill sets required for any Oracle professional, nearly as important as the SQL language itself.
This course will also continue on to show those who are now ready to employ the language in the development of database applications. In particular, the focus of this course will be on the use of database-resident stored program units such as procedures, functions, packages and database triggers. New features introduced with the Oracle 12c release of the database are also explained and demonstrated.
This course content is applicable to versions 11c, 12c, 18c, and 19c.
The target audience for this textbook is all Oracle professionals. Among the specific groups for whom this textbook will be helpful are:
Application designers and database developers
Database administrators
Web server administrators
Oracle Database 12c: SQL Fundamentals
This course considers subjects applicable to certification as both an Oracle PL/SQL Developer Certified Associate (OCA) and an Oracle Advanced PL/SQL Developer Certified Professional (OCP). The topics considered are included within "Exam 1Z0-149 Program With PL/SQL".
The exam, along with the exam Oracle Database SQL 1Z0-071, is required for the PL/SQL Developer Certified Professional certification.
This course begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications.
In addition, this course explains how database-resident program units can be used as part of the overall database application architecture and the benefits realized by doing so. It then builds upon one's knowledge of database-resident program units and applies these to the development of PL/SQL packages. In a production environment most PL/SQL program units should be packaged, and these advanced database programming capabilities along with the benefits of using these are discussed. It concludes with extensive demonstrations on how a particular type of database-resident program unit known as a database trigger can be used as part of an advanced database application design.
View outline in Word
Attend hands-on, instructor-led Oracle Database: PL/SQL Fundamentals training classes at ONLC's nationwide locations. Not near one of our locations? Attend these same live classes from your home/office PC via our Remote Classroom Instruction (RCI) technology.
For additional training options, check out our list of Oracle Courses and select the one that's right for you.
Facebook
LinkedIn