Learning MySQL and MariaDB
Год издания: 2015
Автор: Russell J.T. Dyer
Издательство: O'Reilly Media
ISBN: 978-1-4493-6290-4, 978-1-4493-6284-3
Язык: Английский
Формат: PDF
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 408
Описание: If you’re a programmer new to databases—or just new to MySQL and its community-driven variant, MariaDB—you’ve found the perfect introduction. This hands-on guide provides an easy, step-by-step approach to installing, using, and maintaining these popular relational database engines.
Author Russell Dyer, Curriculum Manager at MariaDB and former editor of the MySQL Knowledge Base, takes you through database design and the basics of data management and manipulation, using real-world examples and many practical tips. Exercises and review questions help you practice what you’ve just learned.
Примеры страниц Оглавление
The Software
Chapter 1 Introduction
The Value of MySQL and MariaDB
Mailing Lists and Forums
Other Books and Other Publications
Chapter 2 Installing MySQL and MariaDB
The Installation Packages
Licensing
Finding the Software
Choosing a Distribution
The _AMP Alternatives
Post-Installation
Chapter 3 The Basics and the mysql Client
The mysql Client
Connecting to the Server
Starting to Explore Databases
Summary
Exercises
Database Structures
Chapter 4 Creating Databases and Tables
Creating a Database
Creating Tables
Inserting Data
More Perspectives on Tables
Summary
Exercises
Chapter 5 Altering Tables
Prudence When Altering Tables
Essential Changes
Optional Changes
Indexes
Summary
Exercises
Basics of Handling Data
Chapter 6 Inserting Data
The Syntax
Practical Examples
Other Possibilities
Summary
Exercises
Chapter 7 Selecting Data
Basic Selection
Selecting by a Criteria
Ordering Results
Limiting Results
Combining Tables
Expressions and the Like
Counting and Grouping Results
Summary
Exercises
Chapter 8 Updating and Deleting Data
Updating Data
Deleting Data
Summary
Exercises
Chapter 9 Joining and Subquerying Data
Unifying Results
Joining Tables
Subqueries
Summary
Exercises
Built-In Functions
Chapter 10 String Functions
Formatting Strings
Extracting Text
Searching Strings and Using Lengths
Converting String Types
Compressing Strings
Summary
Exercises
Chapter 11 Date and Time Functions
Date and Time Data Types
Current Date and Time
Extracting Date and Time Components
Formatting Dates and Time
Adjusting to Standards and Time Zones
Adding and Subtracting Dates and Time
Comparing Dates and Times
Summary
Exercises
Chapter 12 Aggregate and Numeric Functions
Aggregate Functions
Numeric Functions
Summary
Exercises
Administration and Beyond
Chapter 13 User Accounts and Privileges
User Account Basics
Restricting the Access of User Accounts
Administrative User Accounts
Revoking Privileges
Deleting a User Account
Changing Passwords and Names
User Roles
Summary
Exercises
Chapter 14 Backing Up and Restoring Databases
Making Backups
Restoring Backups
Developing a Backup Policy
Summary
Exercises
Chapter 15 Bulk Importing Data
Preparing to Import
Loading Data Basics
Better Loading
More Field and Line Definitions
Importing from Outside MySQL
Bulk Exporting Data
Summary
Exercises
Chapter 16 Application Programming Interfaces
Creating API User Accounts
C API
Perl DBI
PHP API
Python
Ruby API
SQL Injection
Summary
Exercises
Colophon

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 4 MB Download Torrent

Login using:

Загрузка...

Similar topics



   
Current time is: 19-Dec 00:55 :: All times are UTC + 3