FREE Delivery in the UK.
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Quantity:1
Beginning SQL (Programmer... has been added to your Basket
+ £2.80 UK delivery
Used: Good | Details
Sold by fatbrainbooks
Condition: Used: Good
Comment: May contain minimal notes added by highlighter and/or pen and may be slightly damaged. Dispatch Same Working Day, (Delivery 2-4 business days, Courier For Heavy/Expensive Items) Money Back Guarantee, 99.3% Customer Satisfaction, Prompt Customer Service
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Beginning SQL (Programmer to Programmer) Paperback – 4 Mar 2005

4.0 out of 5 stars 2 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
Paperback
"Please retry"
£24.99
£13.21 £0.01
Note: This item is eligible for click and collect. Details
Pick up your parcel at a time and place that suits you.
  • Choose from over 13,000 locations across the UK
  • Prime members get unlimited deliveries at no additional cost
How to order to an Amazon Pickup Location?
  1. Find your preferred location and add it to your address book
  2. Dispatch to this address when you check out
Learn more
£24.99 FREE Delivery in the UK. Only 1 left in stock (more on the way). Dispatched from and sold by Amazon. Gift-wrap available.
click to open popover

Special Offers and Product Promotions

Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.




Product details

  • Paperback: 520 pages
  • Publisher: Wrox; 1 edition (4 Mar. 2005)
  • Language: English
  • ISBN-10: 0764577328
  • ISBN-13: 978-0764577321
  • Product Dimensions: 18.8 x 2.9 x 23.5 cm
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,514,471 in Books (See Top 100 in Books)
  • See Complete Table of Contents

Product Description

From the Back Cover

SQL works with databases to insert and extract data and is an international standard for manipulating data in databases. This hands–on resource covers everything from a review of SQL basics and database design to creating your own databases and using the SQL language in a variety of database applications.

Packed with essential code, theories, concepts, and techniques, as well as a cache of useful examples, this comprehensive text will have you quickly designing your own databases and writing SQL code sufficient for many real–world situations. Practice exercises in each chapter help speed up your comprehension. By the end of the book, you′ll be prepared to handle any surprise that SQL might throw your way.

What you will learn from this book

  • How to get the answers you want from a database
  • Procedures for using and manipulating data with SQL′s built–in functions
  • Ways to retrieve data from numerous and diverse tables
  • How to create various levels of security in a database so you can edit data or change the database′s structure
  • Theories and practical applications of normalization
  • Advanced database design

Who this book is for

This book is for programmers with some prior programming experience who are seeking to develop their database programming skills using SQL. The book assumes no previous programming experience, so it is also suitable for database programming beginners including database administrators.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

About the Author

Paul Wilton has been working professionally as a programmer for over 6 years. He is experienced with SQL, database design, development and deployment, as well as RDBMS systems including SQL Server and Access. He is currently working freelance developing functionality for websites database driven web sites including e–commerce, message boards, chat applications, and more. His most recent work includes a case tracking system for a law firm and an online booking system for a holiday cottage rental company.

John Colby is database consultant providing database analysis and design as well as Access, SQL Server, and Visual Foxpro programming to companies in the United States, Mexico, and Europe.

Customer Reviews

4.0 out of 5 stars
5 star
1
4 star
0
3 star
1
2 star
0
1 star
0
See both customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback
This is Wrox's book for those keen to learn SQL who have no experience of database programming at all. The good news is that it's not bad. Unfortunately it is two books rather crudely glued together.
The first book by Paul Wilton is what you would expect from a book with this title, a step-by-step introduction to SQL. It covers queries, functions, inner and outer joins, table and index creation, constraints and the fundamentals of relational database design. As the database-independent title of the book suggests it focuses on the standard features and functions of SQL that are common to all popular databases. In doing this the author makes the effort to point out where the popular databases vary from the standard. Understandably stored procedures are deemed to be beyond the scope of this book and are not mentioned. The databases covered by the first book are Oracle 10g, MySQL 4.1, SQL Server 2000, DB2 8.1 and Access XP. The book also includes a very handy appendix which explains how to obtain a free evaluation copy of each of these databases and how to install them on Windows.
The second book, by John Colby, covers the more advanced topics of transactions, security and database performance tuning. Unfortunately the second book is written unashamedly only for SQL Server and little or no attempt is made to explain how the same functionality is delivered by other databases. I can't understand this. Wrox has a perfect good book already for those keen to learn about SQL Server by Robert Vieira.
Read more ›
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
As with every Wrox book I've read, this title
lets you get the knowledge you require in a
very user friendly way.
The balance of book is perfect for anyone starting
out in the field of SQL.
Whilst SQL is not the most difficult language to learn,
the book gradually introduces to you the concepts of SQL
and before you know it, you will be creating databases
with ease.
I love Wrox titles, and this is no exception.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta)

