What's New

The Wait for Visual Studio 2008 is Over!

One may picture, too, the sudden shifting of the attention, the swiftly spreading coils and bellyings of that blackness advancing headlong,...

Introduction to Oracle 9i: SQL

Introduction to Oracle9i: SQL: Early Adopter
Course ID: D11782 | Duration: 5 Days
Class times are from 9 A.M. to 5 P.M.
Description:
Be the first to learn Oracle9i. Oracle University is offering the following course, Introduction to
Oracle9i: SQL for early adopters. The early adopter course is taught on Oracle9i beta products.
This early course version provides a student who is using the beta product or plans to use
Oracle9i soon after its production release, the opportunity to become familiar with Oracle9i. In
classes taught on beta products, the student may encounter in the practices features not currently
implemented, until the final product is released. The student may encounter unanticipated results
in the beta product while doing the practices. The Oracle9i early adopter courses provide a
valuable learning experience for those students who want to get the earliest available training on
new Oracle technology. This course offers students an extensive introduction to data server
technology. The class covers the concepts of both relational and object relational databases and
the powerful SQL programming language. Students are taught to create and maintain database
objects and to store, retrieve, and manipulate data. Students learn to retrieve data using
advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. They
also learn to write SQL and SQL*Plus script files to generate report -like output using the
iSQL*Plus tool. Demonstrations and hands -on practice reinforce the fundamental concepts.
Audience:
? Applications Developer
? Database Administrators
? System Analysts
? Technical Support Professionals
Required Prerequisites:
? Familiarity with data processing concepts and techniques
Suggested Prerequisites:
? Ability to use a graphical user interface (GUI)
Course Objectives:
? Describe relational and object relational database concepts
? Retrieve, insert, update, and delete data
? Create and maintain database objects
? Control transactions
? Control data/user access
? Use advanced techniques to retrieve data using ROLLUP, CUBE, set operators,
correlated subqueries, and hierarchical queries
? Use the new single row DATETIME and NVL2 functions introduced in Oracle9i
? Use GROUPING SETS and the WITH clause
? Solve problems using multicolumn subqueries, subqueries in the from clause of a
SELECT statement, correlated subqueries, and scalar subqueries
? Perform multi-table INSERTs and use External Tables
? Write SQL scripts which use SQL to generate SQL
? Use basic iSQL*Plus commands
? Use iSQL*Plus to format reports
Course Topics:
Introduction
? Describing the Lifecycle Development Phases
? Defining a Database
? Discussing the Theoretical, Conceptual, and Physical Aspects of a Relational Database
? Describing How a Relational Database Management System (RDBMS) Is Used to
Manage a
? Relational Database
? Describing the Oracle Implementation of Both the RDBMS and the Object Relational
Database
? Management System (ORDBMS)
? Describing How SQL Is Used in the Oracle Product Set
Writing a Basic SQL Statement
? Describing the SQL Select Capabilities
? Executing a Basic Select Statement with the Mandatory Clauses
? Differentiating Between SQL and iSQL*Plus Commands
Restricting and Sorting Data
? Limiting the Rows Retrieved by a Query
? Sorting the Rows Retrieved by a Query
Single Row Functions
? Describing Various Types of Functions Available in SQL
? Using a Variety of Character, Number, and Date Functions in SELECT Statements
? Explaining What the Conversion Functions Are and How They Are Used
? Using Control Statements
Displaying Data from Multiple Tables
? Writing SELECT Statements to Access Data from More Than One Table
? Describing the Cartesian Product
? Describing and Using the Different Types of Join
? Writing Joins Using the Tips Provided
Aggregating Data Using Group Functions
? Identifying the Different Group Functions Available
? Explaining the Use of Group Functions
? Grouping Data Using the GROUP BY Clause
? Including or Excluding Grouped Rows Using the HAVING Clause
Writing Subqueries
? Describing the Types of Problems That Subqueries Can Solve
? Describing What Subqueries Are
? Listing the Types of Subqueries
? Writing Single-Row and Multi-Row Subqueries
? Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved
Producing Readable Output with iSQL*Plus
? Producing Queries that Require an Input Variable
? Customizing the iSQL*Plus Environment
? Producing More Readable Output
? Creating and Executing Script Files
Manipulating Data
? Describing Each Data Manipulation Language (DML) Command
? Inserting Rows into a Table
? Updating Rows in a Table
? Deleting Rows from a Table
? Merging Rows into a Table
? Controlling Transactions
? Describing Transaction Processing
? Describing Read Consistency, and Implicit and Explicit Locking
Creating and Managing Tables
? Describing the Main Database Objects
? Creating Tables
? Describing the Oracle Data types
? Altering Table Definitions
? Dropping, Renaming, and Truncating Tables
Including Constraints
? Describing Constraints
? Creating and Maintaining Constraints
Creating Views
? Describing Views and Their Uses
? Creating a View
? Retrieving Data Via a View
? Inserting, Updating, and Deleting Data Through Views
? Dropping Views
? Altering the Definition of a View
? Inline Views
? Top ‘N’ Analysis
Other Database Objects
? Creating, Maintaining, and Using Sequences
? Creating and Maintaining Indexes
? Creating Private and Public Synonyms
Controlling User Access
? Understanding the Concepts of Users, Roles, and Privileges
? Granting and Revoking Object Privileges
? Creating Roles and Granting Privileges to Roles
? Creating Synonyms for Ease of Table Access
SQL Workshop
? Applying Techniques Learned in This Course
? Preparing for Future Oracle Courses
Using Set Operators
? Describing the Set Operators
? Obeying the Set Operators Rules and Guidelines
? Using a Set Operator to Combine Multiple Queries into a Single Subquery
? Controlling the Order of Rows Returned
? Oracle9i Single Row Functions
? Using the NVL2 Function to Handle NULL Values
Enhancements to the GROUP BY Clause
? Using ROLLUP as an Extension to the Group by Clause to Produce Subtotal Values
? Using CUBE as an Extension to the Group by Clause to Produce Cross-Tabulation
Values
? Using the GROUPING Function to Identify the Row Values Created by ROLLUP or
CUBE Operators
? Using GROUPING SETS to Produce a Single Result Set Which is Equivalent to a UNION
ALL Approach
? Using the WITH Clause
Hierarchical Retrieval
? Discussing the Benefits of the Hierarchical Query
? Ordering the Rows Retrieved by a Query in a Hierarchical Manner
? Formatting Hierarchical Data so that It Is Easy to Read
? Excluding Branches from the Tree Structure
Advanced Subqueries
? Updating and Deleting Rows Using Correlated Subqueries
? Writing a Multicolumn Subquery
? Describing and Explaining the Behavior of Subqueries When Null Values Are Retrieved
? Writing a Subquery in a FROM Clause
? Describing the Types of Problems That Can Be Solved with a Correlated Subquery
? Describing a Correlated Subquery
? Writing Correlated Subqueries
? Using the EXISTS and NOT EXISTS Operators
Writing Scripts to Generate Scripts
? Describing the Types of Problems that are Solved by Writing SQL Scripts that Generate
Other SQL Scripts
? Writing and Executing Scripts that Generate Scripts with Commands to Create and Drop
Tables
? Writing and Executing a Script that Generates a Script of INSERT INTO Commands
Suggested Next Courses:
Please check with your Education Representative to determine the appropriate follow up
course.
Related Courses:
No related Technology Bases Training Courseware is currently available.

AttachmentSize
Introduction to Oracle 9i SQL.pdf26.35 KB
Code: 
9i SQL
Duration: 
5
Price: 
6000000
Schedule: 
Available Upon Request