Oracle 10g SQL Training

Duration: 5 days

Audience: Application developers, database administrators, and users who access an Oracle10g database.

Prerequisites: None

Course Contents

• Relational database and SQL overview
• Using Oracle SQL*Plus
• The SELECT statement
• Scalar functions
• SQL queries - joins
• Aggregate functions and advanced techniques
• Data manipulation and transactions
• Data definition and control statements
• Other database objects
• Database design concepts
• SQL Subqueries
• Hierarchical queries
• Object types
• Times, dates, and strings
• Temporary tables
• SQL tuning tools
• SQL tuning
• Indexes
• Oracle analytic functions
• Data warehousing features
• Formatting reports with SQL*Plus
• The data dictionary