SQL Fundamentals

Patrick, John

ISBN 10: 0137126026 / ISBN 13: 9780137126026

Published by Pearson, 2008

About this Item

This item is in overall good condition. Covers and dust jackets are intact but may have minor wear including slight curls or bends to corners as well as cosmetic blemishes including stickers. Pages are intact but may have minor highlighting/ writing. Binding is intact; however, spine may have slight wear overall. Digital codes may not be included and have not been tested to be redeemable and/or active. Minor shelf wear overall. Please note that all items are donated goods and are in used condition. Orders shipped Monday through Friday! Your purchase helps put people to work and learn life skills to reach their full potential. Orders shipped Monday through Friday. Your purchase helps put people to work and learn life skills to reach their full potential. Thank you!

Seller Inventory # 466SUS003AMA

Bibliographic Details

• Title: SQL Fundamentals
• Publisher: Pearson
• Publication Date: 2008
• Language: English
• ISBN 10: 0137126026
• ISBN 13: 9780137126026
• Binding: Soft cover
• Edition: 3rd Edition
• Condition: Good

About 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.

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.