Training Course:Oracle BootcampSchool/Trainer: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 Oracles 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.
...''
Please go to the school's official website for training price and schedule: http://www.protechtraining.com/
Phone:800-373-9188
School Address:
610 Beatty Road Monroeville, PA 15146 USA
Jobs & Resumes: Overland Park Houses & Roommates: Overland Park
Other training courses offered by ProTech Professional Technical Services, Inc.:
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. |
|
|