Oracle

The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation. Data is accessed through Structured Query Language (SQL) from Oracle database. SQL allows you to SELECT your data, INSERT new records, UPDATE or DELETE existing records. SQL can be embedded in other languages or you can run scripts of SQL directly against the database. PL/SQL is the procedural language extension to SQL. PL/SQL is a programming language like C or Java. SQL can be natively embedded in PL/SQL programs. By the end of this course, students will have learned how to write SQL queries and PL-SQL programs.

Audience

• This course is for programmers, end users, DBAs, or anybody who is interested in accessing data from oracle database or developing applications using oracle database.
• Students seeking to establish their career in Data ware housing or SQL/PL-SQL programming.
• Java/.NET front end programmers to enhance their skills in back end database.

Prerequisites

• Students should have some knowledge of a programming language (preferably C).