• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   Oracle DBA Training Courses

Introduction to Oracle 9i: SQL

View course dates

Course Duration: 5 days

Course Code: OCSQLINT

Course Description:

This class is applicable to Oracle9i and Oracle8i users. You learn concepts of relational databases, to create database structures and to store, retrieve, and manipulate data. Here you learn to query using Basic SQL Statements, restrict, sort, perform single row functions and group the queried data.

 

You will write advanced SELECT statements and use advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. You will query multiple tables, perform nested queries, implement constraints, use date and time functions, and create sequences and views.

 

You learn to write SQL and SQL*Plus script files using the iSQL*Plus tool to generate report-like output. Demonstrations and hands-on practice reinforce the fundamental concepts. The SQL Workshop will enhance your learning experience of SQL.

 

This course counts towards the Hands-on course requirement for the Oracle 9i Database Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.

 

Audience:
Database Administrators
System Analysts

 

Course Objectives:

- Describe relational and object relational database concepts
- Retrieve, insert, update, and delete data
- Use the Single row and Group functions
- Retrieve data using additional advanced techniques like using ROLLUP, CUBE, set operators, correlated subqueries and hierarchical queries
- Solve problems by using multicolumn subqueries, subqueries in the from clause of a SELECT statement, correlated subqueries, and scalar subqueries
- Use the iSQL*Plus environment
- Write scripts to generate script files
- Generate reports using iSQL*Plus
- Create and maintain database objects
- Control transactions
- Control data/user access
- Use the Oracle9i Single row functions
- Use GROUPING SETS and the WITH clause
- Use the Oracle9i extensions to DML and DDL statements
- Apply techniques in real life simulation

Prerequisites:

Required Prerequisites:

Familiarity with data processing concepts and techniques

Suggested Prerequisites:

Ability to use a graphical user interface (GUI

Relevant Certifications:

Oracle9i Database Administrator

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course