Many of the current MySQL titles are overkill for the many MySQL users who need to use MySQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't.
MySQL Crash Course is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling of database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data.The reader of this book will learn how to:
- Use the MySQL toolset
- Retrieve and sort data
- Filter data using comparisons, wildcards, and full text searching
- Use the aggregate functions to analyze data
- Perform insert, update, and delete operations
- Join relational tables using inner, outer, and self joins
- Combine queries using unions
- Use views
- Create, and modify tables, and access table schemas
- Create and use stored procedures, cursors, and other advanced database features
- Manage databases, users, and security privileges