SQL in Easy Steps - Couverture souple

McGrath, Mike

Couverture souple

ISBN 10 : 1840785438 ISBN 13 : 9781840785432

Editeur : In Easy Steps Limited, 2012

Synopsis

SQL in Easy Steps SQL in easy steps makes no assumption that you'll have previous knowledge of any programming or scripting language so it's ideal for newcomers to SQL. SQL in easy steps begins by explaining how to download and install the free MySQL database server so that you'll quickly start to develop and administer your own databases. It then shows how to execute database queries and selectively extract data Full description

A propos du livre

Présentation de l'éditeur

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 MySQL Relational Database Management System that is supported on both Windows and Linux operating systems.

Table of Contents

Introducing SQL

Getting Started

Creating database tables

Inserting data into tables

Retrieving data from tables

Sorting retrieved data

Simple data filtering

Complex data filtering

Generating calculated fields

Manipulating data

Grouping table data

Making complex queries

Joining database tables

Biographie de l'auteur

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.

Détails de l'édition

• Éditeur: In Easy Steps Limited
• Date d'édition: 2012
• ISBN 10: 1840785438
• ISBN 13: 9781840785432
• Reliure: Broché
• Langue: anglais
• Nombre de pages: 192