SQL In Easy Steps 3rd Edition

SQL in easy steps, 3rd edition is a beginner-friendly guide for anyone starting out with databases and SQL. It is written for readers with little or no prior experience, including web developers, programmers, hobbyists, students and those pursuing a career in computing.

This third edition explains how to download and install the free MySQL database server on both Windows and Linux, helping you set up an environment to develop and administer your own databases. The book assumes no previous knowledge of programming or scripting, and each chapter builds skills in running database queries. Examples throughout demonstrate SQL features using the MySQL Relational Database Management System, with coverage that includes extracting data from one or more databases and writing scripts to insert, extract and manipulate data. It has been updated and revised with the latest techniques since the second edition, published in 2005.

Key details

• Third edition, updated and revised since the 2005 second edition
• Aimed at readers with little or no experience of SQL
• Uses MySQL to demonstrate SQL features
• Includes guidance on installing MySQL on Windows and Linux
• Chapters build knowledge of executing database queries

Synopsis

SQL in easy steps, 3rd edition introduces SQL in an easy-to-follow style and starts by showing how to install MySQL on Windows and Linux. It then develops core skills in creating and administering databases, with chapters that progressively expand your ability to execute queries.

The content includes selectively extracting data from one or more databases and provides complete examples to illustrate each aspect of SQL. By the end, readers will have a fundamental understanding of database administration with SQL and be able to write scripts to insert, extract and manipulate data.

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