Oracle Database
Administration
Oracle PL/SQL – 5 days
Introduction Aggregating Data By Using Group Functions
• Describing the Life Cycle Development • Identifying the Different Group Functions
Phases Available
• Defining a Relational Database • Explaining the Use of Group Functions
• Discussing the Theoretical, Conceptual, • Grouping Data by Using the GROUP BY
and Physical Aspects of a Relational Clause
Database
• Describing How a Relational Database Producing Readable Output With isql*Plus
Management System (RDBMS) Is Used • Producing Queries That Require an Input
to Manage a Relational Database Variable
• Describing How SQL Is Used in the • Customizing the iSQL*Plus Environment
Oracle Product Set • Producing More Readable Output
Writing A Basic Sql Statement Creating And Managing Tables
• Describing the SQL Select Capabilities • Describing the Main Database Objects
• Executing a Basic Select Statement with • Creating Tables
the Mandatory Clauses • Describing the Oracle Data Types
• Differentiating Between SQL and • Altering Table Definitions
iSQL*Plus Commands • Dropping, Renaming, and Truncating Tables
Restricting And Sorting Data Manipulating Data
• Limiting the Rows Retrieved by a Query • Describing Each Data Manipulation
• Sorting the Rows Retrieved by a Query Language (DML) Command
• Inserting Rows into a Table
Single Row Functions • Updating Rows in a Table
• Describing Various Types of Functions • Deleting Rows from a Table
Available in SQL • Merging Rows into a Table
• Using a Variety of Character, Number, • Controlling Transactions
and Date Functions in SELECT • Describing Transaction Processing
Statements • Describing Read Consistency and Implicit
• Explaining What the Conversion and Explicit Locking
Functions Are and How They Are Used
Using Control Statements Including Constraints
• Describing Constraints
Displaying Data From Multiple Tables
• Creating and Maintaining Constraints
• Writing SELECT Statements to Access
Data from More Than One Table Creating Views
• Describing the Cartesian Product • Describing Views and Their Uses
• Describing and Using the Different Types • Creating a View
of Joins
• Retrieving Data by Means of a View
• Writing Joins Using the Tips Provided
• Inserting, Updating and Deleting Data
Through Views
• Dropping Views
• Altering the Definition of a View
• Inline Views
• Top ‘N’ Analysis
The Surrey Technology Centre • 40 Occam Road • Guildford • Surrey GU2 7YG
Tel: 01483 688488 Fax: 01483 573704
E-mail: info@acuitytraining.co.uk Web: www.acuitytraining.co.uk
Oracle Database
Administration
Oracle PL/SQL – 5 days
Other Database Objects Advanced Subqueries
• Creating, Maintaining, and Using • Multiple-Column Subqueries
Sequences • Writing a Subquery in the FROM Clause
• Creating and Maintaining Indexes • Writing and describing Correlated Subquery
• Creating Private and Public Synonyms • Using EXISTS and NOT EXISTS Operators
• Updating and Deleting Rows Using
SQL Workshop Correlated Subqueries
• Applying Techniques Learned in this • Using Scalar Subqueries in SQL
Course
• Preparing for Future Oracle Courses Hierarchical Retrieval
• Discussing the Benefits of the Hierarchical
Controlling User Access Query
• Understanding the Concepts of Users, • Ordering the Rows Retrieved by a Query in a
Roles and Privileges Hierarchical Manner
• Granting and Revoking Object Privileges • Formatting Hierarchical Data so That It Is
• Creating Roles and Granting Privileges to Easy to Read
Roles • Excluding Branches from the Tree Structure
• Creating Synonyms for Ease of Table
Access Oracle9i Extensions to DML and DDL
Statements
Using Set Operators • Discussing Multitable Inserts
• Describing the Set Operators • Creating and Using External Tables
• Obeying the Set Operators Rules and Naming the Index and Using the CREATE
Guidelines INDEX Command at the Time of Creating
• Using a Set Operator to Combine Multiple Primary Key Constraint
Queries into a Single Subquery
• Controlling the Order of Rows Returned
Oracle 9i Datetime Functions
• Using DATETIME 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 That Is Equivalent to a
UNION ALL Approach
Using the WITH Clause
The Surrey Technology Centre • 40 Occam Road • Guildford • Surrey GU2 7YG
Tel: 01483 688488 Fax: 01483 573704
E-mail: info@acuitytraining.co.uk Web: www.acuitytraining.co.uk