Oracle Database 11g: PL/SQL Fundamentals - Part 1

Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information

Description: 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.

Days: 2

Prerequisites: DATABASE 11G: SQL FUNDAMENTAL

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

CHOOSING A SQL & PL/SQL INTERFACE

· USING SQL DEVELOPER

· USING SQL*PLUS

· USING APPLICATION EXPRESS

· USING JDEVELOPER STUDIO

LANGUAGE FEATURES

· UNDERSTANDING PL/SQL

· STRUCTURE OF A PL/SQL PROGRAM BLOCK

· USING PL/SQL FROM SQL*PLUS

DECLARE CLAUSE

· ABOUT THE DECLARE CLAUSE

· DECLARE SIMPLE TYPES

· DECLARE COMPLEX TYPES

· TYPE ... TABLE

· TYPE ... RECORD

BEGIN CLAUSE

· ABOUT THE BEGIN CLAUSE

· PERFORMING DATA MANIPULATION

· LOGIC CONTROL & BRANCHING

· LOOP

· IF-THEN-ELSE

· CASE

EXCEPTION CLAUSE

· ABOUT THE EXCEPTION CLAUSE

· ISOLATING THE SPECIFIC EXCEPTION

· PRAGMA EXCEPTION_INIT

· SQL%ROWCOUNT & SELECT...INTO

EXPLICIT CURSORS

· ABOUT EXPLICIT CURSORS

· ADVANCED CURSOR TECHNIQUES

ADVANCED PROGRAMMING: DECLARED SUBPROGRAMS

Price: $995
Group Rate: $6,995
(Up to 14)

CompuWorks is Boston's leading independent training and IT services company. Since 1987, CompuWorks has been creating successful training programs for some of the largest organizations in Boston and all of New England. Our award winning classroom and vbook training covers everything from Microsoft Office, Server 2008, Exchange 2010, and SharePoint 2010to SQL 2008, Dynamics, Hyper-V Virtualization, and .NET. CompuWorks specializes in consultative training and can help your company develop a training program that fits your exact business needs. While known as Boston’s top technical and Microsoft Office training company, we also provide instructor led training in vBooks,VMware, CompTIA, Linux, Google Apps, Oracle, Adobe, ASL, Project Management, custom applications and more. All of our classroom training can be done at your location or we can train you at our state-of–the-art Boston training facility, the Boston Training Center.

CompuWorks can also assist your team with roll outs of new technology including deployment, creating the training path, developing the curriculum, and training your end users or we can be your complete outsourced training department solution and take all the work out of your hands. Check out our vbooks for the new elearning.

CompuWorks is proud to be both SOMWBA-certified as a woman-owned business and a Microsoft Gold Certified Partner with competencies in Information Worker Solutions & Learning Solutions. CompuWorks recently was named to the list of top 100 woman-owned businesses in Massachusetts by the prestigious Commonwealth Institute. The Boston Business Journal ranks CompuWorks as the largest independently owned training company in the region and Diversity Business ranks CompuWorks in the Top 50 Diversity businesses in Massachusetts.

Oracle Database 11g: PL/SQL Fundamentals - Part 1

Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information

Register for Classes

Also from CompuWorks

Oracle Database 11g: PL/SQL Fundamentals - Part 1

**Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information**

Register for Classes

Also from CompuWorks

Newsletter

Please note that CompuWorks will only accept students registering through a company or organization. Please click here for more information