Tuesday 29 January 2008

Oracle Database 10g: SQL Fundamentals I



D17108GC21

This course offers students an introduction to Oracle Database 10g Database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
This course also introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the class, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Students learn to create anonymous PL/SQL blocks and are introduced to stored procedures and functions. They learn about declaring variables, trapping exceptions and they also learn to declare and control cursors.

Demonstrations and hands-on practices reinforce the fundamental concepts.

Learn To:
Use SQL Statements to retrieve data from tables and employ SQL functions to generate and retrieve customized data
Declare PL/SQL Variables and Work with Composite data types
Run data manipulation statements (DML) to update data in the Oracle Database 10g
Write Control Structures and work with Explicit Cursors
Create and Manage Tables
Handle Exceptions

Download:
http://rapidshare.com/files/80561044/D17108GC21_ppt.rar

Password: www.bluelibrary.org

No comments: