Data base development

NEW Oracle Database: Program with PL/SQL
Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code. Create and use stored procedures and functions-Design and use PL/SQL packages to group and contain related constructsCreate overloaded package subprograms for more flexibility-Use the Oracle supplied PL/SQL packages to generate screenoutput, file output, and mail output-Write dynamic SQL for more coding flexibility-Describe the features and syntax of PL/SQL. Use PL/SQL programming -onstructs and conditionally control code flow (loops, control structures, and explicit cursors)Manage dependencies between PL/SQL subprograms-Handle runtime errors. Describe stored procedures and functions-Design PL/SQL code for predefined data types,local subprograms, additional pragmas and standardized constants and exceptions-Create triggers to solve business challenges- Design PL/SQL anonymous block that execute efficiently. Contenido Del Curso Introduction Course Objectives Course Agenda Describe the Human Resources (HR) Schema PL/SQL development environments available in this course Introduction to SQL Developer Introduction to PL/SQLOverview of PL/SQL Identify the benefits of PL/SQL Subprograms Overview of the types of PL/SQL blocks Create a Simple Anonymous Block How to generate output from a PL/SQL Block? Declare PL/SQL Identifiers List the different Types of Identifiers in a PL/SQL subprogram Usage of the Declarative Section to Define Identifiers Use variables to store data Identify Scalar Data Types The %TYPE Attribute Whatare Bind Variables? Sequences in PL/SQL Expressions Write Executable Statements Describe Basic PL/SQL Block Syntax Guidelines Learn to Comment the Code Deployment of SQL Functions in PL/SQL How to convert Data Types? Describe Nested Blocks Identify the Operators in PL/SQL

Calle Reza # 292 esq. España * Teléfono -Fax 4522083 http://www.itacad.net * email: jmorato@itacad.net Cochabamba - BoliviaInteraction with the Oracle Server Invoke SELECT Statements in PL/SQL Retrieve Data in PL/SQL SQL Cursor concept Avoid Errors by using Naming Conventions when using Retrieval and DML Statements Data Manipulation in the Server using PL/SQL Understand the SQL Cursor concept Use SQL Cursor Attributes to Obtain Feedback on DML Save and Discard Transactions Control Structures Conditional processingusing IF Statements Conditional processing using CASE Statements Describe simple Loop Statement Describe While Loop Statement Describe For Loop Statement Use the Continue Statement Composite Data Types Use PL/SQL Records The %ROWTYPE Attribute Insert and Update with PL/SQL Records INDEX BY Tables Examine INDEX BY Table Methods Use INDEX BY Table of Records Explicit Cursors What are ExplicitCursors? Declare the Cursor Open the Cursor Fetch data from the Cursor Close the Cursor Cursor FOR loop The %NOTFOUND and %ROWCOUNT Attributes Describe the FOR UPDATE Clause and WHERE CURRENT Clause Exception Handling Understand Exceptions Handle Exceptions with PL/SQL Trap Predefined Oracle Server Errors Trap Non-Predefined Oracle Server Errors Trap User-Defined Exceptions Propagate ExceptionsRAISE_APPLICATION_ERROR Procedure Stored Procedures Create a Modularized and Layered Subprogram Design Modularize Development With PL/SQL Blocks Understand the PL/SQL Execution Environment List the benefits of using PL/SQL Subprograms List the differences between Anonymous Blocks and Subprograms Create, Call, and Remove Stored Procedures Implement Procedures Parameters and Parameters Modes View ProcedureInformation

Calle Reza # 292 esq. España * Teléfono -Fax 4522083 http://www.itacad.net * email: jmorato@itacad.net Cochabamba - Bolivia

Stored Functions and Debugging Subprograms Create, Call, and Remove a Stored Function Identify the advantages of using Stored Functions Identify the steps to create a stored function Invoke User-Defined Functions in SQL Statements Restrictions when...