Introduction Oracle 9i: SQL

PT3687
Summary
This course is designed to provide developers, DBAs and other technical personnel the skills required to begin work in an Oracle environment. It provides a comprehensive introduction to Oracle's implementation of the SQL language, Oracle functions, SQL*Plus (the developer environment), creating simple objects (tables, temporary tables, constraints, indexes, views, sequences, etc.) and much more. An optional lesson on relational database concepts is included for persons new to relational databases.
Prerequisites
Relational database experience is helpful but not required. Previous experience with Oracle or SQL is not required
Duration
3 Day/Lecture & Lab
Audience
This course is designed for developers, DBAs, and software QA personnel.
Topics
  • Describe the principal features of the Oracle database
  • Query and manipulate an Oracle database using Structured Query Language
  • Code sophisticated query operations such as join, grouping, case and more
  • Update data with insert, multi-table insert, update, delete, and merge operations
  • Utilize SQL*Plus to query, update and create database objects
  • Use SQL*Plus scripting and report generation features
  • Create database tables with all the major datatypes such as NUMBER, VARCHAR2 and LOBs
  • Create B-Tree indexes to improve the performance of query operations
  • Query Oracle data dictionary tables such as USER_TABLES
  • Utilize transaction control statements such as Commit, Rollback and Savepoint
  • Create database objects such as tables, temporary tables, nested tables, views, indexes, synonyms and sequences
  • Grant and Revoke object privileges
  • Introduction to Oracle 9i
  • Introduction to SQL Plus
  • Data Access Basics
  • Row Functions and Pseudo Columns
  • Advanced Data Access
  • SQL Plus Reporting
  • Data Manipulation and Transaction Control
  • Tables and Constraints
  • Indexes
  • Grouping Data and Aggregate Functions
  • Views and Synonyms
  • Other Database Objects

Related Scheduled Courses