|
|
|
Oracle 10g Essentials for Banner Professionals: SQL & SQL*Plus Basics and PL/SQL
Duration: 5 days
|
|
|
Oracle 10g Essentials for Banner Professionals: SQL & SQL*Plus Basics and PL/SQL
Duration: 5 days
Develop the skills to effectively interact with an Oracle 10g Database using Oracle SQL, SQL*Plus, and PL/SQL
Course Description:
You will receive an introduction to Oracle's relational database, and a hands-on introduction in how to add, update, extract and organize information from the database. You will cover how to format reports, and export data to ODBC files. You will work with Oracle's Structured Query Language (SQL), SQL*Plus, and (Procedural Language for SQL) PL/SQL. You will briefly cover debugging and error reporting procedures and how to define, execute and store procedures for reuse in the future.
You can learn to…
Extract and organize information from the database
Format reports using SQL*Plus commands
Insert, update & delete information in database tables
Work with the PL/SQL Environment and Program Structure
Use Error Report Functions, Debugging Procedures
Use Logical Comparisons
Define and Execute Procedures, and Functions,
Store and test a Function
Create Package Specifications
Store PL/SQL Program Units
Who Needs to Attend:
Anyone who needs to extract and organize information from an Oracle database, including formatting reports, adding, updating, and deleting data, and exporting data to ODBC files. I.e. Application designers, developers, database administrators, and End Users.
Prerequisites:
An understanding of relational database design concepts
Course Content:
Database Management System Overview
What is a Database?
Types of DBMSs
What is a Data Model?
Why Use an Entity Relationship Model?
What is an RDBMS?
Relationships between Tables
Understanding the Difference Between SQL, SQL*Plus, and PL/SQL
Entering and Executing Commands
Using iSQL*Plus
Understanding the iSQL*Plus Environment and Commands
Using the Data Dictionary Single Row Functions
Functions, Date and Numeric Format Models/Data Conversion, Control Statements Joining Data from Multiple Tables in Queries
The JOIN Condition / The Cartesian Product, Outer JOINs SET Operators, ANSI SQL99 Join Syntax
Distinct Operator in Group Functions
Single-Row, Multi-Row, Multi-Column Subqueries
Subqueries in a WHERE Clause, the FROM Clause, Views, the SELECT Clause, Subqueries
Single Row and Aggregating Analytic Functions
SQL*Plus Report Writing Commands
Control Breaks, Computing Aggregate Amounts
INSERT, UPDATE, DELETE, MERGE Command
Use of Subqueries, Transaction Control, Locking
SQL*Loader Basics, Importing Into Excel, Direct Database Queries Using ODBC
PL/SQL anonymous block structure and Datatypes
Variable declarations, Object naming rules, Executable Statements, Repetition control, CASE Expressions and Statements, Basic Coding Standards
Referencing other variables or a database column’s datatypes
Implicit cursor attributes, Transaction control commands
Selecting data into PL/SQL variables, Declaring explicit cursors
Handling predefined and user-defined exceptions
Preventing unhandled exceptions
Controlling exception processing
Introduction to procedures and functions stored in the database
Creating stored PL/SQL objects
Creating procedures, functions, packages, package bodies
Introduction to database triggers
Viewing and recompiling stored code
Course Labs:
RDBMS Principles
SQL*Plus Basics
Using iSQL*Plus
Insert, Update and Delete Data
SQL Queries
Filtering And Sorting Data
Single Row Functions
Joining Multiple Tables
ANSI SQL99 Joins
Group Clauses and Functions
Subqueries
Analyzing Data (Optional)
SQL*Plus Reporting
Using PL/SQL to create an Anonymous Block
PL/SQL Basics
Selecting and Updating Database Data
Using Explicit Cursors
Handling Exceptions
Creating a Procedure
Creating a Function
Creating a Package
Creating a Database Trigger
Unique Training Solutions for Unique Clients - Expanding skills today to meet the challenges of tomorrow
2/17/05