Alan Beaulieu

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you\'re working with a relational database--whether you\'re writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements. To help you attain this fundamental SQL knowledge, look to "Learning SQL," an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language. "Learning SQL" moves...

Издательство: O'Reilly & Associates
Дата выхода: декабрь 2009

Few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that, showing you how to creatively leverage the full power of SQL to write queries in an Oracle environment. This book shows you how to: Leverage Oracles vast library of built-in SQL functionsQuery time-based data, and write joins involving date and time rangesUse Oracle SQLs hierarchical query features to deal with data best represented in a tree formatUse DECODE and CASE to implement conditional logic in your queriesUse Oracles new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and moreJoin data from two or more tables using the newly supported SQL92 join syntax In...

Издательство: O'Reilly & Associates
Дата выхода: декабрь 2009