SQL for MySQL : a beginner's tutorial

This introduction to SQL for MySQL begins by discussing exactly how data is stored and maintained in a relational database, familiarizing readers with SQL INSERT, UPDATE, and DELETE statements. The guide then discusses how to construct basic queries, choose an appropriate output, and how to create and use groups. Readers will also learn how to use joins to query data from multiple tables, how to create predefined views that can be stored in a database, and how to utilize the metadata of a database. Appendices round out the book, covering the various indexing techniques available in MySQL and discussing how to install MySQL Community Edition and list the MySQL built-in data types. Annotation Written by a database expert with 20 years commercial experience, this manual is an approachable and user-friendly introduction to the SQL variant for MySQL. SQL, which stands for Structured Query Language is the standard language you use to interact with a relational database management system (RDBMS). This book uses the free edition of the MySQL database to show how SQL works. It teaches beginners how to select data from the database, insert and update data, and how to create database objects with chapters that detail each topic with jargon-free language Date of publication from resource description page (Safari, viewed Apr. 10, 2014). - "Data definition, data manipulation, indexing, stored routines, data dictionary