Oracle Database 12c R2: Program with PL/SQL Ed 2 Course Overview

To ensure that you can make the most of the Oracle Database 12c R2: Program with PL/SQL Ed 2 course, the following prerequisites are recommended:

• Basic understanding of database concepts, including what a database is, what tables and indexes are, and familiarity with how data is stored and retrieved.
• Fundamental knowledge of SQL, including the ability to construct simple SELECT, INSERT, UPDATE, and DELETE statements.
• Experience with any programming language would be beneficial, although it's not mandatory. Familiarity with basic programming concepts such as variables, loops, and conditional statements will help you grasp the PL/SQL content more effectively.
• An analytical mindset and problem-solving skills will aid in understanding PL/SQL programming logic and practices.
• Ability to navigate through basic computer software and use a text editor for coding purposes.
• Interest in learning how to develop database-driven applications using Oracle PL/SQL.

These prerequisites are designed to provide a baseline understanding that will help you quickly adapt to the course content. If you are new to some of these concepts, we encourage you to explore introductory materials before starting this course to ensure the best learning experience.

Target Audience for Oracle Database 12c R2: Program with PL/SQL Ed 2

Oracle Database 12c R2: Program with PL/SQL Ed 2 is designed for professionals seeking to master SQL and PL/SQL programming on Oracle databases.

• Database Administrators
• Application Developers
• PL/SQL Developers
• Data Analysts
• Business Intelligence Professionals
• IT Consultants
• Software Engineers
• Technical Consultants
• Data Warehouse Administrators
• Back-End Developers
• System Analysts

Learning Objectives - What you will Learn in this Oracle Database 12c R2: Program with PL/SQL Ed 2?

Introduction to the Oracle Database 12c R2: Program with PL/SQL Ed 2 Course Outcomes

This course equips students with the skills to write PL/SQL programs for Oracle Database 12c R2, enabling efficient data manipulation and enhanced performance.

Learning Objectives and Outcomes

• Understand the structure and benefits of PL/SQL within Oracle databases, including how to create and execute anonymous blocks and store output.
• Define and manipulate various PL/SQL identifiers, variables, and data types, making effective use of the %TYPE attribute and bind variables.
• Write executable statements following best practices in PL/SQL syntax, incorporating SQL functions, and handling data type conversions.
• Interact seamlessly with the Oracle Server using SELECT statements, cursors, and DML operations, and manage transactions within PL/SQL blocks.
• Implement control structures for conditional processing and iteration, utilizing IF, CASE statements, and various loop constructs.
• Work with composite data types such as PL/SQL records, INDEX BY tables, and the %ROWTYPE attribute for efficient data handling.
• Manage data retrieval with explicit cursors, understanding their lifecycle, attributes, and usage in cursor FOR loops.
• Develop robust error handling procedures to manage exceptions, including predefined, non-predefined, and user-defined exceptions, using RAISE_APPLICATION_ERROR for custom errors.
• Design and implement stored procedures to modularize code, including creating, calling, removing, and managing parameters and their modes.
• Gain insights into the PL/SQL execution environment and subprograms, discerning the advantages of using modularized PL/SQL code blocks.