Skip to main content

Beginning SQL

Beginning SQL

Paul Wilton, John Colby

ISBN: 978-0-764-57732-1

Mar 2005

520 pages

In Stock

$39.99

Description

  • Taking readers through the basics of the language, right up to some more advanced topics, this book is a practical, hands-on resource and aims to keep the reader involved at all times
  • Focuses on the SQL standard and is loaded with detailed examples and code; each chapter includes practice exercises that readers can challenge themselves with before looking at the sample solutions in the appendix
  • Paul Wilton is a successful Wrox "Beginning" book author and is an ideal author to write for those who want a firm grasp of standard SQL before learning the details specific to a particular database product
  • SQL is an international standard for manipulating data in databases and is used by database programmers in all major database systems: Microsoft, IBM, Oracle, MySQL, and many others
About the Authors.

Acknowledgments.

Introduction.

Chapter 1. Introduction to SQL.

Chapter 2. Entering Information.

Chapter 3. Extracting Information.

Chapter 4. Advanced Database Design.

Chapter 5. Manipulating Data.

Chapter 6. Grouping and Aggregating Data.

Chapter 7. Selecting Data from Different Tables.

Chapter 8. Queries within Queries.

Chapter 9. Advanced Queries.

Chapter 10. Views.

Chapter 11. Transactions.

Chapter 12. SQL Security.

Chapter 13. Database Tuning.

Appendix A: Exercise Answers.

Appendix B: Setting up and Using the Five Database Systems

Appendix C: Initial Data Setup.

Index.

Code Downloads
Code downloads for this title are available here.
Download
ChapterPageDetailsDatePrint Run
2Typo
2nd paragraph under "What This Book Covers", last sentence:
You should that find most

should read:
You should find that most
08/13/08

20Error in Text/Table
Page 20, 2nd row of table, last column:

Text reads:
nchar

Should read:
varchar
09/22/2006

367Typo in Text
In the first insert on the values part is a missing comma "," next to "1975"

and

In the values part where the movie is "A 7 hour drama about Bob’s life. What fun!’"

At the end of that line there is a missing “);”
2/9/10

122Possible Error in Text
Street should not be in the ZipCode table, rather it should be in the MemberDetails table.
05/02/2006