oracle 10g - advanced sql

software training academy
seattle, wa, united states

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced

Course Description:

'' 1. oracle decode and case - conditional logic in sql

introduction to oracle decode

oracle decode and range comparisons

the oracle case expression

oracle case syntax

workshop



2. set operations

union , intersect and minus operators

key union concepts

intersect operation

minus operation

example: compare schemas

example: compare5?s

example: compound set operations

workshop



3. subqueries

oracle subquery overview

restrictions

subquery gotcha

correlated subqueries

the need for not exists

the exists operator

oracle top-n queries - inline views

oracle9i extended subquery support

oracle subquery factoring - the with clause

workshop



4. advanced joins

join terminology review

3,4,5 way inner joins

join and group by

self-joins

cartesian product

outer joins

oracle ansi compliant joins

natural join

oracle using clause

oracle on clause

oracle ansi outer joins

oracle ansi full outer joins

oracle ansi cross join

joining to views

join tuning tips

oracle partition outer join (oracle10g)

workshop



5. coding queries on partitioned data

oracle partition concepts

partition-independent queries

partition pruning

coding partition-dependent queries in oracle

workshop



6. grouping data

oracle aggregate function overview

grouping multiple columns

golden group by rule

the having clause

oracle rollup operations

oracle cube operations

oracle grouping function

oracle grouping with decode

oracle grouping in having

oracle grouping sets

workshop



7. oracle analytic functions

introduction

what do they do?

getting started with oracle analytic functions

oracle partition clause

oracle order-by clause

oracle windowing clause

oracle row windows

oracle range windows

oracle range windows: between

oracle range windows: interval

oracle ranking functions

oracle top-n queries

oracle lag and lead functions

closing thoughts

list of analytic functions

resources

workshop



8. model queries (oracle10g)

oracle10g model clause concepts

oracle10g model clause components and clauses

workshop



9. oracle connect by - hierarchical queries

introduction

oracle connect by example

level with lpad

adding where clause

sort by level

oracle9i siblings sorts

oracle9i hierarchy path

new oracle10g pseudocolumns (oracle10g)

workshop



10. using regular expressions in oracle sql (oracle10g)

searching with oracle10g rege9?like

rege9?like versus like

oracle10g regular expression functions (e.g. rege9?replace)

basic elements of expressions

using backreferences

workshop



11. oracle date and time (temporal) data

scalar function review (new oracle10g functions)

oracle date conversion functions

oracle to_char & to_date examples

oracle date arithmetic & functions

adding & subtracting days in oracle sql

oracle add_months function

oracle last_day function

oracle trunc function

introduction to oracle datetime data

oracle timestamp data type

oracle timestamp with time zone data type

oracle time stamp with local time zone data type

oracle datetime conversions

more oracle time zone functions

workshop



12. oracle xml db and xmltype

xml in the oracle database

xmltype in oracle5?s

inserting xml data

selecting xml data

oracle xml db extract function

oracle xml db extractvalue function

updating oracle xml data

pl/sql and xml

other oracle xml features

xml db workshop



13. additional oracle10g new sql features

case insensitive search and sort in oracle10g

enclosing quotes

oracle merge statement enhancements

ora_rowscn pseudocolumn

oracle10g nested5? enhancements

oracle10g temporary5? enhancements

aggregates in the oracle10g returning clause

new datatypes in oracle10g ...''

Elements of this syllabus are subject to change.

Phone:1-888-896-7852

School Address/Venue(s):

1 yonge st
toronto

Jobs & Resumes: seattle
Houses & Roommates: seattle
Travel Agencies: seattle

Search other schools for oracle 10g - advanced sql training resources.

Advanced PHP Programming

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.