Dates/Locations:
11/08/2010-11/11/2010|San Antonio|
Duration:
4 Days
Course Overview:
In this class, students will learn how to create, retrieve & manipulate objects in Oracle 10g Structure Query Language (SQL). Students will also be introduced to Oracle 10g database features & tools. In addition, students will learn the functions of the PL/SQL programming language. Students will write stored procedures, functions, packages & triggers & implement complex business rules in Oracle. Students will learn programming, management & security issues of working with PL/SQL program units. Programming topics will include he built-in packages that come with Oracle, the creation of triggers & stored procedure features.
Course Objectives:
- Relational Database & SQL Overview
- Using Oracle SQL *Plus
- SQL Queries – the SELECT Statement
- Scalar Functions
- SQL Queries – Joins
- Aggregate Functions & Advanced Techniques
- Data Manipulation & Transactions
- Data Definition & Control Statements
- Other Database Objects
- Triggers
- PL/SQL Variables & Datatypes
- L/SQL Syntax & Logic
- Stored Procedures & Functions
- Exception Handling
- Records & Collections
- Cursors
- Using Packages
- Creating Packages
- Working with LOBs
- Maintaining PL/SQL Code
Prerequisites:
Basic knowledge or relational databases.
Related posts:
