Courses Courses Arts and Design Arts and Design Animation Graphic Arts Photography Web Design Other Business Business Accounting Administrative Communication Finance Marketing and Sales Operations Project Management Small Business Soft Skills Career Online High School Career Online High School Online High School Diploma Computer Applications Computer Applications AutoCAD Microsoft QuickBooks Windows Other Computer Programming Computer Programming Programming Classes Construction and Trades Construction and Trades Construction Environmental and Energy Trades Health and Fitness Health and Fitness Alternative Medicine Dental Fitness Medical Veterinary Wellness Hospitality Hospitality Hospitality Service Information Technology Information Technology Cloud Computing Networking Other Security Language Language Languages Legal Legal Legal Studies Math and Science Math and Science Mathematics and Science Teacher Professional Development Teacher Professional Development Child Development Classroom Technology Math and Science Reading and Writing Other Test Prep Test Prep Exam Prep Writing Writing Writing and Editing How It Works How It Works About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
Courses
Arts and Design
Animation
Graphic Arts
Photography
Web Design
Other
Business
Accounting
Administrative
Communication
Finance
Marketing and Sales
Operations
Project Management
Small Business
Soft Skills
Career Online High School
Online High School Diploma
Computer Applications
AutoCAD
Microsoft
QuickBooks
Windows
Other
Computer Programming
Programming Classes
Construction and Trades
Construction
Environmental and Energy
Trades
Health and Fitness
Alternative Medicine
Dental
Fitness
Medical
Veterinary
Wellness
Hospitality
Hospitality Service
Information Technology
Cloud Computing
Networking
Other
Security
Language
Languages
Legal
Legal Studies
Math and Science
Mathematics and Science
Teacher Professional Development
Child Development
Classroom Technology
Math and Science
Reading and Writing
Other
Test Prep
Exam Prep
Writing
Writing and Editing
How It Works
About ed2go Externship Programs Financial Assistance Find a School Military Virtual Career Center
ed2go Courses Information Technology Other Intermediate Oracle
Return to Other
oracle-courses-online

Intermediate Oracle

Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. 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, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.

6 Weeks / 24 Course Hrs
Starting October 18, 2017

Offered in Partnership with your Preferred School

Los Angeles Valley College Why this school? It's been chosen based on your location or if you've visited this school's website.

Change School

Learning Method

Instructor-led Confirm your Start Date in Cart

Intermediate Oracle

Learning Method

Instructor-led Confirm your Start Date in Cart

Intermediate Oracle Reviews

Intermediate Oracle Details + Objective

Course Code: noc

You Will Learn
  • Learn the building blocks and core features of PL/SQL
  • Begin building fully functional PL/SQL programs
  • Understand procedures, packages, debugging routines, database structures, triggers, and cursor processing
  • Learn how to store PL/SQL programs in a database and execute them
How the course is taught
  • Instructor-led course
  • 6 weeks in duration
  • Courses begin each month
  • 2 lessons released each week
  • 24 course hours
How you will benefit
  • Gain hands-on experience with Oracle's PL/SQL programming language
  • Get the skills you need to write powerful and flexible programs using PL/SQL
  • Open the door to new programming opportunities once you master Oracle’s language
Intermediate Oracle Outline
Expand All
Week 1

In our first lesson, you'll master the basics of PL/SQL and discover how you can best get started using this powerful language. You'll also learn the differences between SQL, SQL*Plus, and PL/SQL. Then, you'll learn and understand the various datatypes available to you when declaring variables. You'll also explore the PL/SQL's block structure, its use, and its impact on the scope of variable declarations.

Week 2

Learn how to use operators to manipulate variables, and learn about datatype conversions for expressions that contain operands of multiple datatypes. Then, you'll take a closer look at how to create your own functions. You’ll also explore the various IF statements and how they operate, and you'll gain experience working with a simple loop.

Week 3

In this lesson, you'll begin to master more methods for changing the order of execution of PL/SQL blocks. We'll cover statement labels, the GOTO statement, and the different kinds of loops. Then, we’ll look at a number of Oracle’s built-in functions including string functions, number functions, date functions, and conversion functions.

Week 4

In this lesson, we'll focus on procedures and packages and how they allow you to organize your PL/SQL code into logical groups for uncomplicated maintenance and implementation. Then, learn the concepts behind PL/SQL exception handling including different types of exceptions and how to identify and handle errors in your code.

Week 5

In this lesson, we'll address the connection to the underlying Oracle database through SQL (Structured Query Language). We'll cover the usage of SQL's Data Manipulation Language (DML) commands within a PL/SQL block. Then you'll learn how to define DML transactions that insert, update, delete, and query the information. You’ll also get an introduction to cursors which provide a method for selecting multiple rows of data from a database and processing each row individually.

Week 6

In this lesson, you'll learn about triggers and experiment with implementing a few different types of functionality. You’ll also learn techniques to managing PL/SQL code. And finally, we’ll demonstrate how to find bugs and then how to reduce the number of coding mistakes you may encounter.

View All Sections
Intermediate Oracle Instructors
Cindy Delia

Cindy Delia is a Systems Analyst and a certified instructor. She has been working in information technology for more than 18 years and has been a technical trainer for over 6 years. As a Systems Analyst, she specializes in database management systems and develops PC applications. She has taught computer courses at the community college level and also performs corporate training. Cindy has also written technical manuals for WordPerfect.

Intermediate Oracle Requirements / Prerequisites

There are no prerequisites for this course.

Completion of Cindy Delia's "Introduction to Oracle" course (or equivalent experience), and any type of computer with an installed copy of Oracle's Database Software. The Oracle Database software is available for downloading from Oracle's website (www.oracle.com). Select Oracle Database under the Downloads section and download the Oracle Database 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.

 

Intermediate Oracle Frequently Asked Questions
Expand All
When can I get started?

A new session of each course opens each month, allowing you to enroll whenever your busy schedule permits!

How does it work?

Once a session starts, two lessons will be released each week, for the six-week duration of your course. You will have access to all previously released lessons until the course ends.

How long do I have to complete each lesson?

Keep in mind that the interactive discussion area for each lesson automatically closes 2 weeks after each lesson is released, so you’re encouraged to complete each lesson within two weeks of its release.

What if I need an extension?

The Final Exam will be released on the same day as the last lesson. Once the Final Exam has been released, you will have 2 weeks plus 10 days to complete the Final and finish any remaining lessons in your course. No further extensions can be provided beyond these 10 days.

Browse All