Oracle Database 11g: PL/SQL Fundamentals - Self-Study Course
Starting dates and places
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 …
Frequently asked questions
There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.
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
- Using DML, DDL, and SQL Cursors in PL/SQL
- Using Control Structures and Loops in PL/SQL
- Using Data Types, INDEX BY, and PL/SQL Records
- Using Explicit Cursors and Attributes in PL/SQL
- 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
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.