Description
This intensive course addresses the use of SQL*Plus, the Oracle tool that provides an interactive implementation of SQL. The course teaches attendees how to connect to an Oracle7 database using SQL*Plus and to perform data manipulation, reporting and administrative tasks. Attendees will also learn SQL, the standard language used for accessing relational databases.

Audience
Analysts, designers and programmers who are actively involved in or preparing to embark on the development of systems using the Oracle database. This course is also appropriate for users who need to gain an understanding of Oracle SQL in order to produce reports based on data held in an Oracle database.

Prerequisites
Participants are not required to have had experience with SQL or any other database management systems.

Hardware and Software
Oracle7 properly installed on any platform, with sufficient logins for the number of students and instructor.

Format

• Presentation
  
• Hands-on
  

Objectives
After completing this course, participants should be able to:

• Apply relational database concepts
• Describe data grouping, aggregate functions, and SELECT statements
• Create new tables and indexes
• Insert, update, and delete data
• Utilize SQL functions and data handling
• Produce formatted reports
• Use SQL command files

Introduction

• Databases
• SQL
• 4th generation software development
• The Oracle product set

The Oracle Implementation of SQL and SQL*Plus

• SQL basics
• Combining data from more than one table
• Grouping and aggregates
• Naming and datatypes
• Tables and indexes
• Constraints
• Data modification
• Multi-user considerations and views
• SQL functions
• Dates
• Reporting with SQL*Plus
• SQL*Plus files
• Users and privileges

Tuning SQL

• The optimizer
• Optimizing alternatives
• Manually controlling optimization
• Optimization hints
• Shared SQL clauses
• Tuning FROM clauses
• Combining unrelated queries
• Indexes