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
About the Web Site
The accompanying Web site, http://groups.google.com/group/sqlfun, 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.
This book/CD-ROM package shows how to use SQL to get information from a relational database, focusing on the most widely used SQL products Oracle and Microsoft Access. Readership includes people new to the subject of databases who are not computer programmers, as well as professional programmers looking for solutions to real-world problems. The companion CD-ROM contains all SQL code and tables from the book, Microsoft Access databases, and code for building Oracle databases. Patrick is a computer consultant and software developer specializing in relational database technology. He teaches database courses at the University of California Berkeley Extension. Annotation c. Book News, Inc., Portland, OR (booknews.com)