Oracle Bootcamp

ProTech Professional Technical Services, Inc.
Overland Park, Kansas, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' The student will learn how to efficiently utilize basic, intermediate and advanced features of SQL, SQL*Plus, and Oracle’s procedural language, PL/SQL. The concepts mastered are the basis for the development of applications using Oracle, Oracle reporting, Oracle applications and Oracle database administration.

Audience: This course is designed for those who wish to efficiently program in the Oracle database environment.

Topics:
Overview of relational databases and Oracle
Characteristics of SQL
Sequences
Synonyms
Working with NULL values
Retrieving
Operators
CASE Statements
Subqueries
Joining tables
Functions
Datatype Conversion
Group Functions
Data Definition Language - CREATE, ALTER, DROP
Indexes
Views
Transaction processing - commit, rollback, and savepoint
Data manipulation - insert, update, delete
SQL*Plus Interface
SQL*Plus editor commands
Control breaks and computing values
Save commands and spool output
Formatting SQL*Plus output and reports
Introduction to PL/SQL
PL/SQL blocks
Declarations
Assignments
Using SQL statements in PL/SQL
Conditional statements
Looping statements
Using cursors
Cursor attributes
Cursor FOR loops
Using parameters with cursors
Exception (error) handling
User defined exceptions
Introduction to stored procedures and functions
Introduction to packages
Introduction to database triggers
Prerequisites: The student should have knowledge of relational database design concepts and the ability to utilize the host operating system to create and edit files.

...''

Phone:800-373-9188

School Address:

610 Beatty Road
Monroeville, PA 15146
USA

Jobs & Resumes: Overland Park
Houses & Roommates: Overland Park

Perl
TSO/ISPF
J2EE Web Application Development using Eclipse
Java Developers - Effective Coding for Performance
Java Programming Essentials Using Eclipse
Java Spring Framework
JavaServer Faces Development
Korn Shell Programming Essentials
MVS JCL
MVS Skill Pack (TSO, JCL)
Oracle PL/SQL
PHP/MySQL Programming
Programming Web Services in Java
Project Management Fundamentals for IT Projects
SQL
Stored Procedures in DB2 for Unix and Windows
UNIX and Linux System
Java for the Cobol Programmer
Comprehensive XML

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.