9780137126026

SQL Fundamentals (3rd Edition)

Patrick, John J.

ISBN 10: 0137126026 / 0-13-712602-6
ISBN 13: 9780137126026
Publisher: Prentice Hall
Publication Date: 2008
Binding: Softcover
Editorial Reviews for this title:
Synopsis:

SQL for the Real World

 

Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before.

 

SQL Fundamentals,Third Edition, teaches you how to

  • Build simple statements to retrieve, store, or modify data
  • Craft complex queries that draw information from multiple tables
  • Sort and summarize your data just the way you want it
  • Create and edit your own tables
  • Protect the integrity of your data
  • Create more efficient, high-performance queries
  • Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins
  • Use the Oracle Data Dictionary

About the Web Site

 

The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.


Review:
SQL Fundamentals deserves praise because it documents the implementation of Structured Query Language (SQL) in Oracle databases and Access databases simultaneously. Readers find out how to do simple single-table queries, more complicated multitable queries, table creation, joins, unions, and calculations in both environments in a variety of circumstances. For those who've never worked with SQL before and plan to use one of the two covered platforms, this book will make a fine starting point, since it explains elementary SQL concepts too.

Here's the approach: Author John J. Patrick sets out a task--for example, writing a statement that yields a left outer join of two databases. Then he proceeds to accomplish the task in both Access and Oracle, presenting the platforms' respective SQL statements side by side. The differences between the two implementations of SQL are obvious, making it easy for someone familiar with one of the two environments to adapt to the other. The reader will also find the numbered and highlighted key passages, which include details on the facing page, very helpful.

Patrick, who based this book on a university course he teaches, knows the value of practical experience--he's loaded SQL Fundamentals with exercises in addition to the tasks he completes himself. He leaves most of these to the reader but provides solutions to some of the more interesting ones. Databases for the illustrations and exercises are included on the companion CD-ROM. --David Wall

Review

Review:

Don't just learn "generic" SQL! Learn SQL to get results with the world's top database platforms: Oracle for the enterprise and Microsoft Access for the desktop! Based on John Patrick's hands-on SQL course for IT pros at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application - from ad hoc reports to the data warehouse. SQL Fundamentals covers all this and more:


* Simple queries that retrieve information from a single table
* Creating tables and views to divide a complex process into a series of single steps
* Summarizing your data
* Inner joins, outer joins, unions, self joins, cross joins, and subqueries
* Writing SQL queries that are easily understood, verified, modified, and extended

Want better access to business data? Want to make your data more accessible to others? SQL Fundamentals delivers the practical techniques and examples you need - on the database platforms you already use! If you want to fully use the information in your database, then read this book!

CD-ROM INCLUDED

The accompanying CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables used in the book are furnished in both Oracle and Access format. A website provides additional technical support to assure that all the code is completely correct and works with the latest versions of both Oracle and Access.

From the Back Cover

Editorial reviews may belong to another edition of this title.
 

SQL Fundamentals (3rd Edition): Search Results

