IT Training

Oracle Database 11g R2: PL SQL Fundamentals I and II

ora11g101-ver1
5 Days
2 (?)
$2,750.00
Download PDF Request a Course Date Share This Course

Description

Related Courses

Oracle Database 11g R2: Advanced PL SQL Programming and TuningOracle Database 11g R2: New and Advanced Features For Developers
The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle database.

Course Outline

Related Courses

Oracle Database 11g R2: Advanced PL SQL Programming and TuningOracle Database 11g R2: New and Advanced Features For Developers


Volume I:
CHOOSING A SQL & PL/SQL INTERFACE
LANGUAGE FEATURES
DECLARE CLAUSE
BEGIN CLAUSE
EXCEPTION CLAUSE
EXPLICIT CURSORS
ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS

Volume II:
INTRODUCING DATABASE PROGRAM UNITS
CREATING STORED PROCEDURES & FUNCTIONS
MAINTAINING STORED PROCEDURES & FUNCTIONS
CREATING & MAINTAINING PACKAGES
ADVANCED CURSOR TECHNIQUES
USING SYSTEM-SUPPLIED PACKAGES
CREATING DATABASE TRIGGERS
MAINTAINING DATABASE TRIGGERS
IMPLEMENTING SYSTEM EVENT TRIGGERS

Audience

Related Courses

Oracle Database 11g R2: Advanced PL SQL Programming and TuningOracle Database 11g R2: New and Advanced Features For Developers
Target Audience
Target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are:
• Application designers and developers
• Database administrators
• Business users and non-technical senior end users

College Credit, CEUs, PDUs and CDUs
When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.

College Credit through The University of Findlay
Select curriculum offered by Babbage Simmel is part of the accredited University of Findlay's undergraduate and graduate course catalogs. For questions please E-Mail: info@babsim.com or call 800-288-5937.

Continuing Education Units (CEUs)
Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, call us at 800-288-5937.

Professional Development Units (PDUs)
Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Babbage Simmel's provider number with PMI® is 1737. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 610-356-4600.

Continuing Development Units (CDUs)
CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 866-512-4422.

babsimLIVE live distance learning is hands-on, instructor-led training in real-time. The training is live and interactive. Using the latest technologies, babsimLIVE is an innovative solution for distance learning that makes it possible for students to attend one of our public classes without the need to travel.

Unlike other distance learning options, babsimLive brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Marble Cliff Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.