Oracle Database 12c: PL/SQL Fundamentals

Course DateLocationDaysPriceRegister
Call for Classroom Training Dates2 $1,930Register


Course DateLocationDaysPriceRegister
Oct 23, 2017Live Virtual - 4:00 am Eastern2 $1,840Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $1,780Register


Oracle Database: PL/SQL Fundamentals

Description: This Oracle Database: 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 SkillsThe 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.

Duration: 0 Days

Course Objective:

  • 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

Audience:

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

Prerequisites:

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

Related Courses:

  • Oracle Database: PL/SQL Fundamentals
  • Instructor Led Training
  • Oracle Database: PL/SQL Fundamentals
  • Live Virtual Course
Course DateLocationDaysPriceRegister
Call for Classroom Training Dates2 $1,930Register


Course DateLocationDaysPriceRegister
Oct 23, 2017Live Virtual - 4:00 am Eastern2 $1,840Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $1,780Register