Oracle Database 10g Introduction to SQL - Part I Study Guide

1-4188-1101-7 © 2006 Publish date: April 4, 2005 369 pages

Buy Now: $119.99

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

Start with the basics of SQL by choosing the Oracle Database 10g Introduction to SQL - Part I study guide. This manual is a perfect starting point for administrators, developers, and end users to begin their studies when using our Oracle computer training books.

The Oracle Database 10g Introduction to SQL - Part I courseware introduces the SQL database language as it relates to Oracle databases. Whether you are an Oracle business or system professional, you will benefit from following this curriculum. It is specifically helpful for application developers and designer, database administrators, non-technical end users, and business users.

This self-paced course should take about three days to complete though you can take as long as you need to thoroughly absorb the content. You can work through each unit and complete the course activities at a comfortable pace. With the portable study guide at your side, you can study wherever you find yourself with a few minutes to spare. This manual can be used on its own to teach you the basics of SQL.

The Oracle Database 10g Introduction to SQL - Part I courseware is the first of a two-part series designed to get you up to speed with SQL and Oracle databases. To get the most out of this course, we recommend that you complete both parts of the series.

Course Objectives
By the end of this course, you will understand relational database principles and the Oracle relational database server as well as how to use traditional interfaces and the iSQL*Plus web-based database interface. You will be able to write simple to moderately complex SQL queries using various join techniques, summarize, group, and sort data, work with advanced query techniques, develop simple SQL*Plus reports, create and maintain database tables, and take advantage of new features including regular expressions.

Course Contents

Relational databases and SQL

• An overview of relational databases
• Elements of SQL

Working with SQL*Plus

• An overview of SQL*Plus
• Working with the SQL*Plus tool in MS Windows
• Working with the iSQL*Plus web tool
• How to enter commands and syntax

Creating a SELECT statement

• An overview of the SELECT statement
• Selecting columns
• Working with alias names

Creating a WHERE clause

• An overview of logical operators
• Working with equality operators
• Boolean operators
• Null and between operators
• Working with text strings
• In operator

Ordering result tables

• An overview of the order by clause
• Working with multiple column sorts
• 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 various functions
• Working with the dual table
• About the SessionTimeZone function

Joining tables

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

Working with set operators

• An overview of the set operators
• Set operator examples

Summary functions

• An overview of summary functions
• About summary functions with distinct

Working with sub-queries

• An overview of sub-queries
• Using standard sub-queries
• Using correlated sub-queries

Creating and selecting groups

• An overview of summary groups
• Finding groups and selecting data within the base tables
• Selecting groups from the result table

SQL*Plus commands

• An overview of SQL*Plus commands
• Working with script files
• Operating system commands
• How to save session output

Generating simple SQL*Plus reports

• An overview of the SQL*Plus report features
• Session output with SET
• Formatting column output
• Report breaks
• Computing subtotals

SQL Data Definition Language (DDL)

• An overview of SQL DDL
• Creating, altering, and dropping table statements
• Supportive statements

Working with 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