SQL

SQL : Practical Guide for Developers

3 (3 ratings by Goodreads)
By (author)  , By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?

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.
show more

Product details

  • Paperback | 272 pages
  • 192 x 230 x 20mm | 598.75g
  • Morgan Kaufmann Publishers In
  • San Francisco, United States
  • English
  • 0122205316
  • 9780122205316
  • 1,390,288

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
show more

Review Text

"This book is not just another SQL text. The author's use of simple yet clear examples to illustrate difficult concepts throughout the text makes this a perfect book for use in an introductory database systems class as a supplement or as an introductory reference for the novice practitioner.
- Paul Fortier, University of Massachusetts, Dartmouth

"The book lives up to its title: it is a very practical guide. The authors clearly know their SQL and manage to write about the language in a step-by-step style that progresses smoothly from the simple to the more difficult aspects of the language. The profuse use of examples, each with an accompanying motivation and explanation of the results, lets the reader follow even complex topics without a constant struggle. The authors have even included examples that illustrate common errors programmers make, explaining the right way to perform the task. It doesn't hurt that the sample application is based on something everybody uses every day: food.
- Jim Melton, Oracle Corporation

"This book's authors recognize the vast majority of work done with a database is data retrieval (rather than storage) and have focused on this area.
- Australian Personal Computer, March 2006 "This book is not just another SQL text. The author's use of simple yet clear examples to illustrate difficult concepts throughout the text makes this a perfect book for use in an introductory database systems class as a supplement or as an introductory reference for the novice practitioner.
- Paul Fortier, University of Massachusetts, Dartmouth

"The book lives up to its title: it is a very practical guide. The authors clearly know their SQL and manage to write about the language in a step-by-step style that progresses smoothly from the simple to the more difficult aspects of the language. The profuse use of examples, each with an accompanying motivation and explanation of the results, lets the reader follow even complex topics without a constant struggle. The authors have even included examples that illustrate common errors programmers make, explaining the right way to perform the task. It doesn't hurt that the sample application is based on something everybody uses every day: food.
- Jim Melton, Oracle Corporation

"This book's authors recognize the vast majority of work done with a database is data retrieval (rather than storage) and have focused on this area.
- Australian Personal Computer, March 2006
show more

Review quote

"This book is not just another SQL text. The author's use of simple yet clear examples to illustrate difficult concepts throughout the text makes this a perfect book for use in an introductory database systems class as a supplement or as an introductory reference for the novice practitioner."
- Paul Fortier, University of Massachusetts, Dartmouth

"The book lives up to its title: it is a very practical guide. The authors clearly know their SQL and manage to write about the language in a step-by-step style that progresses smoothly from the simple to the more difficult aspects of the language."
- Jim Melton, Oracle Corporation

"This book's authors recognize the vast majority of work done with a database is data retrieval (rather than storage) and have focused on this area."
- Australian Personal Computer, March 2006
show more

About Gregory Speegle

Michael J. Donahoo teaches networking to undergraduate and graduate students at Baylor University, where he is an assistant professor. He received his Ph.D. in computer science from the Georgia Institute of Technology. His research interests are in large-scale information dissemination and management. Gregory D. Speegle is an associate professor at Baylor University where he has taught graduate and undergraduate database courses for 10 years. He received a B.S. degree from Baylor in 1984, and a Ph.D. from the University of Texas in 1990. He has been the graduate director since 1994. Dr. Speegle believes students should be comfortable using databases as part of routine programming. His area of research interest is multimedia databases.
show more

Rating details

3 ratings
3 out of 5 stars
5 0% (0)
4 0% (0)
3 100% (3)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X