Oracle Database 10g Introduction to SQL - Complete Library Study Guide

1-4188-4727-5 © 2006 Publish date: April 6, 2005 785 pages

Buy Now: $199.99

Course ID: oracle-db-10g-intro-sql-complete-sg

CBT Planet is pleased to bring you a fantastic addition to our selection of Oracle-oriented computer training books, the Oracle Database 10g Introduction to SQL - Complete Library study guide. This self-paced course introduces you to SQL covering concepts and commands that you need to know when working with Oracle Database 10g products.

By choosing the Oracle Database 10g Introduction to SQL - Complete Library courseware, you will learn about relational databases and SQL, SQL*Plus, building SELECT statements and WHERE clauses, ordering the result table, pseudo columns and functions, joining tables, set operators, and summary functions. In addition, you will learn about sub-queries, creating and selecting groups, SQL*Plus commands, building simple SQL*Plus reports, SQL Data Definition Language, and SQL Data Manipulation Language.

Other topics include SQL99 join techniques, enhancing groups with ROLLUP and CUBE, case expression, character and non-character SQL functions, database objects, database security, data integrity, maintaining constraint definitions, advanced SQL*Plus reports and scripts, and advanced SQL and SQL*Plus features.

The Oracle Database 10g Introduction to SQL - Complete Library courseware is an excellent tool to use in order to learn SQL commands and features on your own terms and according to your own schedule. It also makes an excellent reference book after the course is complete.

Course Contents

Relational databases and SQL

• An overview of relational databases
• The elements of SQL

Working with SQL*Plus

• An overview of SQL*Plus
• Working with the MS Windows SQL*Plus tool
• Working with iSQL*Plus web tool
• Entering commands and syntaxes

Building SELECT statements

• An overview of the select statement
• How to select columns
• Working with alias names

Creating WHERE clauses

• An overview of logical operators
• Equality operators
• Boolean operators
• Null and between operators
• How to find text strings
• In operator

Ordering the result table

• An overview of the order by clause
• Working with multiple column sorts
• Specifying sort sequences
• An overview of null values within sorts
• Working with column aliases

Pseudo columns and functions

• An overview of pseudo columns and functions
• Working with ROWID
• Working with ROWNUM
• Working with functions
• Working with the dual table
• The SessionTimeZone function

Joining tables

• An overview of joins
• Working with inner joins
• Working with reflexive joins
• Working with non-key joins
• Working with outer joins

Working with set operators

• An overview of the set operators
• Examples of set operators

Summary functions

• An overview of summary functions
• Distinct summary functions 

Working with sub-queries

• An overview of sub-queries
• Standard sub-queries
• Correlated sub-queries

Creating and selecting groups

• An overview of summary groups
• How to find groups within the base tables
• How to select data from the base tables
• How to select groups from the result table

SQL*Plus commands

• An overview of SQL*Plus commands
• Script files
• Invoking operating system commands
• How to save session output

Building simple SQL*Plus reports

• An overview of the SQL*Plus report features
• Session output with set
• How to format column outputs 
• Defining report breaks
• Producing subtotals 

SQL Data Definition Language

• An overview of SQL DDL
• Creating table statements
• Altering table statements
• Dropping table statements
• Supportive statements

SQL Data Manipulation Language (DML)

• An overview of SQL DML
• An overview of the insert statement
• An overview of the delete statement
• An overview of the update statement
• An overview of transactions
• Truncate table
• Complex table references

SQL99 join techniques

• An overview of ANSI/ISO SQL99
• About cross joins
• About natural joins
• About inner joins
• About outer joins
• About anti-joins
• Working with named sub-queries

Enhancing groups with ROLLUP and CUBE

• An overview of enhanced group processing
• Working with ROLLUP
• Working with CUBE

Working with the case expression

SQL functions: character

• About SQL functions
• About character functions

SQL functions: non-character

• About numeric functions
• About date format functions
• About date arithmetic functions
• About null value functions

Database objects: relational views

• An overview of database objects
• An overview of relational views
• How to update view data
• How to maintain view definitions

Database objects: data dictionary storage

• An overview of the data dictionary
• About object-specific dictionary views
• Understanding data dictionary structures

Database objects: other objects

• Indexes
• Application schema
• Tables
• Defining sequences
• Synonyms
• Creating schema authorization

Database security

• An overview of database security
• User IDs and passwords
• Setting object security

Data integrity using constraints

• An overview of constraints
• The NOT NULL constraint
• About the check constraint
• About the unique constraint
• About the primary key constraint
• About the references constraint
• How to define constraints on existing tables

Maintaining constraint definitions

• Maintaining constraints
• Renaming and dropping constraints
• Enabling and disabling constraints
• How to validate new transactions only
• About deferred enforcement
• How to manage constraint exceptions
• Working with constraints and views
• Working with data dictionary storage

Advanced SQL*Plus reports

• An overview of the report commands
• Break command
• Compute command
• Column command
• TTITLE and BTITLE commands

Creating SQL*Plus scripts

• An overview of script files
• Working with SQL*Plus variables
• Accept
• Prompt
• Pause

Advanced SQL and SQL*Plus features