My book

Buy from :
rampant-books.com

Table of Contents:

Chapter 1: Oracle SQL Query overview

- Syntax
- Subqueries
- Joins
- Sets

Chapter 2: Oracle SQL Functions

- Standard functions
Compare dates, evaluate conditions in CASE and LNNVL, convert and cast, check for nulls, use regular expressions, mathematical and XML functions
- User-defined functions
Create deterministic, recursive, pipelined and table functions
- Pivot / Unpivot (11g)
Convert rows to columns and columns to rows

Chapter 3: Oracle SQL Aggregation

- Standard functions
Sum, count and calculate averages. Nest aggregates function
- Grouping sets
Create totals, sub-totals, grand-totals
- User-defined aggregates
Create an aggregate function

Chapter 4: Oracle SQL Analytics

- Syntax
- Window
Calculate cumulative totals, moving windows
- Order
Number rows with row_number, rank and dense_rank
- Inter-rows calculation
Access rows with lead, lag, first_value and last_value
- Analytic functions
Percentage and statistics

Chapter 5: Oracle SQL Hierarchies

- Syntax
- Loops
Prevent ORA-01436 with the NOCYCLE keyword. Detect loops with the CONNECT_BY_ISCYCLE function
- First ancestor
Aggregate hierarchical results with CONNECT_BY_ROOT
- Paths
Retrieve the full path with SYS_CONNECT_BY_PATH and use it to solve procedural queries

Chapter 6: Oracle SQL Model Clause

- Syntax
- Inter-rows calculation
Access and update a row, retrieve any values from the result set
- Iterate
Loop and generate new rows

Appendix A – SQL*Plus
Appendix B – Scripts for Windows
Appendix C – Scripts for Unix/Linux