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.
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.
Free, downloadable source code is available from our website so you can check the code against your own work, and get started straight away!
Reihe
Auflage
Sprache
Verlagsort
Zielgruppe
Für Beruf und Forschung
Für höhere Schule und Studium
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Illustrationen
Full colour screenshots, photographs and diagrams
Maße
Höhe: 227 mm
Breite: 188 mm
Dicke: 12 mm
Gewicht
ISBN-13
978-1-84078-902-7 (9781840789027)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
Mike McGrath gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world, and is an established In Easy Steps author.
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
Handy Reference