Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Introduction Oracle Database 10g: SQL Training

Introduction Oracle Database 10g: SQL Training

Course#: WA1637

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.

Objectives 

Specific subject areas to be explored and objectives to be reached are:

  • A summation of relational database principles and an introduction to the Oracle relational database server.
  • Using the iSQL*Plus web-based database interface and other traditional interfaces.
  • Writing simple SQL queries and moderately complex SQL queries using various join techniques.
  • Summarizing, grouping and sorting data.
  • Advanced query techniques such as correlated subqueries.
  • Developing simple SQL*Plus reports.
  • Creating and maintaining database tables.
  • Taking advantage of new features such as the use of regular expressions.
  • Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
  • Understanding basic database security and object privileges.
  • Using the powerful set of built-in SQL functions.
  • Protecting the database and extending the basic data model using declarative constraints.
  • Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax.
  • Developing complex SQL*Plus reports and using SQL*Plus scripts. 

Audience

The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:

  • Application designers and developers.
  • Database administrators.
  • Business users and non-technical end users. 

Duration

Three days.

Outline of WA1637 Introduction Oracle Database 10g: SQL Training

1. RELATIONAL DATABASES & SQL

  • ABOUT RELATIONAL DATABASES
  • ELEMENTS OF SQL

2. USING SQL*PLUS

  • ABOUT SQL*PLUS
  • USING THE MS WINDOWS SQL*PLUS TOOL
  • USING THE ISQL*PLUS WEB TOOL
  • ENTERING COMMANDS & SYNTAX

3. BUILDING A SELECT STATEMENT

  • ABOUT THE SELECT STATEMENT
  • SELECTING COLUMNS
  • USING ALIAS NAMES

4. BUILDING A WHERE CLAUSE

  • ABOUT LOGICAL OPERATORS
  • EQUALITY OPERATOR
  • BOOLEAN OPERATORS
  • NULL & BETWEEN OPERATORS
  • FINDING TEXT STRINGS
  • IN OPERATOR

5. ORDERING THE RESULT TABLE

  • ABOUT THE ORDER BY CLAUSE
  • MULTIPLE COLUMN SORTS
  • SPECIFYING THE SORT SEQUENCE
  • ABOUT NULL VALUES WITHIN SORTS
  • USING COLUMN ALIASES

6. PSEUDO COLUMNS & FUNCTIONS

  • ABOUT PSEUDO COLUMNS & FUNCTIONS
  • USING ROWID
  • USING ROWNUM
  • USING THE FUNCTIONS
  • USING THE DUAL TABLE
  • SESSIONTIMEZONE FUNCTION

7. JOINING TABLES

  • ABOUT JOINS
  • INNER JOIN
  • REFLEXIVE JOIN
  • NON-KEY JOIN
  • OUTER JOIN

8. USING SET OPERATORS

  • ABOUT THE SET OPERATORS
  • SET OPERATOR EXAMPLES

9. SUMMARY FUNCTIONS

  • ABOUT SUMMARY FUNCTIONS
  • SUMMARY FUNCTIONS WITH DISTINCT

10. USING SUBQUERIES

  • ABOUT SUBQUERIES
  • STANDARD SUBQUERIES
  • CORRELATED SUBQUERIES

11. CREATING & SELECTING GROUPS

  • ABOUT SUMMARY GROUPS
  • FINDING GROUPS WITHIN THE BASE TABLES
  • SELECTING DATA FROM THE BASE TABLES
  • SELECTING GROUPS FROM THE RESULT TABLE

12. SQL*PLUS COMMANDS

  • ABOUT SQL*PLUS COMMANDS
  • MORE ABOUT SCRIPT FILES
  • INVOKING OPERATING SYSTEM COMMANDS
  • SAVING SESSION OUTPUT

13. BUILD SIMPLE SQL*PLUS REPORTS

  • ABOUT THE SQL*PLUS REPORT FEATURES
  • SESSION OUTPUT WITH SET
  • FORMAT COLUMN OUTPUT WITH COLUMN
  • DEFINING REPORT BREAKS WITH BREAK
  • PRODUCE SUBTOTALS WITH COMPUTE

14. SQL DATA DEFINITION LANGUAGE

  • ABOUT SQL DDL
  • CREATE TABLE STATEMENT
  • ALTER TABLE STATEMENT
  • DROP TABLE STATEMENT
  • SUPPORTIVE STATEMENTS

15. SQL DATA MANIPULATION LANGUAGE

  • ABOUT SQL DML
  • ABOUT THE INSERT STATEMENT
  • ABOUT THE DELETE STATEMENT
  • ABOUT THE UPDATE STATEMENT
  • ABOUT TRANSACTIONS
  • TRUNCATE TABLE
  • COMPLEX TABLE REFERENCES
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.