Amazon.com: HASH(0x99bdaabc) out of 5 stars 11 reviews
24 of 26 people found the following review helpful
HASH(0x99a8851c) out of 5 stars Does a beginner need to know about performance tuning? 31 Jan. 2006
By Graeme Harker - Published on Amazon.com
Format: Paperback
This is Wrox's book for those keen to learn SQL who have no experience of database programming at all. The good news is that it's not bad. Unfortunately it is two books rather crudely glued together.

The first book by Paul Wilton is what you would expect from a book with this title, a step-by-step introduction to SQL. It covers queries, functions, inner and outer joins, table and index creation, constraints and the fundamentals of relational database design. As the database-independent title of the book suggests it focuses on the standard features and functions of SQL that are common to all popular databases. In doing this the author makes the effort to point out where the popular databases vary from the standard. Understandably stored procedures are deemed to be beyond the scope of this book and are not mentioned. The databases covered by the first book are Oracle 10g, MySQL 4.1, SQL Server 2000, DB2 8.1 and Access XP. The book also includes a very handy appendix which explains how to obtain a free evaluation copy of each of these databases and how to install them on Windows.

The second book, by John Colby, covers the more advanced topics of transactions, security and database performance tuning. Unfortunately the second book is written unashamedly only for SQL Server and little or no attempt is made to explain how the same functionality is delivered by other databases. I can't understand this. Wrox has a perfect good book already for those keen to learn about SQL Server by Robert Vieira.

In my view for the next release of the book Wrox should drop the second section of this book altogether, as it doesn't belong in a beginners' guide to SQL and instead ask Paul to beef up the chapters on functions and data types, including an overview of the more often used datatypes in the five RDBMSs. In my experience beginners need to know how to use IDENTITY and SEQUENCE generators when they build their first database applications, not security and database performance tuning.
23 of 25 people found the following review helpful
HASH(0x99a88570) out of 5 stars As the Title Says, Good Beginning Book 4 Mar. 2005
By John Matlock - Published on Amazon.com
Format: Paperback
This is a good general introduction to using SQL to build a database, put some data into it and then to get it back out when you need to use it for something. The author says that all of the SQL examples have been tested using MySQL, Microsoft SQL Server, IBM DB2, Microsoft Access, and Oracle 10g. That says that the SQL used in the examples has to be very general in nature and not take advantage of newer and more powerful commands that have come about since these programs were written (particularly Access which uses the Jet engine that's more or less compliant with SQL:89).

This is not a bad approach, because while you might miss out on some of the nifty commands, your code will be compatiable with virtually any database that you are using. You will find comments in the book like when discussing the substring function he says "MS Access doesn't utilize the SUBSTRING() function. Instead, it employs the MID() function...." I don't know how he could have done it any differently without writing five different books.

This is an excellent beginning book. Use it to get started and to understand the concepts behind the SQL language. Then you may want to get a higher level book on the particular database you are using.
4 of 4 people found the following review helpful
HASH(0x9a15fc3c) out of 5 stars Great beginner guide to SQL 27 Nov. 2007
By Richard R. Webster - Published on Amazon.com
Format: Paperback
I really like this book.

It is broken into two sections. Chapter 1-3 is a once-over-lightly overview of all the key concepts involved in SQL. The rest is a thorough and detailed guide to more advanced uses.

The SQL is generic, though the book has specific exceptions for MySQL, Access, SQL Server and Oracle. These are mostly unobtrusive and can be skimmed easily. It is moderately useful to see what exceptions exist and why, even if you have no intention of using those DBMS's. Unlike books like SQL in a Nutshell, these references don't create constant interruptions in the reading flow.

What I like most about this book is that each subject is given a complete discussion, with ERD, SQL commands, and example data. In most cases, there is more than one example of usage. Unlike the current book, the examples are uncomplicated and make sense out of context of previous chapters, for the most part. The database examples are more self-contained and real-world than the current book -- more like the classroom examples.

This book devotes from 3-10 pages to what most books only give 1/2 page. The text flows well and is light and friendly, but doesn't have distracting anecdotes. At first glance, it is a lot of text, a lot of pages, and the paper is newsprint which seems intimidating, but it is a quick read. The data examples are humorous, which makes it a bit less dull. Even though the Wrox tagline is "Programmer to Programmer" this book is more accessible than any other programming text I've read. It really is Beginning SQL.

My only complaint: no coverage of PostgreSQL.

Two thumbs up, 5 stars, etc... I really like this book!
1 of 1 people found the following review helpful
HASH(0x99a887f8) out of 5 stars A good book on the SQL language 26 April 2012
By Ryan Tramel - Published on Amazon.com
Format: Paperback Verified Purchase
This is a book on the language not any particular SQL database software. There are a great number of people who have trouble finding a good book on the language itself.
This would be the first one I'd recommend.
1 of 1 people found the following review helpful
HASH(0x99a88798) out of 5 stars Excellent SQL Book for starters 16 Dec. 2009
By Kurt Polcyn - Published on Amazon.com
Format: Paperback
Easy to understand and follow up with many examples. It is great for beginner and advanced SQL user. I use this for my community college in Beginning SQL course.
Were these reviews helpful? Let us know


Feedback