back to Course Categories | back | print
Oracle10g: Introduction to SQL          

Duration: 5 days

Description 
This class will teach attendees beginning and advanced SQL programming skills and techniques using the Oracle10g Database Server. Topics will include the Oracle architecture, products and development environments to provide a comprehensive perspective of SQL development in Oracle. The course will cover advanced querying and reporting, data warehousing and how to develop SQL in different database environments. This class teaches SQL through numerous hands on labs and projects. Anyone who believes SQL is for dummies has never taken this class. This class will develop expertise with SQL and Oracle10g features.

Topics

  • Oracle overview of database, Apps Server and developer tools
  • Relational and object-relational designs
  • Review relational database design
  • Data models
  • Using SQL*Plus, iSQL*Plus
  • SQL*Plus commands
  • Changing your password
  • Differences between SQL*Plus and iSQL*Plus
  • SQL*Plus Worksheet
  • SELECT statements
  • Components of SQL statements
  • Creating SQL scripts
  • Filtering records
  • Comparison conditions
  • LIKE operator
  • Working with NULL
  • Logical conditions (AND, OR, NOT)
  • Sorting data with ORDER BY
  • Building SQL statements
  • Techniques with SELECT statements
  • Working with DUAL
  • Using the data dictionary
  • The GROUP BY clause
  • Aggregate functions
  • HAVING clause
  • Different ways to group data
  • What to watch out for with GROUP BY
  • INSERT, UPDATE and DELETE statements
  • Understanding read consistency
  • Transactions
  • The UNION, INTERSECT, and MINUS operators
  • Techniques for SET operators
  • SAMPLE clause, GROUPING function, CUBE and ROLLUP operators
  • Introduction to Analytical functions
  • The WITH clause
  • Advanced subqueries
  • Regular expressions
  • Dealing with case sensitivity with SQL
  • Techniques for writing joins
  • Complex data retrieval using equi-joins, Cartesian-joins, self-joins, outer-joins
  • Hierarchical and tree-structured queries
  • Regular and correlated subqueries
  • Single and multiple row subqueries
  • Group functions in subqueries
  • Guidelines for subqueries
  • Oracle native and ANSI 99 SQL
  • Character functions
  • Date functions
  • Numeric functions
  • Conversion functions
  • Miscellaneous functions
  • SQL*Plus application and report writing using parameters, substitution variables, calculations, groups, breaks, summaries, headers and footers, Web reports
  • Working with schema objects
  • Sequences
  • Synonyms
  • Database links
  • Creating, altering and deleting tables
  • Renaming tables
  • Managing tables
  • Working with constraints
  • Primary and foreign keys
  • Unique keys
  • NOT NULL constraints
  • Check constraints
  • DEFAULT values
  • Creating and accessing external tables
  • Different types of indexes
  • Flashback queries
  • Introduction to materialized views
  • ANSI SQL features
  • Time zones
  • Working with dates and timestamps
  • Multi-table INSERT statement
  • Merge statement
  • Object-relational types
  • Globalization
  • Rule and Cost based optimization concepts
  • The basics of performance tuning skills using Explain Plan and Autotrace.
  • Using SQL to generate SQL

Prerequisites

  • A background in data processing, relational database concepts and programming is strongly recommended.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design