Cargando…

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:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000Ii 4500
001 OR_ocn915143467
003 OCoLC
005 20231017213018.0
006 m o d
007 cr unu||||||||
008 150730s2015 enka o 001 0 eng d
040 |a UMI  |b eng  |e rda  |e pn  |c UMI  |d YDXCP  |d IDEBK  |d EBLCP  |d COO  |d OCLCF  |d TEFOD  |d DEBBG  |d OCLCQ  |d MERUC  |d CEF  |d AU@  |d OCLCQ  |d OCLCO  |d WYU  |d UAB  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO 
019 |a 911848630  |a 913922369 
020 |a 9781782175711  |q (electronic bk.) 
020 |a 1782175717  |q (electronic bk.) 
020 |z 1782175717 
020 |z 1785284126 
020 |z 9781785284120 
029 1 |a AU@  |b 000058606983 
029 1 |a DEBBG  |b BV043019985 
029 1 |a DEBBG  |b BV043620903 
029 1 |a DEBSZ  |b 455695539 
029 1 |a GBVCP  |b 882743007 
035 |a (OCoLC)915143467  |z (OCoLC)911848630  |z (OCoLC)913922369 
037 |a CL0500000623  |b Safari Books Online 
037 |a 2CF5460B-9A0B-4CFA-B2D9-A51D55010CE2  |b OverDrive, Inc.  |n http://www.overdrive.com 
050 4 |a QA76.9.D3 
082 0 4 |a 005.75/65 
049 |a UAMI 
100 1 |a Bartholomew, Daniel,  |e author. 
245 1 0 |a Getting started with MariaDB :  |b explore the powerful features of MariaDB with practical examples /  |c Daniel Bartholomew. 
246 3 |a Getting started with Maria database 
246 3 0 |a Explore the powerful features of MariaDB with practical examples 
250 |a Second edition. 
264 1 |a Birmingham, UK :  |b Packt Publishing,  |c 2015. 
300 |a 1 online resource (1 volume) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
490 1 |a Community experience distilled 
588 0 |a Online resource; title from cover (Safari, viewed July 28, 2015). 
500 |a Includes index. 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
520 |a 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. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a MariaDB. 
630 0 0 |a MySQL (Electronic resource) 
630 0 7 |a MariaDB  |2 fast 
630 0 7 |a MySQL (Electronic resource)  |2 fast 
650 0 |a Relational databases. 
650 0 |a Database management. 
650 6 |a Bases de données relationnelles. 
650 6 |a Bases de données  |x Gestion. 
650 7 |a Database management  |2 fast 
650 7 |a Relational databases  |2 fast 
776 0 8 |i Print version:  |a Bartholomew, Daniel.  |t Getting started with MariaDB : explore the powerful features of MariaDB with practical examples.  |b Second edition.  |d Birmingham, England ; Mumbai, [India] : Packt Publishing, ©2015  |h ix, 117 pages  |k Community experience distilled.  |z 9781785284120 
830 0 |a Community experience distilled. 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781785284120/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a EBL - Ebook Library  |b EBLB  |n EBL2072487 
938 |a ProQuest MyiLibrary Digital eBook Collection  |b IDEB  |n cis31823331 
938 |a YBP Library Services  |b YANK  |n 12480623 
994 |a 92  |b IZTAP