There are plenty of SQL books, but this is the one to buy if you really want to understand how SQL works and how to make it work for you. It emphasizes practical concepts and examples from the two leading SQL implementations: Access on the desktop, and Oracle for the enterprise. Start with the basics: creating simple queries to retrieve information from a single table. Next, move on to more complex queries involving many tables. Key topics include outer joins, process verification and program testing. Each topic is discussed in detail, with practical examples that show how to write queries others can understand and modify; verify the correctness of your queries and account for all the data returned. By the end of the book, you'll be able to design your own databases. Whether you plan to use SQL for ad hoc reports, database design or data warehousing, this book gives you the strong foundation you need to succeed. For anyone who wants to learn SQL on the leading desktop platform, Access; or the leading enterprise platform, Oracle.
"synopsis" may belong to another edition of this title.
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 WallFrom the Back Cover:
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 for IT pros at the University of California, Berkeley, 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. SQL Fundamentals covers all this and more:
* Simple queries that retrieve information from a single table
* Creating tables and views to divide a complex process into a series of single steps
* Summarizing your data
* Inner joins, outer joins, unions, self joins, cross joins, and subqueries
* Writing SQL queries that are easily understood, verified, modified, and extended
Want better access to business data? Want to make your data more accessible to others? SQL Fundamentals delivers the practical techniques and examples you need - on the database platforms you already use! If you want to fully use the information in your database, then read this book!
The accompanying CD-ROM contains a library of Access databases and the code for building Oracle databases. All the tables used in the book are furnished in both Oracle and Access format. A website provides additional technical support to assure that all the code is completely correct and works with the latest versions of both Oracle and Access.
"About this title" may belong to another edition of this title.
Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97801309601601.0
Book Description Prentice Hall, 1999. Paperback. Book Condition: New. Bookseller Inventory # DADAX0130960160
Book Description Prentice Hall, Upper Saddle River, NJ, 1999. Softcover. Book Condition: New. Brand New, Has Sealed CD Quantity Available: 1. ISBN: 0130960160. ISBN/EAN: 9780130960160. Pictures of this item not already displayed here available upon request. Inventory No: 1560734116. Bookseller Inventory # 1560734116
Book Description Prentice Hall, 1999. Paperback. Book Condition: New. book. Bookseller Inventory # 0130960160
Book Description Prentice-Hall. Book Condition: New. pp. 544. Bookseller Inventory # 7573723