by Djoni Darmawikarta
$16.99, 140 pages
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.
Table of Contents
Introduction Chapter 1: Storing and Maintaining Data Chapter 2: Basic Queries Chapter 3: Full-Text Search Chapter 4: Query Output Chapter 5: Grouping Chapter 6: Joins Chapter 7: Subqueries Chapter 8: Compound Queries Chapter 9: Views Chapter 10: Built-in Functions Chapter 11: Transactions Chapter 12: Stored Routines Chapter 13: The Data Dictionary Appendix A: Installing MySQL Community Edition Appendix B: MySQL Built-in Data Types Appendix C: Indexes Index