Pro Oracle SQL



Bookstore > Books > Pro Oracle SQL

Price$5.83 - $39.99
Rating
AuthorsKaren Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
PublisherApress
Published2010
Pages600
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101430232285
ISBN-139781430232285
EBook Hardcover Paperback

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.

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.


  1. (2 books)
  2. (3 books)
  3. (2 books)
  4. (3 books)


4 5 27

Similar Books


Pro Oracle SQL Development

Pro Oracle SQL Development

by Jon Heller

Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories,...

Price:  $27.10  |  Publisher:  Apress  |  Release:  2019

Oracle SQL Tuning Pocket Reference

Oracle SQL Tuning Pocket Reference

by Mark Gurry

One of the most important challenges faced by Oracle database administrators and Oracle developers is the need to tune SQL statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the r...

Price:  $6.76  |  Publisher:  O'Reilly Media  |  Release:  2002

Programming Microsoft SQL Server 2012

Programming Microsoft SQL Server 2012

by Leonard Lobel, Andrew Brust

Take your database programming skills to a new level - and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you're an experienced SQL Server develop...

Price:  $21.95  |  Publisher:  Microsoft Press  |  Release:  2012

Professional Microsoft SQL Server 2012 Integration Services

Professional Microsoft SQL Server 2012 Integration Services

by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock

Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this ...

Price:  $32.99  |  Publisher:  Wrox  |  Release:  2012

Oracle SQL Recipes

Oracle SQL Recipes

by Grant Allen, Bob Bryla, Darl Kuhn

Have you ever been faced with a new type of query to write, or been asked to create an unfamiliar database object? In such situations, you have probably wanted a good, solid example upon which to build, and instead have been forced into the drudgery of parsing railroad-style syntax diagrams in Oracle's manual set. This book frees you...

Price:  $39.99  |  Publisher:  Apress  |  Release:  2009

Beginning Oracle SQL, 3rd Edition

Beginning Oracle SQL, 3rd Edition

by Lex deHaan, Tim Gorman, Inger Jorgensen, Melanie Caffrey

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2014

Practical Oracle SQL

Practical Oracle SQL

by Kim Berg Hansen

Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit ...

Price:  $32.87  |  Publisher:  Apress  |  Release:  2020

Professional Oracle 8i Application Programming with Java, PL/SQL and XML

Professional Oracle 8i Application Programming with Java, PL/SQL and XML

by Michael Awai

This book is for professional Oracle database programmers who need a comprehensive roadmap of the new programming possibilities with Oracle 8i. On the other hand, if you are already developing with Java and XML this book will show you how to exploit PL/SQL and the enterprise features of Oracle 8i in optimally distributing your n-tier appl...

Price:  $32.50  |  Publisher:  Wrox  |  Release:  2000