Pro Oracle SQL 2nd Edition by Karen Morton – Ebook PDF Instant Download/Delivery: 9781430262206, 1430262206
Full download Pro Oracle SQL 2nd Edition after payment
Product details:
ISBN 10: 1430262206
ISBN 13: 9781430262206
Author: Karen Morton
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 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—features 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
Table of contents:
1 Core SQL
2 SQL Execution
3 Access and Join Methods
4 SQL is About Sets
5 It’s About the Question
6 SQL Execution Plans
7 Advanced Grouping
8 Analytic Functions
9 The Model Clause
10 Subquery Factoring
11 Semi-joins and Anti-joins
12 Indexes
13 Beyond the SELECT
14 Transaction Processing
15 Testing and Quality Assurance
16 Plan Stability
People also search for:
pros and cons of oracle
is oracle sql plus free
difference between pl sql and oracle
difference between oracle and sql developer
sqlpro for oracle
Tags:
Karen Morton,Pro Oracle SQL