Sams Teach Yourself MariaDB® in 10 Minutes By Chris Newman ............................................... Publisher: Sams Pub Date: May 09, 2006 Print CNPJ-10: 0-672-32863-1 Print CNPJ-13: 978-0-672-32863-3 Pages: 288 Table of Contents | Index Copyright About the Author Introduction Part 1: MariaDB Foundations Lesson 1. Introducing MariaDB Database Basics MariaDB Components Summary Lesson 2. Using MariaDB The MariaDB Client Executing SQL Statements Creating the Sample Tables Summary Part 2: Getting Started with SQL Lesson 3. Retrieving Data The SELECT Statement Summary Lesson 4. Filtering and Sorting Data The WHERE Clause The ORDER BY Clause Summary Lesson 5. Advanced Data Filtering Combining WHERE Clauses Limiting the Number of Rows Returned Summary Lesson 6. Numeric Operators and Functions Numeric Operators Numeric Functions Conditional Functions Summary Lesson 7. String Operators and Functions Using Operators with Strings String Functions Summary Lesson 8. Date Operators and Functions Date Operators Date Functions Summary Lesson 9. Summarizing Data Aggregate Functions Grouping Data Filtering Summary Data Summary Part 3: Advance SQL Lesson 10. Using Subqueries Understanding Subqueries Summary Lesson 11. Joining Tables Understanding Joins Summary Lesson 12. Creating Advanced Joins The JOIN Keyword Inner Joins Joining Multiple Tables Cross Joins Self-Joins Natural Joins Outer Joins Summary Lesson 13. Combining Queries Understanding Combined Queries Other Compound Operations Using Temporary Tables Summary Part 4: Creating a New Database Lesson 14. Creating and Modifying Tables Creating a New Database Character Sets and Collations Altering a Database Dropping a Database Managing Tables Temporary Tables Using a Query to Create a Table Storage Engines Altering Tables Dropping Tables Summary Lesson 15. Working with Data The INSERT Statement The DELETE Statement The UPDATE Statement The REPLACE Statement Loading Data from a File Why Use Transactions? Transactions in MariaDB Autocommit Mode Rolling Back a Transaction Summary Lesson 16. Designing Your Database Relationships Normalization Naming Tables and Columns Data Types CHAR and VARCHAR Summary Lesson 17. Keys and Indexes Understanding Keys and Indexes Using Indexes in MariaDB Summary Lesson 18. Managing User Access Understanding MariaDB Authentication User Management Using Wildcards Summary Part 5: New Features in MariaDB 5.0 Lesson 19. Views Understanding Views Summary Lesson 20. Stored Routines Understanding Stored Routines Summary Lesson 21. Triggers Understanding Triggers Using Triggers Summary Part 6: Interfacing with MariaDB Lesson 22. Using ODBC Understanding ODBC Connecting to MyODBC Summary Lesson 23. Using MariaDB with C The C Language API Summary Lesson 24. Using MariaDB with PHP Using the MariaDB API Using the mysqli API Summary Lesson 25. Using MariaDB with Perl The Perl DBI Using the MariaDB DBD Summary Part 7: Appendix Appendix A. Installing MariaDB Obtaining MariaDB Linux/UNIX Installation Windows Installation Appendix B. Sample Table Scripts Index
