Beginning SQL Queries: From Novice to Professional

✍ Scribed by Clare Churcher (auth.)

• Publisher: Apress
• Year: 2008
• Tongue: English
• Leaves: 226
• Edition: 1
• Category: Library

✦ Synopsis

Clare Churcher's Beginning SQL Queries is your guide to mastering the lingua franca of the database industry: the SQL language. Good knowledge of SQL is crucial to anyone working with databases, because it is with SQL that you retrieve data, manipulate data, and generate business results. Knowing how to write good queries is the foundation for all work done in SQL, and it is a foundation that Clare lays well in her book.

• Does not bore with syntax!
• Helps you learn the underlying concepts involved in querying a database, and from there the syntax is easy
• Provides exceptionally clear examples and explanations
• Is academically sound while being practical and approachable

✦ Table of Contents

Front Matter....Pages i-xx
Relational Database Overview....Pages 1-15
Simple Queries on One Table....Pages 17-40
A First Look at Joins....Pages 41-59
Nested Queries....Pages 61-75
Self Joins....Pages 77-93
More Than One Relationship Between Tables....Pages 95-105
Set Operations....Pages 107-132
Aggregate Operations....Pages 133-151
Efficiency Considerations....Pages 153-167
How to Approach a Query....Pages 169-189
Common Problems....Pages 191-208
Back Matter....Pages 209-218

✦ Subjects

Data Structures, Cryptology and Information Theory