SQL: Practical Guide for Developers

Description

Would the basics of SQL querying be useful to you, but you don't want to start at the very beginning? Do you wish you had an easy way to ramp up quickly to get a basic understanding of key features and capability? Then you need this book! Without a ton of conceptual information or general programming basics you already know, this book is a quick guide for computing professionals and programmers to learn the basics--and more--in an easily digestible way.

+ Provides tutorial-based instruction for the main features of SQL for programmers and other technical professionals in need of a brief but really good introduction to SQL.
+ The approach is vendor-neutral-so very adaptable and flexible-but the book's Web site includes information about DBMS-specific peculiarities.
+ The focus is on teaching concepts by walking through concrete examples and explanations, and self-review exercises are included at the end of each chapter.
+ Coverage is on the key features of the language that are required to understand SQL and begin using it effectively.
+ SQL 2003-compliant.

CONTENTS:

Chapter 1: Databasics . Chapter 2: Single Table Retrieval . Chapter 3: Taming Tables . Chapter 4: Aggregating Results . Chapter 5: Multiple Table Queries using Simple Subqueries . Chapter 6: Multiple Table Queries Using Joins . Chapter 7: Set Based Queries . Chapter 8: Advanced Subqueries . Chapter 9: Creating a Database . Chapter 10: Database Data . Chapter 11: Transaction Management . Chapter 12: Authorization . Chapter 13: Advanced Topics . Chapter 14: SQL Programming