back to Course Categories | back | print
Oracle10g: Introduction to SQL (3 day workshop)          

Duration: 3 days

Description 
This class will teach attendees fundamental SQL programming skills and techniques using the Oracle10g Database Server. Topics include the SELECT command, DELETE command, INSERT command, DELETE command, managing transactions, SQL*Plus features, This class teaches SQL through numerous hands on labs and projects.

Topics

  • 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
  • Column aliases
  • 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
  • Different types of indexes
  • Flashback queries
  • ANSI SQL features
  • Time zones
  • Working with dates and timestamps
  • Multi-table INSERT statement
  • Using SQL to generate SQL

Prerequisites

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

    • This class is designed for End-Users, Analysts, Application designers, developers and Database administrators.

  •  
     
     

    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