SQL Fundamentals (3rd Edition)

3.36 avg rating
( 11 ratings by Goodreads )
 
9780137126026: SQL Fundamentals (3rd Edition)
View all copies of this ISBN edition:
 
 

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.

"synopsis" may belong to another edition of this title.

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

About the Author:

John J. Patrick is a computer consultant and software developer specializing in relational database technology. He teaches SQL Fundamentals and other database courses at the University of California, Berkeley Extension, and has more than twenty years of experience in software development at Bank of America, Chevron, Kaiser Permanente, and other leading firms.

"About this title" may belong to another edition of this title.

Buy New View Book
List Price: US$ 69.99
US$ 15.66

Convert currency

Shipping: US$ 29.94
From Germany to U.S.A.

Destination, rates & speeds

Add to Basket

Other Popular Editions of the Same Title

9780130669476: SQL Fundamentals (2nd Edition)

Featured Edition

ISBN 10:  0130669474 ISBN 13:  9780130669476
Publisher: Prentice Hall PTR, 2002
Softcover

9780130960160: SQL Fundamentals

Prenti..., 1999
Softcover

Top Search Results from the AbeBooks Marketplace

1.

John J. Patrick
Published by Prentice Hall (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Softcover Quantity Available: 1
Seller:
unifachbuch
(Köln, NRW, Germany)
Rating
[?]

Book Description Prentice Hall, 2008. Softcover. Condition: Neu. Unbenutzte Restauflage Unbenutzt. Schnelle Lieferung, Kartonverpackung. Abzugsfähige Rechnung. Bei Mehrfachbestellung werden die Versandkosten anteilig erstattet. - 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. 803 pp. Englisch. Seller Inventory # INF1000028176

More information about this seller | Contact this seller

Buy New
US$ 15.66
Convert currency

Add to Basket

Shipping: US$ 29.94
From Germany to U.S.A.
Destination, rates & speeds

2.

Patrick, John J.
Published by Prentice Hall
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Quantity Available: > 20
Seller:
INDOO
(Avenel, NJ, U.S.A.)
Rating
[?]

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

More information about this seller | Contact this seller

Buy New
US$ 43.55
Convert currency

Add to Basket

Shipping: US$ 3.60
Within U.S.A.
Destination, rates & speeds

3.

Patrick, John J.
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Quantity Available: 1
Seller:
Paperbackshop-US
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description 2008. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Seller Inventory # KS-9780137126026

More information about this seller | Contact this seller

Buy New
US$ 45.43
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

John J. Patrick
Published by Pearson Education (US), United States (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Paperback Quantity Available: 1
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2008. Paperback. Condition: New. 3rd edition. 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. Seller Inventory # AAS9780137126026

More information about this seller | Contact this seller

Buy New
US$ 52.88
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

John J. Patrick
Published by Pearson Education (US), United States (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Paperback Quantity Available: 1
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2008. Paperback. Condition: New. 3rd edition. 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. Seller Inventory # AAS9780137126026

More information about this seller | Contact this seller

Buy New
US$ 54.78
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

6.

John J. Patrick
Published by Prentice Hall (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Paperback Quantity Available: 1
Seller:
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2008. Paperback. Condition: New. 3. Seller Inventory # DADAX0137126026

More information about this seller | Contact this seller

Buy New
US$ 56.90
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

7.

John J. Patrick
Published by Prentice Hall (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2008. Condition: New. book. Seller Inventory # M0137126026

More information about this seller | Contact this seller

Buy New
US$ 61.20
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

8.

Patrick, John J.
Published by Prentice Hall (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Paperback Quantity Available: 2
Seller:
Murray Media
(North Miami Beach, FL, U.S.A.)
Rating
[?]

Book Description Prentice Hall, 2008. Paperback. Condition: New. Never used!. Seller Inventory # P110137126026

More information about this seller | Contact this seller

Buy New
US$ 61.37
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

9.

John J. Patrick
Published by Pearson Education (US)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Paperback Quantity Available: 1
Seller:
THE SAINT BOOKSTORE
(Southport, United Kingdom)
Rating
[?]

Book Description Pearson Education (US). Paperback. Condition: New. New copy - Usually dispatched within 2 working days. Seller Inventory # B9780137126026

More information about this seller | Contact this seller

Buy New
US$ 53.43
Convert currency

Add to Basket

Shipping: US$ 9.12
From United Kingdom to U.S.A.
Destination, rates & speeds

10.

John J. Patrick
Published by Pearson Education (US), United States (2008)
ISBN 10: 0137126026 ISBN 13: 9780137126026
New Paperback Quantity Available: 10
Seller:
Book Depository hard to find
(London, United Kingdom)
Rating
[?]

Book Description Pearson Education (US), United States, 2008. Paperback. Condition: New. 3rd edition. Language: English . This book usually ship within 10-15 business days and we will endeavor to dispatch orders quicker than this where possible. 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. Seller Inventory # BTE9780137126026

More information about this seller | Contact this seller

Buy New
US$ 66.34
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

There are more copies of this book

View all search results for this book