this print for content only—size & color not accurate spine = 0.5655" 240 page count
Books for professionals By professionals
®
Beginning SQL Queries:
From Novice to Professional
Dear Reader,
Beginning SQL Queries shows you how to write database queries using the
SQL language. SQL is used for many forms of data manipulation, but key to all
forms—whether you are reporting, deleting, or updating—is the ability to target
the “right” data. It is frustrating when you know some information is in your
database but you just can’t work out how to retrieve it. It is frustrating to write a
query, only to find out too late that it returns the wrong data.
Learning about the different keywords and functions in SQL is not difficult,
but deciding which ones will help you in any particular situation can be tricky.
Writing queries with confidence is at the heart of successfully using SQL, and
this book aims to give you that confidence.
In this book, I show you different ways to approach problems so that you
will be able to find your way through the maze of SQL possibilities to create
accurate queries. I’ll explain many ways that tables can be combined, filtered,
and summarized, and the SQL statements that support these operations. Along
the way, I’ll show you alternative ways to think about each query, so that you
can overcome those inevitable moments when your mind just goes blank.
Having taught SQL for more years than I care to admit, I am still surprised by
some of the queries my students devise, which accurately address a particular
problem. My experience reinforces just how many different ways there are to
develop a query. An initial attempt that might seem obvious to me may be quite
obscure to you and vice versa.
I hope that after reading this book, you will have the confidence to tackle all
manner of queries, knowing that you’re generating accurate information from
your database.
Clare Churcher
Author of
Beginning Database Design:
From Novice to Professional
US $34.99
Shelve in
Databases/SQL
User level:
Beginner–Intermediate
Churcher
Beginning
SQL Queries
The eXperT’s Voice
®
in DaTaBases
Beginning
SQL Queries
From Novice to Professional
cyan
MaGenTa
yelloW
Black
panTone 123 c
Clare Churcher
Companion
eBook
Available
THE APRESS ROADMAP
Beginning
Database Design
Date on Database:
Writings 2000-2006
Applied Mathematics for
Database Professionals
Beginning
SQL Queries
www.apress.com
SOURCE CODE ONLINE
Companion eBook
See last page for details
on $10 eBook version
ISBN-13: 978-1-59059-943-3
ISBN-10: 1-59059-943-8
9 781590 599433
5 3 4 9 9
A thoughtful approach to learning SQL that helps you
think about the language—and about your data—so that
you can apply the right operations to the right problem to
generate the right results, every time.