ORA-PL: Oracle – PL/SQL

Oracle – PL/SQL
Course content:

PL/SQL Language Study – Syntax, Anonymous blocks, Application Blocks and Control Structures
PL/SQL Advanced: Triggers – Construct and Usage.
Functions – Constructs and Usage. Use in reporting and intermediate procedural calculations.
Procedures and Packages – Study of PL/SQL variables, User Defined variables, cursors and exception handling. Study of ackages – Package Specification and package body.
Exception Handling – Using built-in exceptions and user defined exceptions.

Book Information:

The Sybex Oracle DBA Certification Kit books are used for the Oracle DBA track.
OCP: Oracle Database 11g Adminsitrator Study Guide – Biju Thomas. Sybex, ISBN: 978-0-470-39512-7

System Requirements for doing Labs:

Processor: Dual Core. Must be a x64 processor with hardware-assisted virtualization support (Intel VT-x or AMD-V).
Memory: 4GB RAM
Disk Space: 50GB of free hard drive space
OS: Vista or Windows7/8

Want to take this class? Let us know by clicking here.

"Just wanted to thank you and let you know I had a pleasant experience with Brad Rudisail as my Instructor for my first class with Texcellent."

Pierre-Alain S., Client Manager, Echo Technology Solutions.
"The instructor clearly possessed a superior knowledge of Windows operating systems and was able to explain concepts in a clear and logical manner. This was a positive learning experience for me and I gained a lot of new knowledge that will help with my current and future job assignments."

Richard K., Enpointe Technologies, Inc.
"This was my first online class and, I was skeptical on the format. But my experience with this class has made me want to sign up for more classes."

John W., Perot Systems
"The class was well laid out, excellent quizzes, current related information in every class, hands on practical experience on all topics - excellent teacher! Best I've ever had, by far."

Richard H., Asthmatx, a student in the Security Class.
"The teacher was very good, he knew his subject extremely well. The (online) class was better than any other classroom training, that I have taken earlier."

Panya R, Aynap Network Solutions, Inc.
"Your courses are very helpful! I did pass PMP certification after taking the training from you."

David W., Alladin Technologies.
"The instructor is an expert in the subject matter and has in-depth knowledge about subject. He spent time with the students and was available during or after the class for any questions or concerns. He explained the concept very clearly and objectively."

Ifthikar A., Teradata, a student in the Java Programming class.
"Best class of the three I've taken so far. The information was concise and presented to us in a manner that was logical and easy to understand. I am sure I will use the knowledge I gained from this course in the workplace."

Richard S. of D-Link
"This is a fun class to be in while learning a very serious subject. I enjoyed the class a lot and will recommend others to come and learn. Thank you for teaching us."

Caudy C. of Quest Software
"The teacher you provided was very, very, very, very, very good and was instrumental in my keeping up with the class at all. She is someone with whom I would be looking forward to take several classes."

Patrick P., Maul Manufacturing Inc.,
"Dawson Byrd is a very informative and knowledgeable instructor. He is clear, concise, and presents the course in a real-world setting; not as a textbook only format."

Danielle P., Telepacific, Inc.,
"The training helped me pass MCP and MCDST Certification exams."

Charles L., Enpointe Technologies, Inc.
"In the last 2 years I have successfully completed a few classes with Texcellent. I have found that the quality of the training is superb, and the instructors are real pros. would like to continue to take all the SQL Server DBA classes and apply the skills to my job."

Martine A., Computer Sciences Corporation.
"I took the CCENT exam and passed with an 895/1000. Thanks again for the great class!"

Kenneth K., Websense, San Diego, CA.
"I just wanted to say that Faraaz did an excellent job teaching the Cisco CCNA Class"

Carlos T., Anabolic Laboratories.
"Tom is just a wonderful instructor for Project Management Courses. He has in depth knowledge of Project Management. His classes actually helped me in getting my PMP Certification. I thank Texcellent for having such professional instructors as part of their team."

V. Chandra, HCL Systems.
"This is my third Texcellent course and second class with Rizwan Dhami. I have completely enjoyed SQL Design Class. I would encourage anyone who wants to advance their professional skills to join Texcellent and Rizwan."

John G., Total Micro Systems
"I was part of a class on VMware infrastructure-related technologies. I already had some experience in the subject, but even this introductory course went through areas where I wasn't familiar and I was able to immediately apply the material to real-world deployments at my company. With the amount of background industry experience that the instructor has, it's no surprise that he's able to fill in knowledge gaps for even currently well-versed administrators."

Kimi U., i-Pass Inc.
"I was in two of your Project Management classes last year. I wanted to let you know that I finally took and passed the PMP Certification Exam."

Rosie C., ConAgra Foods.
"I am very grateful for your training. I already got a great job because of it and my salary increased by $20,000 per year."

Scott F., Affiliated Computer Services, Santa Ana, CA.

Share This