SkillBuilders Welcome  |  Log in
All Oracle Classes

SkillBuilders Oracle PL/SQL Programming Workshop:
3 Day Onsite or 21 Hour Online Hands-On Training

This class will teach you how to write efficient and scalable PL/SQL programs to create database-intensive PL/SQL applications. You will learn the critical and fundamental aspects of PL/SQL language.

Learning how to create efficient, scalable PL/SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different formulations of a routine and profiling PL/SQL programs to identify the code that should be tuned.

Enrollment includes this Great O'Rielly text book "Oracle PL/SQL Best Practices". 

Hands-on workshops constitute approximately 50% of the class.

For customer-site training, as with all of our courses, this class is highly customizable to your specific training requirements.

Also see these free online tutorials:

Average Student Rating:
28 comments
Rachel Kimmitt City of Fort Collins
I would actively go through examples while typing instead of just going through slides. It should be an exercise similar to the one in the lab. And then have the lab. Then go through the lab correcting errors like we did so we can engage more in the answers. Also use something easier to look at than SQL Plus.

Geoff is great about answering questions. The materials are great to have.

Douglas Burkes City of Fort Collins
[What did you particularly like about the course?] Being able to work with the course material and ask questions about real world issues we are having.

Dan Dailey
I liked doing the workshops. They helped to answer any questions I might of had

Arleah D'Agostini United Physicians
Instructor is excellent - we have more united physician team members taking sql and plsql classes in the near future based on past.

Kenneth Harper Votec Corporation
The instructor was very patient and also very knowledgeable about the subject.

Eric Thon
Instructor was focused an re-iterated key concepts.

Linda MacMinn Florida Keys Community College
The online delivery was great, no suggestions for improvement.

The instructor tailored the course content to my skill level, while still achieving the course objectives. He also was very generous in rescheduling when I had no access to the internet for several days!

Rachel Sullivan Sherwin Williams
The instructo was nice

Guillermo J. Rivera Sherwin Williams
He cover a lot of info in 2 days.

Kostatin Bojovic Sherwin Williams
Hands-on examples.

Specify the target audience better. It was very helpful having coding experience prior to the beginners' course. However, one without prior experience had many difficulties.

Linda Huack Sherwin Williams
Should be 3 days instead of 2.

Marcelino Reyes Sherwin Williams
The instructor was very prepared.

Matthew Davis Sherwin Williams
[What did you particularly like about the course?] Instructor's knowledge and enthusiam

Ryan Beno Sherwin Williams
The book with the course was very helpful

Annie Matsudaira City of Seattle
Got a better understanding of Pl/Sql that made reading I've already done, make more sense. I have a better picture of what some of my coding practices should be, especially using packages more!

katie bourbeau haemonetics
the instructor was able to immediately respond to questions and comments while presenting the material

more exercises that are short and quick to reinforce the various subjects presented.

Stephanie Collins Hampton City Schools
[No improvements necessary.] Liked the share screen option.

Small class size and interaction with others and instructor.

Allen Leung Pratt & Whitney Rocketdyne
The delivery of audio and video is quite good except just a few instance of choppy video.

Daniel Law PWR
Instructor, Dan McGhan, helped everyone on the class to set up the lab and help us individually to debug our programming exercises if we needed help. Dan is a great instructor and he answers all students' questions. I like the GoToMeeting setup, too. We can submit questions online instead of interrupting the pace of the class. Dan answered all my submitted questions online.

Brandon Austin NTI
The instructor was very knowledgeable in this area. The use of GoToMeeting made it easy to interact.

Wendy Copeland Toshiba America Medical Systems, Inc.
This was the first time I took a course over the Internet with Headphones and a Microphone. It worked out better than I expected.

Instructor was very patient and knowledgeable. Being new to PL/SQL, I was worried about being too slow, but the pace was okay.

Terry Cross Walker and Associates, Inc
particularly like the hands on workshops

Dennis Barrett Walker and Associates, Inc.
Geoff is one of the best instructors I've had for any training.

Stacey Hedrick Walker & Associates, Inc.
The fact that the material was well layed out and the workshops really helped explain what was going on. I really liked the workshops where we could run the .sql program and it would gives us questions as we did the lab. Good Job overall!

bobby allen walker and associates
the instructor was very knowledgable in the subject.

the excercises need to be in a tutorial based layout. for me it was very hard to decide where to start. have the students work through a step by step tutorial then have them do an excercise based on the tutorial in each chapter.

Mitzi Tester Walker and Associates, Inc
The exercises helped reinforce what you were learning. Geoff was great!

Terry Cross Walker and Associates, Inc
The hands on learning.

Boris Margulis UBS PaineWebber
Advanced feature of Oracle were well covered

 
SkillBuilders Sample Video