Mastering Oracle SQL
Super Savings Item! Save 32% on the Mastering Oracle SQL by Brand: O'Reilly Media at Translate This Website. Hurry! Limited time offer. Offer valid only while supplies last. If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs
If you write programs to run against an Oracle database, you spend a lot of time and mental energy writing queries to return the data your programs need. Knowledge of SQL, and particularly of Oracle's implementation of SQL, is the key to writing good queries in a timely manner. In this book, the authors share their knowledge of Oracle SQL, and show you many creative techniques that you can use to advantage in your own applications.This book shows you how to:
- Leverage Oracle's vast library of built-in SQL functions
- Query time-based data, and write joins involving date and time ranges
- Use Oracle SQL's hierarchical query features to deal with data best represented in a tree format
- Use DECODE and CASE to implement conditional logic in your queries
- Use Oracle's new, analytic SQL features to write ranking queries, lag and lead queries, windowing queries, and more
- Join data from two or more tables using the newly supported SQL92 join syntax
In addition, you'll see how SQL can best be integrated with PL/SQL. You'll also learn various best practices to help you write SQL queries that perform efficiently.Precious 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.
|Brand:||Brand: O'Reilly Media|
|Item Size:||0.85 x 9.19 x 9.19 inches|
|Package Weight:||0.79 pounds|
|Package Size:||5.85 x 0.73 x 0.73 inches|
Have questions about this item, or would like to inquire about a custom or bulk order?
If you have any questions about this product by Brand: O'Reilly Media, contact us by completing and submitting the form below. If you are looking for a specif part number, please include it with your message.
Related Best Sellers
By Prentice Hall
ean: 9780130123817, isbn: 0130123811,
*Targets the no.1 Oracle performance bottleneck: SQL and PL/SQL *For all releases through Oracle 8i *Detailed case studies and performance measurements *Large-volume queries, Oracle clusters, Java, parallel query tuning, and much more Your one-stop r...
By Brand: Apress
ean: 9781590598993, isbn: 1590598997,
Pro Oracle Spatial for Oracle Database 11g shows you how to take advantage of Oracle Database's built-in feature set for working with location-based data. The book addresses the special nature of spatial data and its role in professional and consumer...
ean: 9781430236627, isbn: 1430236620,
Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time f...
By Brand: Apress
ean: 9781590594483, isbn: 1590594487,
*Ideal for anyone who wants to learn SQL programming for Oracle database. *Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database. *Book can be used as collateral/hand...
By O'Reilly Media
ean: 9780596006808, isbn: 0111111111,
While it's good to have a book with all the answers--like your trusty copy of Oracle PL/SQL Programming-- how often do you need all the answers? More likely, you just need a reminder, a quick answer to a problem you're up against. For these times, no...
By Oracle SQL:A Beginner's Tutorial, Second Edition
ean: 9781771970303, isbn: 1771970308,
This introduction to SQL for the Oracle database begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements. The guide then discusses how to construct ...
By Addison-Wesley Professional
ean: 9780201565454, isbn: 0201565455,
This book provides a practical and comprehensive tutorial on SQL, covering version 6.0 of ORACLE. It examines every aspect of SQL including creating tables, specifying primary and foreign keys, querying data transactions, data security and auditing....
By McGraw-Hill Education
ean: 9780071782791, isbn: 0071782796,
The Essential Guide to SQL Statement Optimization Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately ...
By Packt Publishing
ean: 9781849686747, isbn: 9781849686747,
Build and manage your Oracle Database 11g XE environment with this fast paced, practical guide Install and configure Oracle Database XE on Windows and Linux Develop database applications using Oracle Application Express Back up, restore, and tune yo...
By Brand: Apress
ean: 9781590592182, isbn: 1590592182,
This guide combines the proven tutorial approach to teaching SQL with a collection of major SQL statements with example code for five major database systems: SQL Server, Oracle, DB2, MySQL and Access.Used Book in Good Condition. ...