SQL Practitioner’s Guide: Patterns, Guidance & Tips for Oracle & SQL Server

Based on years of real-world experience with Oracle and SQL Server RDBMS, this example-rich book is a great getting started guide with tips that may be useful even to those who have some years of experience in the field. Covers, with an emphasis on ANSI standards, the SELECT statement including joins, unions, aggregate and analytic functions, common table expressions, and hierarchical queries. Also discusses options for modeling inheritance relationally and ways to generate primary key values.