SQL in easy steps, 4th edition

Written by In Easy Steps Team on . Posted in

In Easy Steps » Browse our Bookstore » Programming » SQL in easy steps, 4th edition

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

 

 

 

 

Special launch price £8.99 (RRP £11.99)

Pages: 192
Publication: June 23rd, 2020

ebook (PDF) version also available

 

View or download first chapter and Table of Contents - FREE

 

About the book

SQL (Structured Query Language) 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, 4th 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.

Free, downloadable source code is available from our website so you can check the code against your own work, and get started straight away!

SQL in easy steps, 4th edition has an easy-to-follow style that will appeal to anyone who wants to begin using databases. It is suitable for those with little or no experience of SQL. This book will appeal to all who need a fundamental understanding of database administration with SQL:

  • Web developers wanting to add database interaction to their web sites
  • Programmers wanting to add SQL to their skills set
  • Hobbyists who want to begin creating SQL scripts for upload to their own ISP
  • Students or those seeking a career in computing.

 

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
  14. Handy Reference

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

 

ISBN:  978-1-84078-902-7

 

Buy from Amazon.co.uk

Buy from Amazon.com

Buy direct from us:

Quantity
Product in stock

Old Price: £11.99

Price: £8.99

You save: £3.00

Loading Updating cart...
LoadingUpdating...