Books & Videos

Table of Contents

  1. The Software

    1. Chapter 1 Introduction

      1. The Value of MySQL and MariaDB
      2. Mailing Lists and Forums
      3. Other Books and Other Publications
    2. Chapter 2 Installing MySQL and MariaDB

      1. The Installation Packages
      2. Licensing
      3. Finding the Software
      4. Choosing a Distribution
      5. The _AMP Alternatives
      6. Post-Installation
    3. Chapter 3 The Basics and the mysql Client

      1. The mysql Client
      2. Connecting to the Server
      3. Starting to Explore Databases
      4. Summary
      5. Exercises
  2. Database Structures

    1. Chapter 4 Creating Databases and Tables

      1. Creating a Database
      2. Creating Tables
      3. Inserting Data
      4. More Perspectives on Tables
      5. Summary
      6. Exercises
    2. Chapter 5 Altering Tables

      1. Prudence When Altering Tables
      2. Essential Changes
      3. Optional Changes
      4. Indexes
      5. Summary
      6. Exercises
  3. Basics of Handling Data

    1. Chapter 6 Inserting Data

      1. The Syntax
      2. Practical Examples
      3. Other Possibilities
      4. Summary
      5. Exercises
    2. Chapter 7 Selecting Data

      1. Basic Selection
      2. Selecting by a Criteria
      3. Ordering Results
      4. Limiting Results
      5. Combining Tables
      6. Expressions and the Like
      7. Counting and Grouping Results
      8. Summary
      9. Exercises
    3. Chapter 8 Updating and Deleting Data

      1. Updating Data
      2. Deleting Data
      3. Summary
      4. Exercises
    4. Chapter 9 Joining and Subquerying Data

      1. Unifying Results
      2. Joining Tables
      3. Subqueries
      4. Summary
      5. Exercises
  4. Built-In Functions

    1. Chapter 10 String Functions

      1. Formatting Strings
      2. Extracting Text
      3. Searching Strings and Using Lengths
      4. Converting String Types
      5. Compressing Strings
      6. Summary
      7. Exercises
    2. Chapter 11 Date and Time Functions

      1. Date and Time Data Types
      2. Current Date and Time
      3. Extracting Date and Time Components
      4. Formatting Dates and Time
      5. Adjusting to Standards and Time Zones
      6. Adding and Subtracting Dates and Time
      7. Comparing Dates and Times
      8. Summary
      9. Exercises
    3. Chapter 12 Aggregate and Numeric Functions

      1. Aggregate Functions
      2. Numeric Functions
      3. Summary
      4. Exercises
  5. Administration and Beyond

    1. Chapter 13 User Accounts and Privileges

      1. User Account Basics
      2. Restricting the Access of User Accounts
      3. Administrative User Accounts
      4. Revoking Privileges
      5. Deleting a User Account
      6. Changing Passwords and Names
      7. User Roles
      8. Summary
      9. Exercises
    2. Chapter 14 Backing Up and Restoring Databases

      1. Making Backups
      2. Restoring Backups
      3. Developing a Backup Policy
      4. Summary
      5. Exercises
    3. Chapter 15 Bulk Importing Data

      1. Preparing to Import
      2. Loading Data Basics
      3. Better Loading
      4. More Field and Line Definitions
      5. Importing from Outside MySQL
      6. Bulk Exporting Data
      7. Summary
      8. Exercises
    4. Chapter 16 Application Programming Interfaces

      1. Creating API User Accounts
      2. C API
      3. Perl DBI
      4. PHP API
      5. Python
      6. Ruby API
      7. SQL Injection
      8. Summary
      9. Exercises
  1. Colophon