The PL/SQL programming language is at the core of most Oracle database applications. This course will give attention to three fundamental pillars of effective implementation of PL/SQL applications. First, we will explore the advanced features of the language that allow powerful and adaptable database applications to be built. Next, we will discuss performance tuning techniques that allow these applications to run efficiently. Finally, we will consider critical security measures which should be implemented to counter hacker attacks and other security threats.
This course takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle.
In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c.
In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties.
In this course, students will focus on configuration on supported systems. Also how the database fits in with other systems.