Home > Training > Introduction to Oracle:SQL & PL/SQL > Page 2

Introduction to Oracle:SQL & PL/SQL

Course Topics Contd... (Page 2)

Displaying Data from Multiple Tables
Writing SELECT Statements to Access Data from More Than One Table
Describing the Cartesian Product
Describing and Using the Four 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

Multi-Column Subqueries
Writing a Multi-Column Subquery
Describing and Explaining the Behavior of Subqueries When NULL Values Are Retrieved
Writing a Subquery in a FROM Clause

Producing Readable Output with SQL*Plus
Producing Queries that Require an Input Variable
Customising the SQL*Plus Environment
Producing More Readable Output
Creating and Executing Script Files
Saving Customizations

Manipulating Data
Describing Each Data Manipulation Language (DML) Command
Inserting Rows into a Table
Updating Rows in a Table
Deleting Rows from a Table
Controlling Transactions
Describing Transaction Processing

Creating and Managing Tables
Describing the Main Database Objects
Creating Tables
Describing the Oracle7 Data types and the Oracle8 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

Other Database Objects
Creating, Maintaining, and Using Sequences
Creating and Maintaining Indexes
Creating Private and Public Synonyms

<< Back|Next >>