Book Description
This first-to-market tutorial covers everything beginners need to succeed with MariaDB, the open, community-based branch of MySQL. Master trainer Ben Forta introduces all the essentials through a series of quick, easy-to-follow, hands-on lessons. Instead of belaboring database theory and relational design, Forta focuses on teaching solutions for the majority of SQL users who simply want to interact with data. Forta covers all this, and more:
Using the MariaDB toolset * Retrieving and sorting data
Filtering data using comparisons, wildcards, and full text searching
Analyzing data with aggregate functions
Performing insert, update, and delete operations
Joining relational tables using inner, outer, and self joins
Combining queries using unions * Using views
Creating and modifying tables, and accessing table schemas
Working with stored procedures, cursors, and other advanced database features
Managing databases, users, and security privileges
This book was reviewed and is supported by MariaDB's developers, Monty Program AB. It contains a foreword by project founder Monty Widenius, primary developer of the original version of MySQL.
Table of Contents
- Title Page
- Copyright Page
- Table of Contents
- Foreword
- Acknowledgments
- About the Author
- Introduction
- 1. Understanding SQL
- 2. Introducing MariaDB
- 3. Working with MariaDB
- 4. Retrieving Data
- 5. Sorting Retrieved Data
- 6. Filtering Data
- 7. Advanced Data Filtering
- 8. Using Wildcard Filtering
- 9. Searching Using Regular Expressions
- 10. Creating Calculated Fields
- 11. Using Data Manipulation Functions
- 12. Summarizing Data
- 13. Grouping Data
- 14. Working with Subqueries
- 15. Joining Tables
- 16. Creating Advanced Joins
- 17. Combining Queries
- 18. Full-Text Searching
- 19. Inserting Data
- 20. Updating and Deleting Data
- 21. Creating and Manipulating Tables
- 22. Using Views
- 23. Working with Stored Procedures
- 24. Using Cursors
- 25. Using Triggers
- 26. Managing Transaction Processing
- 27. Globalization and Localization
- 28. Managing Security
- 29. Database Maintenance
- 30. Improving Performance
- Appendix A. Getting Started with MariaDB
- Appendix B. The Example Tables
- Appendix C. MariaDB Datatypes
- Appendix D. MariaDB Reserved Words
- Index