Subprograms are a fundamental concept in PL/SQL. This course will teach you how to create and use subprograms, and why they are important in an application. It will improve your coding skills and help you become an Oracle Certified Professional.

This course will teach you everything you need to know about the PL/SQL compiler to help you prepare for the 1Z0-149 exam.

Composite data types are important concepts in PL/SQL. This course will teach you to create, use, and integrate collections and records in applications. It will improve your coding skills and help you become an Oracle Certified Professional.

This course will help you acquire certification for the Oracle Database Program with PL/SQL exam number 1Z0-149. It will cover the exam objectives of working with packages in Oracle PL/SQL.

This course will help you acquire certification for the exam 1Z0-149: Oracle Database Program with PL/SQL. It will cover the exam objectives of writing control structures in Oracle PL/SQL.

Companies rely on the backend developers in meeting the SLAs with the customer. This course will teach you how to write efficient nested blocks and expressions using the built-in function provided by PL/SQL.

Companies rely on the backend developers when meeting SLAs with customers. This course will teach you how to proficiently write PL/SQL executable blocks using DML and the INTO clause to hold values returned by PL/SQL for the Oracle database.

This course covers the essentials of creating and managing tables in your Oracle database, including naming tables, defining columns, creating constraints and granting permissions. It also covers the basics of indexes, which are essential for efficiently accessing data in your tables.

This course introduces developers to the fundamental principles of performance tuning when using Oracle as their backend database.

Get coding quickly and effectively with Oracle PL/SQL, Oracle's database development language. This course is the first of a two part series, covering the essentials and fundamentals of Oracle PL/SQL.

In this course, we will take an in-depth look at Procedures, Functions, and Packages. These named program units are powerful programming constructs which can greatly enhance and optimize your code.

In this course, we will talk in detail about transaction management in Oracle. We will take an in-depth look at dynamic SQL and debugging options in PL/SQL, and explore in detail the SQL Developer Debugger.