Oracle Database 11g - PL/SQL Fundamentals

Course Categorization:
Oracle
Course Provider:
New Horizons Computer Learning Centers
Learning Method:
Classroom Learning
Provides 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.

Lesson 1: Volume 1

  • Choosing a SQL & PL/SQL Interface
  • Language Features
  • Declare Clause
  • Begin Clause
  • Exception Clause
  • Explicit Cursors
  • Advanced Programming: Declared Subprograms

Lesson 2: Volume 2

  • Introducing Database Program Units
  • Creating Stored Procedures & Functions
  • Maintaining Stored Procedures & Functions
  • Creating and Maintaining Packages
  • Advanced Cursor Techniques
  • Using System-Supplied Packages
  • Relating Database Triggers
  • Maintaining Database Triggers
  • Implementing System Even Triggers
  • Charleston, SC - April 23, 2012
  • Columbia, SC - April 23, 2012
  • Greenville, SC - April 23, 2012
  • Charleston, WV - April 23, 2012
  • Albany, NY - April 23, 2012
  • Charleston, SC - June 11, 2012
  • Columbia, SC - June 11, 2012
  • Greenville, SC - June 11, 2012
  • Greensboro, NC - June 11, 2012
  • Charleston, WV - June 11, 2012
  • Mechanicsburg, PA - June 11, 2012
  • Urbandale, IA - June 11, 2012
  • Charleston, SC - July 16, 2012
  • Columbia, SC - July 16, 2012
  • Greenville, SC - July 16, 2012
  • Charleston, WV - July 16, 2012
  • Charleston, SC - August 20, 2012
  • Columbia, SC - August 20, 2012
  • Greenville, SC - August 20, 2012
  • Charleston, WV - August 20, 2012
  • Greensboro, NC - August 27, 2012
  • Mechanicsburg, PA - August 27, 2012
  • Charleston, SC - September 24, 2012
  • Columbia, SC - September 24, 2012
  • Greenville, SC - September 24, 2012
  • Charleston, WV - September 24, 2012
  • Greensboro, NC - October 8, 2012
  • Charleston, SC - October 29, 2012
  • Columbia, SC - October 29, 2012
  • Greenville, SC - October 29, 2012

People Also Registered For

Oracle Database 11g - SQL Fundamentals

This course will prepare students for the Oracle certification exams (OCP).

Cisco® Interconnecting Cisco® Networking Devices Accelerated (CCNAX)

This course focuses on skills and knowledge necessary to install, operate, and troubleshoot a small to medium-size branch office Enterprise network. This course is an accelerated time format...

Cisco® Interconnecting Cisco® Networking Devices Part 1 (ICND1)

This course focuses on providing the skills and knowledge necessary to install, operate, and troubleshoot a small branch office Enterprise network, including configuring a switch, a router, and...

Oracle Database 11g - Administration I

This Oracle 11g training course will allow the student to gain the skills necessary for day-to-day administration of an Oracle database.

Data Communication Over TCP/IP V6 Networks

In this course, students will examine the enhancements made to TCP/IPv4 and some related protocols. Students will also examine the various transition strategies adopted to upgrade from TCP/IPv4 to...

Related Courses

Oracle Database 11g - SQL Fundamentals

This course will prepare students for the Oracle certification exams (OCP).

Oracle Database 11g - Administration I

This Oracle 11g training course will allow the student to gain the skills necessary for day-to-day administration of an Oracle database.

Oracle Database 11g - Administration II

This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a...

Oracle Database 11g - PL/SQL Fundamentals

Provides 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...