1.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: Paperbackshop-US (Secaucus, NJ, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: > 20

Book Description: PRENTICE HALL COMPUTER, 2008. Paperback. Book Condition: New. New Book. Shipped from UK within 10 to 14 business days. Established seller since 2000. Bookseller Inventory # PJ-9780137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 37.77
Convert Currency
Shipping: US$ 3.99
Within U.S.A.
2.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: GreatBookPrices (Westminster, MD, U.S.A.)
Bookseller Rating: 4-star rating
Quantity Available: 5

Book Description: Book Condition: New. Bookseller Inventory # 5509640-n

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 39.17
Convert Currency
Shipping: US$ 2.64
Within U.S.A.
3.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: INDOO (Avenel, NJ, U.S.A.)
Bookseller Rating: 4-star rating
Quantity Available: > 20

Book Description: Prentice Hall. Book Condition: New. Brand New. Bookseller Inventory # 0137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 43.55
Convert Currency
Shipping: US$ 3.50
Within U.S.A.
4.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: Textbook Barn (Agoura Hills, CA, U.S.A.)
Bookseller Rating: 2-star rating
Quantity Available: > 20

Book Description: Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 Premium Publisher Direct Books are Like New or Brand New books direct from the publisher sometimes at a discount. Multiple copies are usually available. These books are not available for expedited shipping and may take up to 14 business days to receive. Bookseller Inventory # Z0137126026ZN

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 47.65
Convert Currency
Shipping: US$ 4.99
Within U.S.A.
5.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: The Book Depository US (Gloucester, ., United Kingdom)
Bookseller Rating: 5-star rating
Quantity Available: 1

Book Description: Pearson Education (US), United States, 2008. Paperback. Book Condition: New. 3rd Revised edition. 231 x 175 mm. Language: English Brand New Book. SQL for the Real World Don t just learn generic SQL. Learn SQL to get results with the world s top database platforms-Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application-from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend-even if you ve never worked with databases before. SQL Fundamentals,Third Edition, teaches you how to * Build simple statements to retrieve, store, or modify data * Craft complex queries that draw information from multiple tables * Sort and summarize your data just the way you want it * Create and edit your own tables * Protect the integrity of your data * Create more efficient, high-performance queries * Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins * Use the Oracle Data Dictionary About the Web Site The accompanying Web site, , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book s problems and an open area for discussions with the author and other readers. Bookseller Inventory # AAC9780137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 58.62
Convert Currency
Shipping: FREE From United Kingdom to U.S.A.
6.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: The Book Depository (Gloucester, UK, United Kingdom)
Bookseller Rating: 5-star rating
Quantity Available: 1

Book Description: Pearson Education (US), United States, 2008. Paperback. Book Condition: New. 3rd Revised edition. 231 x 175 mm. Language: English Brand New Book. SQL for the Real World Don t just learn generic SQL. Learn SQL to get results with the world s top database platforms-Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application-from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend-even if you ve never worked with databases before. SQL Fundamentals,Third Edition, teaches you how to * Build simple statements to retrieve, store, or modify data * Craft complex queries that draw information from multiple tables * Sort and summarize your data just the way you want it * Create and edit your own tables * Protect the integrity of your data * Create more efficient, high-performance queries * Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins * Use the Oracle Data Dictionary About the Web Site The accompanying Web site, , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book s problems and an open area for discussions with the author and other readers. Bookseller Inventory # AAC9780137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 59.84
Convert Currency
Shipping: FREE From United Kingdom to U.S.A.
7.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: BarristerBooks (Lawrence, KS, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: 3

Book Description: Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 BRAND NEW W/FAST SHIPPING! This item is: SQL Fundamentals, 3rd Ed., 2009, by Patrick, John J.; FORMAT: Paperback; ISBN: 9780137126026. Choose Expedited for fastest shipping! Our 98%+ rating proves our commitment! We cannot ship to PO Boxes/APO address. To avoid ordering the wrong item, please check your item's ISBN number!. Bookseller Inventory # P9780137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 61.79
Convert Currency
Shipping: FREE Within U.S.A.
8.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: ExtremelyReliable (Richmond, TX, U.S.A.)
Bookseller Rating: 5-star rating
Quantity Available: 1

Book Description: Prentice Hall. Paperback. Book Condition: New. Bookseller Inventory # DADAX0137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 58.30
Convert Currency
Shipping: US$ 3.99
Within U.S.A.
9.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: Russell Books (Victoria, BC, Canada)
Bookseller Rating: 5-star rating
Quantity Available: 3

Book Description: Prentice Hall. PAPERBACK. Book Condition: New. 0137126026 Special order direct from the distributor. Bookseller Inventory # ING9780137126026

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 69.99
Convert Currency
Shipping: US$ 7.00
From Canada to U.S.A.
10.

Patrick, John J.
ISBN 10: 0137126026
ISBN 13: 9780137126026
Bookseller: Castle Rock (Amherst, NS, Canada)
Bookseller Rating: 5-star rating
Quantity Available: 1

Book Description: Book Condition: Brand New. Book Condition: Brand New * All orders are processed and shipped from Las Vegas, NV USA *. Bookseller Inventory # 97801371260261.0

Bookseller & Payment Information | More Books from this Seller | Ask Bookseller a Question

Add Book to Shopping Basket
Price: US$ 76.36
Convert Currency
Shipping: US$ 3.99
From Canada to U.S.A.
View All Listings for this Book