spacer

Home > Oracle Training > Oracle SQL*Plus

Oracle SQL*Plus Introduction

Duration: 3 days Level: Introduction

Who should attend | Prerequisites | Content | Sample Notes | Next Class | Printer Friendly Print this page

Class Summary

This class will develop basic database programming skills using SQL. Students will review the Oracle8i architecture and then move into simple and complex SQL query skills. Students will become proficient in retrieving and formatting data and creating numerous typical database objects.

The class consists of a mixture of lecture and hands on lab exercises.

Who Should Attend

This class is intended for analysts, junior developers, designers, beginning administrators and managers new to Oracle (8i, 9i or 10g) and database programming.

Prerequisites

A grounding in relational database concepts; familiarity with the use of graphical user interfaces.

Content

  • Database concepts : Introduction, relationships, the relational model, integrity rules, relational algebra, relational calculus.

  • Data modelling and normalisation : data modeling, dependency, database design, normal forms, dependency diagrams, denormalisation.

  • Oracle 8/9 Overview: Personal databases v Client/Server databases, SQL*Plus and iSQL*Plus environments, Structured Query Language overview, logging in to SQL*Plus, SQL*Plus commands, using text editors, using online help where available, spooling output.

  • Creating and modifying Oracle tables: naming conventions, data types, constraints, table creation, displaying table information, altering tables, adding new columns, modifying a column, dropping columns, renaming tables, truncating tables.

  • Data Manipulation / Definition Languages : adding new rows, updating rows, deleting rows, working with constraints, retrieving data from tables, column aliases, concatenating columns, arithmetic operations, using the WHERE clause, sorting with the ORDER BY clause.

  • SQL Functions : Built-in functions, single row functions, group functions, grouping data, the GROUP BY clause, the HAVING clause, nesting functions, substitution variables, the DEFINE command.

  • Multiple tables : Multiple table queries, join types, outer joins, set operations, sub-queries, single row sub-queries, multiple row subqueries, using subqueries for table creation, insert, update, delete, top-N analysis.

  • Advanced Features: Views, sequences, synonyms, indexes, transaction control, commit, rollback, savepoint, locking selected rows for updating.

  • User Management: controlling access to resources, privileges for users, roles, system privileges, object privileges.

Sample notes

This class is taught from a standard textbook - no sample notes are available.

Suggested next class

Oracle PL/SQL

 

   

 Search this site...
       
 
Web Hosting by Lunarpages

This page last updated on
October 6, 2010 9:12 AM