Oracle Database 11g: PL/SQL Fundamentals - Self-Study Course

Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

This Oracle Database 11g: PL/SQL Fundamentals training will teach you the basics of PL/SQL, syntax, blocks and programming constructs. By enrolling in a Self-Study Course, you'll be able to learn at your own pace, when it's most convenient for you.

Learn To:

  • Identify the programming extensions that PL/SQL provides to SQL.
  • Write PL/SQL code to interface with the database.
  • Design PL/SQL anonymous blocks that execute efficiently.
  • Use PL/SQL programming constructs and conditional control statements.
  • Seamlessly integrate procedural constructs with SQL.
  • Handle run-time errors.
  • Create stored procedures and functions.

Develop Your PL/SQL Fundamental Skills

The Procedural Language extension to SQL …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle 11G, PL/SQL, Oracle, CompTIA A+ / Network+ / Security+, and IT Security.

This Oracle Database 11g: PL/SQL Fundamentals training will teach you the basics of PL/SQL, syntax, blocks and programming constructs. By enrolling in a Self-Study Course, you'll be able to learn at your own pace, when it's most convenient for you.

Learn To:

  • Identify the programming extensions that PL/SQL provides to SQL.
  • Write PL/SQL code to interface with the database.
  • Design PL/SQL anonymous blocks that execute efficiently.
  • Use PL/SQL programming constructs and conditional control statements.
  • Seamlessly integrate procedural constructs with SQL.
  • Handle run-time errors.
  • Create stored procedures and functions.

Develop Your PL/SQL Fundamental Skills

The Procedural Language extension to SQL (PL/SQL) is Oracle Corporation's standard data access language for relational databases. Invest in this course to develop core PL/SQL skills that will serve you well in your career.


Audience
  • Application Developers
  • Database Designers
  • Forms Developer
  • PL/SQL Developer
  • Technical Consultant
  • Database Administrators

Course Topics Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements
  • Getting Started with PL/SQL Elements
  • Using Executable Statements
Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops
  • Using DML, DDL, and SQL Cursors in PL/SQL
  • Using Control Structures and Loops in PL/SQL
Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
  • Using Data Types, INDEX BY, and PL/SQL Records
  • Using Explicit Cursors and Attributes in PL/SQL
Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
  • Handling Exceptions in PL/SQL
  • Using JDeveloper and Cursor Variables

Course Objectives
  • Identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools
  • Identify the steps for using PL/SQL to manipulate data, control transactions, determine the outcome of statements, and create loops and conditional control structures
  • Recognize ways to create user-defined PL/SQL records and INDEX BY tables, and identify the steps for declaring and controlling explicit cursors and cursors with parameters
  • Recognize ways to handle unanticipated errors in PL/SQL, write stored procedures and functions, deploy Java applications and Web services, and use cursor variables

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.