Oracle is the most widely-used relational database in the world. This course will teach you how to evaluate the database for issues that might interfere with the upgrade, and methods to migrate your database in complex environments.

This course will give you the skills you need to perform backup and recovery for Oracle Database 12c under Microsoft Windows and Oracle Linux. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam in Oracle Database 12c.

This course will get you up to speed with the Oracle Database platform in general and the Oracle Database 12c release in particular. You'll also get prepared to pass the Oracle Certified Administrator (OCA) certification exam.

This course will teach you how to perform maintenance and manage performance in Oracle Database 12c, and overlaps heavily with the OCP exam objectives.

In this course we look at installing and upgrading Oracle on Windows and Linux.

This course focuses exclusively on the Oracle instance. If you’ve been through the first course in this path, Understanding Database Architecture with Oracle, you’ll find the material in this course familiar.

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.