Oracle Database: PL/SQL Fundamentals Eğitimi

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.

Audiences

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

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

Topics

Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

Oracle Database 11g: Using DML, DDL, Cursors, Control Structures, and Loops

Oracle Database 11g: Using Data Types, INDEX BY Tables, and Cursors in PL/SQL

Oracle Database 11g: Working with Exceptions, Subprograms, JDeveloper, and REF Cursors