SQL,
Edition 1 Practical Guide for Developers
By Michael J. Donahoo and Gregory D. Speegle

Publication Date: 01 Aug 2005
Description

SQL is a solid guide and reference to the key elements of SQL and how to use it effectively. Developed by authors who needed a good resource for students in their database class, this is an ideal supplement for database courses — no matter what main text you use or what flavor of SQL is required.

It features a short and inexpensive introduction to SQL for students who have some programming experience and need to learn the main features of SQL; and suggested shortcuts for learning and practice, depending on the experience of the user.

This book is recommended for novice developers, programmers, and database administrators as well as students in database courses, business courses, and IT-related courses.

Key Features

  • 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
  • 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.
About the author
By Michael J. Donahoo, Baylor University, Waco, TX, USA and Gregory D. Speegle, Baylor University, Waco, TX
Table of 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
Book details
ISBN: 9780122205316
Page Count: 272
Retail Price : £27.99
TCP/IP Sockets in C, Donahoo, MK ISBN:1558608265 and 1558606866
The Struts Framework, Spielman, MK ISBN:1558608621 10,800 copies sold
SQL for Smarties, Celko, MK, Oct 99, 550 pages. ISBN 1558605762
Audience
Novice developers, programmers, and database administrators. Students in database courses, business courses, and IT-related courses.