---

You will receive a hands-on introduction to SQL Basics and SQL*Plus including a basic knowledge of relational databases and how to access them through SQL and SQL*Plus. Topics necessary to the development and administration of an Oracle 10g database are covered. This class is applicable to Oracle8i, Oracle9i, and Oracle Database 10g users.

Highlights

• To converse in relational database terminology
• To understand Structured Query Language basics
• To format reports using SQL*Plus commands
• To extract and organize information from the database
• To insert, update & delete information in database tables
• To create and drop tables, views, synonyms and indexes

Course Outline

1. In the Beginning.Database Management System Overview

• What is a database?
• Types of DBMSs

2. Introduction to Entity Relationship Modeling

• What is a data model?
• Why use an entity relationship model?
• Input and components of an entity relationship ,model, reading the entity relationship model, guidelines for a model review

3. Fundamentals of Relational Database Management Systems

• What is an RDBMS?
• History of SQL, physical data storage, relationships between tables, domains - data integrity constraint

4. SQL Basics and SQL*Plus

• Understanding the difference between SQL, SQL*Plus, and PL/SQL, invoking and leaving SQL*Plus, entering and executing commands, the SQL buffer, SQL*Plus Default Output, LOGIN.SQL, the SELECT command and mandatory clauses

5. Using iSQLPlus

• Understanding the iSQL*Plus environment and commands

6. The WHERE and ORDER BY Clause

• WHERE, ORDER BY clause, using the data dictionary, hierarchical 1ueries

7. Single Row Functions

• Single row versus group functions, date and numeric format models, data conversion, control statements, regular expressions

8. Joining Data from Multiple Tables in Queries

• The JOIN condition / the Cartesian product, outer JOINs, SET operators, ANSI SQL99 joins

9. Group Functions and the GROUP BY Clause

• Group functions, distinct operator in group functions, GROUP BY, WITH clause, ROLLUP, CUBE, GROUPING SETS

10. Using Subqueries and CASE Clauses

• Single-row, multi-row, multi-column subqueries, subqueries in a WHERE clause, Subqueries in the FROM Clause - in-line views, subqueries in the SELECT clause - scalar subqueries, correlated subqueries, CASE clause

11. Analytic Functions (Optional)

• Single Row Analytic Functions, Aggregating Analytic Function

12. SQL*Plus Reporting

• SQL*Plus Report Writing Commands, COLUMN Command / Titles, System Variables, Master-Detail Report with TITLE and COLUMN Commands, Control Breaks, Computing Aggregate Amounts, Using SET Variables in SQL*Plus, SQL to Generate SQL

13. Data Manipulation Language (DML) Commands

• INSERT, UPDATE, DELETE, MERGE command, use of subqueries, transaction control commands / read consistency / locking, the MERGE command, Flashback queries

14. Data Definition Language (DDL) Commands

• DDL commands, object naming, dropping objects, TRUNCATE, COMMENT, RENAME command, creating tables / integrity constraints, CREATE TABLE, ALTER TABLE command, datatypes, types of declarative constraints, default values, creating, Deferrable, dropping, disabling / enabling constraints / displaying constraint information, handling exceptions, views, synonyms, sequences, indexes, temporary tables, external tables

15. Security

• Users, privileges, roles, changing passwords

16. Getting Data In And Out Of Oracle

• SQL*Loader basics, importing Oracle data into Excel, direct database queries using ODBC

Space is limited. Register today to save your space!