footer-social-menu

Sign Up for Emails

CONNECT WITH GALE

Stay up-to-date with the latest Gale news, exclusive offers, and more.

facebook

linkedin

instagram

youtube

SOCIAL ICONS

%1 products have been added to your cart but %2 have been backordered and will be fulfilled when stock is available

Product on backorder

Current quantity limit is [maxProductQuantity], please, navigate to the cart page and change quantity of product

You will be able to resubmit promo in ${countdown} seconds. test

Please note that the taxes displayed on our website are estimated and subject to adjustment. The actual tax charges will be determined and settled during the final invoicing of your order

product-detail-component

Would you like to go to the Gale {{RECOMMENDED_COUNTRY}} site instead?

It looks like you're visiting from {{DETECTED_COUNTRY}}.

main

products

secondary-account-menu

Marketing materials, training documents, discovery services

cengage:card

FIND YOUR SALES REPRESENTATIVE

cengage:column

Get marketing materials, training documents, discovery services.

PRODUCT SUPPORT

CUSTOMER SUPPORT

Report technical issues, errors, check system status

TECHNICAL SUPPORT

Manage product preferences, generate usage reports, simplify administrative tasks.

ADMIN TOOLS

support

footer-legal-menu

Terms of use

Privacy

cengage:galethorndikeseo

footer

secondary-storefront-menu

config

secondary-primary-menu

About Us

Blogs

Press Center

Events

News

Careers

Our Company

Request a Trial

header-component

Profile

Orders

Wish List

Fast Order Entry

My Account

mega-menu

Browse by Institution Type

Browse by Product Type

Products

Support

Account Information

bundle-connector

gale-footer

zone3

FIND YOUR REP

support-order-2

footer-menu-component

container

footer-legal-menu-component

header

International

North America

China

Japan

Latin America

Brazil

Region

Set your region:

You may already have access to Gale content through your institution.

STUDENTS AND RESEARCHERS

support-order-1

single-column

footer-social-menu-component

zone2

footer-menu

Academic Institutions

K-12

Public Libraries

Government and Special Libraries

Statewide Programs

Institutions

Databases

Primary Sources

Digital Humanities Tools

eLearning

Schools/K-12 Curriculum

Books

Large Print Books by Thorndike Press

Find Your Rep

Product Support

Technical Support

Customer Support

Admin Tools

Accessibility Policy

Partnerships

Contact Us

zone1

Information Technology

Computing & Information Technology

Gt Product Group

Binding Format

Marketing Imprint Name

B2B GT

CL Carton Count

Imprint Name

B2B & B2C

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.

Pro Oracle SQL

POST SECONDARY FOUR YEAR

PROFESSIONAL & REFERENCE

COLFR

COLJR

COLSO

COLSR

PRO ORACLE SQL 2

Duration

Duration Unit Of Measure

Transaction Type

Front Cover.
Other Frontmatter.
Title Page.
Copyright Page.
Contents at a Glance.
Contents.
About the Authors.
About the Technical Reviewer.
Acknowledgments.
1: Core SQL.
2: SQL Execution.
3: Access and Join Methods.
4: SQL Is about Sets.
5: It&#x0027;s about the Question.
6: SQL Execution Plans.
7: Advanced Grouping.
8: Analytic Functions.
9: The MODEL Clause.
10: Subquery Factoring.
11: Semijoins and Antijoins.
12: Indexes.
13: Beyond the SELECT.
14: Transaction Processing.
15: Testing and Quality Assurance.
16: Plan Stability.
17: Plan Control.
18: Miscellaneous SQL Constructs.
Index.

Pro Oracle SQL.css-1p8rvzy{position:absolute;padding-left:8px;}

Pro Oracle SQL