Oracle Series

Oracle Series

SHARE
  • Details
  • Requirements

Details

Introduction to Oracle

Learn how to use the Oracle database management system to plan, organize, and manage your data. Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts and Oracle's database management system. This course will introduce you to the Structured Query Language (SQL), Oracle's SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database.

In this six-week online course, you will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database. This course will teach you how to write Data Definition Language statements to create, update, and delete database objects. You will learn how to execute Data Control Language statements to give or delete access rights to database objects. You will write Data Manipulation Language statements to insert, update, and delete records from a database. Finally, you will learn how to query the data and create finished reports.

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.

Series bundles are not eligible for partial drops or refunds. Transfers to other open sessions of the same course are available. Please refer to your school for additional details regarding drops, transfers, and refunds on Series bundles.

Enrollment Options:
Instructor-Led
Course Code: B8578
Start Dates*Nov 13 | Dec 11 | Jan 15 | Feb 12
*Choose start date in cart
$235.00

Requirements

• Internet access
• Email
• One of the following browsers: 
    o Mozilla Firefox 
    o Microsoft Internet Explorer (9.0 or above)
    o Google Chrome
    o Safari
• Adobe PDF  plug-in (a free download obtained at Adobe.com .)

 

Any type of computer with an installed copy of Oracle's Database Software. The Database Software is available for downloading from Oracle's website (www.oracle.com). Download the Oracle Database 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.