Getting started with MariaDB : explore the powerful features of MariaDB with practical examples /

This book is for anyone who wants to learn more about databases in general and wants to get started with MariaDB. Prior database experience is not required.

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Bartholomew, Daniel (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, UK : Packt Publishing, 2015.
Edición:Second edition.
Colección:Community experience distilled.
Temas:
MariaDB.
MySQL (Electronic resource)
MariaDB
Relational databases.
Database management.
Bases de données relationnelles.
Bases de données > Gestion.
Database management
Relational databases
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
Tabla de Contenidos:
  • Cover
  • Copyright
  • Credits
  • About the Author
  • About the Reviewers
  • www.PacktPub.com
  • Table of Contents
  • Preface
  • Chapter 1: Installing MariaDB
  • Choosing a MariaDB series
  • The development series
  • The stable series
  • The maintenance 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
  • Chapter 2: Configuring MariaDB
  • The MariaDB filesystem layout
  • The MariaDB filesystem layout on Windows
  • The MariaDB filesystem layout on Linux
  • Modular configuration on Linux
  • The anatomy of the MariaDB configuration file
  • Where is my configuration file?
  • Comments
  • Groups
  • Options that do not require values
  • Options that require values
  • Option formatting
  • Options, options everywhere
  • Activating configuration changes
  • Summary
  • Chapter 3: Securing MariaDB
  • Security layers
  • Securing MariaDB in 10 seconds
  • Connecting safely
  • Connecting safely on the command line
  • Connecting safely in scripts
  • Server security
  • Building security
  • Internal network security
  • Internet security
  • Summary
  • Chapter 4: Administering MariaDB
  • User privileges
  • Global administrative user privileges
  • Database, table, and column user privileges
  • Miscellaneous user privileges and limits
  • Creating users
  • Granting, revoking, and showing permissions
  • Granting permissions
  • Revoking permissions
  • Showing permissions
  • Setting and changing passwords
  • Removing users
  • Summary
  • Chapter 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
  • Using CREATE DATABASE to create a database
  • Using DROP DATABASE to delete a database
  • Data, tables, and normalization
  • Creating, altering, and dropping tables
  • Using CREATE TABLE
  • Using CREATE TABLE
  • datatypes
  • Using CREATE TABLE- other options
  • Using CREATE TABLE
  • an example
  • Using SHOW to display the command used to create a table
  • Using DESCRIBE to explore the structure of a table
  • Using ALTER TABLE
  • Using ALTER TABLE
  • basic syntax
  • Using ALTER TABLE
  • adding a column
  • Using ALTER TABLE
  • modifying a column
  • Using ALTER TABLE
  • dropping a column
  • Using DROP TABLE
  • Summary
  • Chapter 6: Using MariaDB
  • Inserting, Updating, and Deleting
  • Using INSERT
  • Inserting complete rows
  • Inserting partial rows
  • Inserting from another table
  • Inserting from a file
  • Using UPDATE
  • Using DELETE
  • Summary
  • Chapter 7: Using MariaDB
  • Retrieving Data
  • Retrieving data
  • Retrieving everything
  • Retrieving selected columns
  • Filtering and searching data
  • Filtering by exact values
  • Using logical operators
  • Using the AND operator
  • Using the OR operator
  • Evaluation order
  • Using the IN operator
  • Using the NOT operator
  • Searching with LIKE
  • Sorting data
  • Joining data
  • Summarizing data
  • The AVG function
  • The COUNT function
  • The MIN and MAX functions
  • The SUM function
  • Using GROUP BY with summarized data
  • Using HAVING to filter GROUP BY
  • Summary
  • Chapter 8: Maintaining MariaDB
  • MariaDB log files
  • The binary log
  • The error log
  • The general query log
  • The slow query log
  • Optimizing and tuning MariaDB
  • Backing up, importing, and restoring data
  • Basic backups with mysqldump
  • Restoring backups made with mysqldump
  • Making tab-delimited backups with mysqldump.
  • Restoring and importing data with mysqlimport
  • Making backups of MyISAM tables with mysqlhotcopy
  • Making backups of XtraDB and InnoDB tables with xtrabackup
  • Restoring backups made with xtrabackup
  • Making cold backups
  • Repairing MariaDB
  • Checking and optimizing tables with mysqlcheck
  • Repairing tables
  • Summary
  • Appendix: MariaDB Next Steps
  • Index.

Ejemplares similares