Oracle SQL: Jumpstart with Examples

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $36.53
Usually ships in 1-2 business days
(Save 58%)
Other sellers (Paperback)
  • All (7) from $36.53   
  • New (5) from $36.53   
  • Used (2) from $499.99   

Overview

"As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single source as this book.

One comes across very few books that make a significant difference in your fundamental understanding of the subject. This is one such book if you want to understand a core database skill – SQL. This book deserves a place in your library and you will find it a great reference not only for learning SQL but also for learning data relationships, data organization, data analysis possibilities and so forth. I feel that the title, Oracle SQL: Jumpstart with Examples, might be too simplistic to describe the content. Read on, you will find the real value hidden inside this book." -- Ravi Sharma, Senior Principal Consultant

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.

Features:
* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database
* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them as developers and database administrators

Gavin Powell, BSc. Comp.Sci., OCP (Oracle Certified Professional), has fifteen years of diverse experience in database administration and database development in both relational and object databases. His applications development experience is procedural and object-oriented and he also has some systems administration experience. He consults for software vendors, internet .COM’s (some of which unfortunately have met with their demise), accounting, banking, and financial services, the travel industry, construction, retail, mining, shipping, education and in a general advisory capacity.

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL. Each of the hundreds of SQL code examples was tested on a working Oracle 10g database

Read More Show Less

Editorial Reviews

From Barnes & Noble
The Barnes & Noble Review
Every Oracle professional needs a reliable source of information on Oracle SQL. This book is it. More than a comprehensive and well-written reference, it delivers bushels of Oracle 10g example code -- all tested and verified.

Gavin Powell and Carol McCullough-Dieter cover Oracle SQL from soup to nuts: SELECT, WHERE, ORDER BY, operators, conditions, pseudocolumns, SQL*PLUS, functions, joins, grouping, summarization, subqueries, expressions, DML, datatypes, collections, indexes, clusters, constraints, PL/SQL, and much more. You’ll also find detailed coverage of XML datatypes, generation, and retrieval; and managing security via users, privileges, groups, and roles.

Much of what’s in here applies to Oracle 9i as well. If you haven't upgraded yet, you can rely on this book now, and keep relying on it after you move up. Bill Camarda, from the January 2005 Read Only

From the Publisher
"As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single source as this book.

One comes across very few books that make a significant difference in your fundamental understanding of the subject. This is one such book if you want to understand a core database skill – SQL. This book deserves a place in your library and you will find it a great reference not only for learning SQL but also for learning data relationships, data organization, data analysis possibilities and so forth. I feel that the title, Oracle SQL: Jumpstart with Examples, might be too simplistic to describe the content. Read on, you will find the real value hidden inside this book." -- Ravi Sharma, Senior Principal Consultant

Read More Show Less

Product Details

  • ISBN-13: 9781555583231
  • Publisher: Elsevier Science
  • Publication date: 10/7/2004
  • Pages: 688
  • Product dimensions: 1.44 (w) x 7.50 (h) x 9.25 (d)

Meet the Author

Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL

Carol McCullough-Dieter is a veteran database designer and trainer. She has written many books on Oracle including Oracle9i Database Administrator: Implementation and Administration. As an independent consultant for federal and state government projects in Wisconsin and Hawaii, she designed and implemented complex, secure, integrated web-based database systems. She has designed in-house and online training guides for Oracle SQL coding and performance tuning.

Read More Show Less

Table of Contents

1 Introduction to Oracle SQL 1
2 New features of Oracle SQL 39
3 Oracle database architecture 51
4 The SELECT statement 73
5 Filtering rows 97
6 Sorting rows 109
7 Operators, conditions, and pseudocolumns 123
8 Using SQL Plus 137
9 Single-row functions 175
10 Joining tables 205
11 Grouping and summarizing data 235
12 Subqueries 267
13 Unusual query types 285
14 Expressions 301
15 Data manipulation language (DML) 315
16 Datatypes and collections 339
17 XML in Oracle 357
18 Tables 383
19 Views 425
20 Constraints 447
21 Indexes and clusters 471
22 Sequences and synonyms 489
23 Security 503
24 Basic PL/SQL 531
App. A Schema scripting 569
App. B Utility scripts 623
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)