Skip to main content
main-content

Über dieses Buch

Pro Oracle SQL, Second Edition 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 multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets.

Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You’ll learn analytic functions, the MODEL clause, and advanced grouping syntax—features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, 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 Baselines and Profiles to optimize and stabilize SQL execution plans, 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.

Pro Oracle SQL, Second Edition helps you work at a truly professional level in the 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.

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. Performance focused—teaches you how to measure the performance of your SQL statements and not just the syntax.

Inhaltsverzeichnis

Frontmatter

2013 | OriginalPaper | Buchkapitel

Chapter 1. Core SQL

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

2013 | OriginalPaper | Buchkapitel

Chapter 2. SQL Execution

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

2013 | OriginalPaper | Buchkapitel

Chapter 3. Access and Join Methods

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

2013 | OriginalPaper | Buchkapitel

Chapter 4. SQL Is about Sets

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

2013 | OriginalPaper | Buchkapitel

Chapter 5. It’s about the Question

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

2013 | OriginalPaper | Buchkapitel

Chapter 6. SQL Execution Plans

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

2013 | OriginalPaper | Buchkapitel

Chapter 7. Advanced Grouping

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

2013 | OriginalPaper | Buchkapitel

Chapter 8. Analytic Functions

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

2013 | OriginalPaper | Buchkapitel

Chapter 9. The MODEL Clause

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

2013 | OriginalPaper | Buchkapitel

Chapter 10. Subquery Factoring

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

2013 | OriginalPaper | Buchkapitel

Chapter 11. Semijoins and Antijoins

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

2013 | OriginalPaper | Buchkapitel

Chapter 12. Indexes

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

2013 | OriginalPaper | Buchkapitel

Chapter 13. Beyond the SELECT

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

2013 | OriginalPaper | Buchkapitel

Chapter 14. Transaction Processing

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

2013 | OriginalPaper | Buchkapitel

Chapter 15. Testing and Quality Assurance

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

2013 | OriginalPaper | Buchkapitel

Chapter 16. Plan Stability

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

2013 | OriginalPaper | Buchkapitel

Chapter 17. Plan Control

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

2013 | OriginalPaper | Buchkapitel

Chapter 18. Miscellaneous SQL Constructs

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

Backmatter

Weitere Informationen

Premium Partner

Neuer Inhalt

BranchenIndex Online

Die B2B-Firmensuche für Industrie und Wirtschaft: Kostenfrei in Firmenprofilen nach Lieferanten, Herstellern, Dienstleistern und Händlern recherchieren.

Whitepaper

- ANZEIGE -

Product Lifecycle Management im Konzernumfeld – Herausforderungen, Lösungsansätze und Handlungsempfehlungen

Für produzierende Unternehmen hat sich Product Lifecycle Management in den letzten Jahrzehnten in wachsendem Maße zu einem strategisch wichtigen Ansatz entwickelt. Forciert durch steigende Effektivitäts- und Effizienzanforderungen stellen viele Unternehmen ihre Product Lifecycle Management-Prozesse und -Informationssysteme auf den Prüfstand. Der vorliegende Beitrag beschreibt entlang eines etablierten Analyseframeworks Herausforderungen und Lösungsansätze im Product Lifecycle Management im Konzernumfeld.
Jetzt gratis downloaden!

Bildnachweise