0
Your cart

Your cart is empty

Books > Computing & IT > Computer software packages > Database software > Oracle

Buy Now

Pro Oracle SQL (Paperback, 1st ed.) Loot Price: R1,072
Discovery Miles 10 720
You Save: R193 (15%)

Pro Oracle SQL (Paperback, 1st ed.)

Karen Morton, Robyn Sands, Jared Still, Riyaj Shamsudeen, Kerry Osborne

 (sign in to rate)
List price R1,265 Loot Price R1,072 Discovery Miles 10 720 | Repayment Terms: R100 pm x 12* You Save R193 (15%)

Bookmark and Share

Expected to ship within 10 - 15 working days

Pro Oracle SQL unlocks the power of SQL in the Oracle Database one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton and her team help you master powerful aspects of Oracle SQL not found in competing databases. You ll learn analytic functions, the MODEL clause, and advanced grouping syntax techniques that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing overhead, read execution plans, test for correct results, and exert control over SQL execution in your database. You ll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. What s the bottom-line?Pro Oracle SQL helps you work at a truly professional level in Oracle dialect of SQL. You ll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Pro Oracle SQL helps you rise above the crowd to provide stellar service in your chosen profession. * Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance * Comprehensive goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. What you'll learn * Master powerful SQL features implemented only in Oracle Database * Read and interpret SQL execution plans * Quickly diagnose and fix badly performing SQL * Control execution plans through hints, profiles, and plan baselines * Optimize queries within packaged applications without touching the code * Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL is aimed at developers and database administrators who submit SQL for execution by an Oracle database.Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle s specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and subquery refactoring that are designed to help developers and DBAs exert control over their SQL environment and its execution.

General

Imprint: Apress
Country of origin: Germany
Release date: December 2010
First published: December 2010
Authors: Karen Morton • Robyn Sands • Jared Still • Riyaj Shamsudeen • Kerry Osborne
Dimensions: 234 x 190 x 30mm (L x W x T)
Format: Paperback
Pages: 575
Edition: 1st ed.
ISBN-13: 978-1-4302-3228-5
Categories: Books > Computing & IT > Computer software packages > Database software > Oracle
Promotions
LSN: 1-4302-3228-5
Barcode: 9781430232285

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!

You might also like..

Oracle 12c - SQL
Joan Casteel Paperback  (1)
R1,406 R1,302 Discovery Miles 13 020
Promethean Oracle
Sophia Shultz, Mark Cogan Miscellaneous printed matter R1,034 R823 Discovery Miles 8 230
Oracle Performance Tuning for 10gR2
Gavin JT Powell Paperback R1,984 Discovery Miles 19 840
Oracle Database Programming using Java…
Kuassi Mensah Paperback R1,772 Discovery Miles 17 720
Oracle 10g RAC Grid, Services and…
Murali Vallath Paperback R1,212 Discovery Miles 12 120
Oracle Database 10g Data Warehouseing
Lilian Hobbs, Susan Hillson, … Paperback R1,939 Discovery Miles 19 390
Pro Oracle Collaboration Suite 10g
John Watson Hardcover R1,635 Discovery Miles 16 350
JDBC Metadata, MySQL, and Oracle Recipes…
Mahmoud Parsian Hardcover R1,659 Discovery Miles 16 590
Oracle SQL By Example
Alice Rischert Paperback  (1)
R1,488 Discovery Miles 14 880
Troubleshooting Oracle Performance
Christian Antognini Hardcover R1,815 Discovery Miles 18 150
Object-oriented Oracle
Hardcover R2,202 Discovery Miles 22 020
Oracle Database Programming with Visual…
Y. Bai Paperback R2,097 Discovery Miles 20 970

See more

Partners