SQL in easy steps: for web developers, programmers & students

by Mike McGrath

SQL is THE standard language used world-wide for database communication on all popular database software. It allows the storage and manipulation of data both on Windows platforms and on Unix-based platforms, such as Linux.
SQL in easy steps, 3rd edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases. It is aimed at those with little or no experience of SQL. From web developers wanting to add database interaction to their web sites, programmers wanting to quickly add SQL to their skills set, hobbyists who want to begin creating SQL scripts for upload to their own ISP, to students or to those seeking a career in computing, this book will appeal to all who need a fundamental understanding of database administration with SQL.
SQL in easy steps, 3rd edition begins by explaining how to download and install the free MySQL database server on both Windows and Linux platforms. This allows you to establish an environment in which to develop and administer your own databases. This book makes no assumption that you will have previous knowledge of any programming or scripting language so it's ideal for the newcomer to SQL. Each chapter builds your knowledge of executing database queries. The book contains exciting chapters on how to selectively extract data from within one, or more, databases and there are complete examples that illustrate each aspect of SQL. By the end of this book you will have gained a sound understanding of the Structured Query Language and be able to write your own SQL scripts to insert, extract and manipulate data.
Updated and revised with the latest techniques since the second edition, which was published in 2005. All examples given in this 3rd edition demonstrate SQL features using the current MySQL Relational Database Management System that is supported on both Windows and Linux operating systems.

Genres: Nonfiction, Programming

284 pages, Kindle Edition

First published October 28, 2003

About the author

Librarian Note: There is more than one author in the GoodReads database with this name. See this thread for more information.

Reviews

[Dave Weber · Rating 2 out of 5]

Hardly covers the basics of SQL

[Andrea · Rating 4 out of 5]

It was a good introduction, but there were a lot of query-breaking typos in the examples, which was frustrating.

[Nicholas · Rating 4 out of 5]

Well laid out, informative, and easy for a beginner. This introductory guide to the SQL language is perfect for people with no major experience coding. One of the nice things about it is the fact that it has the code example, and then shows what would be on screen. Making it super easy to follow along if you so choose.

Overall, really a good intro to the language. Only thing that could have been better is the explanation of code itself and its functionality. Still well worth any beginner’s time.

[minhhai · Rating 4 out of 5]

Good introductory course in MySQL statements.

Pros: Step-by-step instruction with source codes and results. Clear illustrations (maybe too much effort was invested into design). Very easy to follow.

Cons: Too many detailed instructions sometimes which make the book longer than needed. Quite superficial, mostly deal with 1 or 2 tables, so very few "relational" techniques are mentioned.

[Deep Frey · Rating 4 out of 5]

This book was the first I have ever read regarding relational databases or computers. Being new to the field, I found this book pretty systematic and easy to follow. I appreciated the MySQL download instructions and summaries for each section. I am not moving on to some more hands on training tools.

[David · Rating 4 out of 5]

Uses MySQL for its examples which is free to download and use. Unfortunately this is a little different to the commercial versions but the book highlights these pitfalls. Straightforward and easy to use reference book.

[Aaron · Rating 3 out of 5]

Very basic overview. I found it helpful in the context of using with other study materials.