SQL Fundamentals (Paperback)
  • SQL Fundamentals (Paperback)

SQL Fundamentals (Paperback)

Paperback 832 Pages / Published: 18/09/2008
  • Not available

This product is currently unavailable.

  • This item has been added to your basket

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.

Publisher: Pearson Education (US)
ISBN: 9780137126026
Number of pages: 832
Weight: 1200 g
Dimensions: 234 x 178 x 30 mm
Edition: 3rd edition

You may also be interested in...

Microsoft Access 2010 Step by Step
Added to basket
T-SQL Querying
Added to basket
Querying Microsoft (R) SQL Server (R) 2012
Added to basket
PostGIS in Action
Added to basket
Business Database Systems
Added to basket
Access 2013 All-in-One For Dummies
Added to basket
Data Visualization For Dummies
Added to basket
Big Data For Dummies
Added to basket
PHP and MySQL Web Development
Added to basket

Please sign in to write a review

Your review has been submitted successfully.