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
Product information
- Title: MariaDB Crash Course
- Author(s):
- Release date: September 2011
- Publisher(s): Addison-Wesley Professional
- ISBN: 9780132842341
You might also like
book
MariaDB and MySQL Common Table Expressions and Window Functions Revealed
Walk away from old-fashioned and cumbersome query approaches and answer your business intelligence questions through simple …
book
Migrating to MariaDB: Toward an Open Source Database Solution
Mitigate the risks involved in migrating away from a proprietary database platform toward MariaDB’s open source …
book
Getting Started with MariaDB - Second Edition
Explore the powerful features of MariaDB with practical examples Install, configure, and manage MariaDB Store and …
book
Unix: Visual QuickStart Guide
UNIX is the most commonly-used operating system in the world. Once considered too arcane and difficult …