SQL in easy steps, 3rd edition


Buy direct from us:

In Stock

SKU: 9781840785432

Gives you a sound understanding of the Structured Query Language so you can write your own SQL scripts to insert, extract and manipulate data.


Pages: 192
Publication: May 3, 2012

View Table of Contents and sample chapter

PDF version also available



About the book

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.


Table of Contents

1)  Introducing SQL

2)  Getting Started

3)  Creating database tables

4)  Inserting data into tables

5)  Retrieving data from tables

6)  Sorting retrieved data

7)  Simple data filtering

8)  Complex data filtering

9)  Generating calculated fields

10) Manipulating data

11) Grouping table data

12) Making complex queries

13) Joining database tables


About the author

Mike McGrath now lives in South-east Europe, on the sun-kissed shores of the Aegean Sea. Mike gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world. His interests include coins of ancient Greece, dining-out with friends, and the ongoing evolution of the world wide web.



The procedure for installing MySQL in Windows has changed, so we have updated pages 12-13 – click here to download the PDF of the revised pages

ISBN:  978-1-84078-543-2


Customer comments by Frank Wade, Accountant and Software Developer:

“I bought my first In Easy Steps book (SQL in easy steps) today and it is the best technical book that I have ever read. It is so easy to read and understand the concepts and coding. The table of contents and the colour coding used throughout the book makes it easier to understand the contents.   I bought the SQL book to help me to import product data from clients’ Point of Sales (POS) systems into PriceMaker Pro (my price management software application).  I am very happy with my purchase and I will now purchase the C++ Programming in easy steps book.”

“We have adopted SQL in easy steps for our courses on SQL Programming and Administration and Web Design and Technology.” – University of Bradford


Buy from Amazon.co.uk

Buy from Amazon

Freely download the original source code for checking against your own work from our Downloads page

  • Correction to pages 152-153 (183 KB)
  • Please note: The installation procedure for MySQL is version-specific. The procedure described in SQL in easy steps is correct for the 5.5 version in the book. The latest release of MySQL is version 8.0. Here is a PDF describing the installation procedure for version 8.0 – this is taken from “PHP & MySQL in easy steps” that was published June 2018. For further installation assistance the reader should refer to the documentation – see https://dev.mysql.com/doc/refman/8.0/en/installing.html


You may also like…