This course will teach you how to improve maintainability of PL/SQL code by using functions. You’ll learn how to create, manage, and remove them. You’ll write many functions in practice, so you’ll see all the peculiarities related to functions.

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 creating packages in Oracle PL/SQL.

This course will teach you how to create and use stored procedures in Oracle Database. It covers the key information you will need to ace the stored procedures section of Oracle exam 1Z0-149.

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

This course will teach you what exceptions are in Oracle DBMS, how to handle predefined and non-predefined exceptions, and how to raise them to protect business logic. Covers the exceptions section in the 1Z0-149 certification exam.

Oracle dependencies are created between two objects when an object’s name appears in a SQL statement stored in another object. This course will teach you how to manage these dependencies.

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 managing PL/SQL code in the Oracle database.

Companies rely on backend developers in meeting SLAs with the customer. This course will teach you the different cursor types and how to leverage them in fetching data involving concurrent sessions.

Dynamic SQL is an advanced programming technique. Every application needs to anticipate, automate, and integrate input from the user in their SQL commands. This course will teach you how to face these challenges with the use of dynamic SQL.

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.

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.