Oracle 9i SQL Fundamentals

This hands-on course provides the basic knowledge and skills necessary to code SQL statements. Students will receive a hands-on introduction to SQL basics and SQL*Plus. The course also includes some relational database management system (RDBMS) concepts and terminology.

Class Agenda:

• Database Management System Overview
• What is a database?
• Types of DBMSs
• What is a Data Model?
• Reading an Entity Relationship Diagram
• Relational Database Management System Overview
• What is a RDBMS?
• What is SQL? SQL*Plus? PL/SQL?
• Difference between DDL, DML and DCL statements
• SELECT statement and mandatory clauses
• WHERE and ORDER BY clauses
• Single row functions
• Group functions
• GROUP BY and HAVING clauses
• Joining data from multiple tables
• Subqueries and set operators
• SQL*Plus Reporting
• Data Manipulation Language (DML) statements
• Transaction control

Prerequisites:

• An understanding of relational database design concepts.

Audience:

• Anyone retrieving data from an Oracle database using SQL.

Course Benefits:

• Students will understand relational database terminology, understand and code Oracle SQL statements and format reports using SQL*Plus statements. They will also be able to perform data maintenance using the insert, update and delete statements.

Materials Furnished:

• Student Manual

Recommended Follow-On Course:

• Oracle 9i Advanced SQL
• Oracle 9i PL/SQL Fundamentals
• Oracle 9i Performance Tuning for Developers

Course Length: Three Days

List Price: $1485