You're reading from Getting Started with MariaDB Explore the powerful features of MariaDB with practical examples

Product type Paperback

Published in Jun 2015

Publisher

ISBN-13 9781785284120

Length 140 pages

Edition 1st Edition

Languages

Java

Tools

MariaDB

Concepts

Database Administration

Author (1):

Daniel Bartholomew

View More author details

Table of Contents (11) Chapters

Preface

What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support

1. Installing MariaDB

Choosing a MariaDB series
Installing MariaDB on Windows
Installing MariaDB on Mac OS X
Installing MariaDB on Debian, Ubuntu, and Linux Mint
Installing MariaDB on Fedora, Red Hat, and CentOS
Installing MariaDB on other Linux distributions
MariaDB package security
After the installation
Troubleshooting installation issues
Summary

2. Configuring MariaDB FREE CHAPTER

The MariaDB filesystem layout
Modular configuration on Linux
The anatomy of the MariaDB configuration file
Activating configuration changes
Summary

3. Securing MariaDB

Security layers
Securing MariaDB in 10 seconds
Connecting safely
Server security
Building security
Internal network security
Internet security
Summary

4. Administering MariaDB

User privileges
Creating users
Granting, revoking, and showing permissions
Setting and changing passwords
Removing users
Summary

5. Using MariaDB – Databases and Tables

The mysql command-line client application
Connecting to MariaDB
Using USE to select a database
Using SHOW to list all databases on a server
Creating and deleting databases
Data, tables, and normalization
Creating, altering, and dropping tables
Summary

6. Using MariaDB – Inserting, Updating, and Deleting

Using INSERT
Using UPDATE
Using DELETE
Summary

7. Using MariaDB – Retrieving Data

Retrieving data
Filtering and searching data
Summarizing data
Summary

8. Maintaining MariaDB

MariaDB log files
Optimizing and tuning MariaDB
Backing up, importing, and restoring data
Repairing MariaDB
Summary

A. MariaDB Next Steps

Index

Chapter 7. Using MariaDB – Retrieving Data

Data is useful only if we can retrieve or read it. In this chapter, we'll learn the basics of reading our data. We will cover the following topics:

Retrieving data
Filtering and searching data
Sorting data
Joining data
Summarizing data

The rest of the chapter is locked

You're reading from Getting Started with MariaDB Explore the powerful features of MariaDB with practical examples

Table of Contents (11) Chapters

Chapter 7. Using MariaDB – Retrieving Data

Authors (1)

Personalised recommendations for you

You're reading from Getting Started with MariaDB Explore the powerful features of MariaDB with practical examples

Table of Contents (11) Chapters

Chapter 7. Using MariaDB – Retrieving Data

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you