SQL Fundamentals

SQL Fundamentals

by JohnJ.Patrick (Author)

Synopsis

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.

$3.26

Save:$41.98 (93%)

Quantity

1 in stock

More Information

Format: Paperback
Pages: 544
Edition: 1
Publisher: Prentice Hall
Published: 11 May 1999

ISBN 10: 0130960160
ISBN 13: 9780130960160
Book Overview:

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.


Author Bio

John Patrickis 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 over 20 years experience in software development at Bank of America, Chevron, Kaiser Permanente and other leading firms.