Oracle Database 10g: Program with PL/SQL

Computer Training Unit, North Carolina State University
Raleigh, North Carolina, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Students learn to create anonymous PL/SQL blocks, stored procedures, and functions. They learn about declaring variables and trapping exceptions. Students will also learn to develop stored procedures, functions, packages and database triggers. Students will learn to manage PL/SQL program units manage dependencies, manipulate large objects, and use some of the Oracle-supplied packages. Students use iSQL*Plus to develop these program units. Demonstrations and hands-on practice reinforce the fundamental concepts.

Duration: 40 hrs

Tuition: $1299

Suggested Prerequisites: Should have taken Oracle Database 10g: Introduction to SQL course.

Attend and You Will Learn
Lesson 1: Design PL/SQL anonymous blocks that execute effici
. Lesson 2: Write PL/SQL code to interface with the database
. Lesson 3: Describe the features and syntax of PL/SQL
. Lesson 4: Use PL/SQL programming constructs and conditionall
. Lesson 5: Handle runtime errors
. Lesson 6: Create simple procedures and functions
. Lesson 7: Design PL/SQL packages to group and contain relate
. Lesson 8: Categorize and Use the Oracle supplied PL/SQL pack
. Lesson 9: Schedule PL/SQL jobs to run independently
. Lesson 10: Write dynamic SQL for more coding flexibility
. Lesson 11: Create triggers to solve business challenges
. Lesson 12: Manage dependencies between PL/SQL subprograms
...''

Phone:919.515.8163

School Address:

Computer Training Unit
NC State University
McKimmon Center
1101 Gorman Street
Raleigh, NC 27606 USA

Jobs & Resumes: Raleigh
Houses & Roommates: Raleigh

Programming with Microsoft Visual Basic .NET
Microsoft Office Specialist Excel 2003
Microsoft Office Specialist Access 2003
Microsoft Office Specialist Word 2003
Microsoft Office User Specialist Test Prep
Certificate in Network Security
CompTIA Network+
Oracle 9i: SQL
Oracle Database Administrator 10g (DBA)
Oracle Database 10g Administrator Certified Professional
Oracle Database 10g: Security
Oracle Database 10g Administrator Certified Associate
Oracle DBA
Oracle Performance Tuning and Monitoring
CompTIA Security+

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.