SQL Fundamentals by John J. Patrick
Look inside with Google Book Preview
SQL Fundamentals
By John J. Patrick

SQL Fundamentals

3rd Revised edition

By (author) See other recent books by John J. Patrick
Format: Paperback

Normal Price: $139.61
Your Price: $125.65 AUD, inc. GST
Shipping: $7.95 per order
You Save: $13.96! (10% off normal price)
Plus...earn $6.28 in Boomerang Bucks
Availability: Available Available, ships in 8-11 days



SQL Fundamentals by John J. Patrick

Book Description

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.

Buy SQL Fundamentals book by John J. Patrick from Australia's Online Bookstore, Boomerang Books.


Book Details

ISBN: 9780137126026
ISBN-10: 0137126026
Format: Paperback
(234mm x 178mm x 30mm)
Pages: 832
Imprint: Prentice Hall
Publisher: Pearson Education (US)
Publish Date: 2-Sep-2008
Country of Publication: United States

Books By Author John J. Patrick

Understanding Democracy by John J. Patrick Understanding Democracy, Paperback (May 2006)

This handy pocket guide explains the core concepts of democracy in a clear A-Z format. Though these core concepts may be practiced differently in various countries, every genuine democracy is based on them in one way or another.

Bill of Rights by John J. Patrick Bill of Rights, Hardback (January 2003)

The Bill of Rights is an extraordinary collection of original documents, carefully introduced and put into context by historian John Patrick, that traces the origins of the Bill of Rights back to England's Magna Carta and its legal traditions through to present day controversies over freedoms of speech, religion, bearing arms, assembling, and more.

(Oxford) Guide to the United States Government by John J. Patrick (Oxford) Guide to the United States Government, Hardback (March 2001)

Published in the form of an A to Z guide, this comprehensive overview of the U.S. Presidency, Congress and the Supreme Court is aimed at general readers and as an aid to students of political science and related disciplines.

» View all books by John J. Patrick

Reviews

» Have you read this book? We'd like to know what you think about it - write a review about SQL Fundamentals book by John J. Patrick and you'll earn 50c in Boomerang Bucks loyalty dollars (you must be a member - it's free to sign up!)

Write a book review


Author Biography - John J. Patrick

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.

Boomerang Bucks close

For every $20 you spend on books, you will receive $1 in Boomerang Bucks loyalty dollars. You can use your Boomerang Bucks as a credit towards a future purchase from Boomerang Books. Note that you must be a Member (free to sign up) and that conditions do apply.

Recent books by John J. Patrick close
Pursuit of Justice by John J. Patrick
Pursuit of Justice by John J. Patrick
Understanding Democracy by John J. Patrick
Bill of Rights by John J. Patrick
(Oxford) Guide to the United States Government by John J. Patrick
»
BoomerangBooks.com.au close