Oracle Intermediate - Online

ID : 14716   
« back to classes page

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)

Learning Objectives:

  • 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 a course demo

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-3355 or online@kennesaw.edu.

Class Details

38 Sessions
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor 

CEUs : 2.4

Fee: 

$179.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
9/13/2017 - 10/20/2017 Weekly -Sun, Mon, Tue, Wed, Thu, Fri, Sat 12:00 AM - 11:59 PM TBD Online Instructor 

Other Class Offerings

Oracle Intermediate - Online
ID: 15576

10/18/17 - 11/24/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor

Oracle Intermediate - Online
ID: 15578

11/08/17 - 12/15/17
Weekly - Wed, Thu, Fri, Sat, Sun, Mon, Tue

Location

Instructor
Online Instructor