Gain hands-on experience with Oracle's PL/SQL programming language. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, and you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing.
Prerequisite: Oracle Introduction (or equivalent experience)
- Learn what is PL/SQL and how to get started with PL/SQL.
- Learn about operators, expressions, and datatype conversions and how they work.
- Make use of Oracle's Built-in Functions.
- Learn how to use error handlers.
- Create Database Triggers, Apply Advanced Cursor concepts, and Learn How to Manage PL/SQL Code.
- Learn How to Debug Your Code.
View full course syllabus
For our online course refund policy, click here.
Requirements: Internet access, e-mail, Firefox or Internet Explorer web browser, and any type of computer with an installed copy of Oracle's Database Software (versions 8, 9, 10 or 11 are acceptable). The Database software is available for downloading from Oracle's website (www.oracle.com). Download the Oracle Database 10g Release 2 Standard Edition, Standard Edition One, and Enterprise Edition that supports your operating system. This course provides post-installation instruction on Oracle. Installation support will not be provided in the course. Installation support is provided from Oracle's website. Please be sure to install required software on your computer before the course begins.
You will need to create a login for your online classroom. Go to www.ed2go.com/ksuconed. Find your course by browsing the catalog or using the search bar. Click the ‘Add to Cart’ button (this site does not accept payments - you will not be charged here). Select your start date and then create a Username and Password. You must make an 80 or higher on the final exam (online) to successfully complete the course. You may only take the exam once.
If you have questions about this course, please contact the online coordinator at 470-578-6693 or firstname.lastname@example.org.