Jump Start MySQL.

Format:

Book

Author/Creator:

Boronczyk, Timothy.

Contributor:

Mason, Ralph S., editor.

Language:

English

Subjects (All):

MySQL (Electronic resource).

Physical Description:

1 online resource (152 p.)

Edition:

1st edition

Place of Publication:

Collingwood, Victoria : SitePoint, 2015.

Language Note:

English

System Details:

text file

Summary:

Get a Jump Start on working with MySQL today! MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers. In just one weekend with this hands-on tutorial, you'll learn how to: Get started with MySQLStore, modify, and retrieve dataWork with multiple tablesConnect to your database through codeProgram the databaseBack up your data

Contents:

Intro

Jump Start MySQL

Table of Contents

Preface

What is a Database?

From Codd to MySQL, a Brief History

Alternatives and the Future of MySQL

Who Should Read This Book

Conventions Used

Code Samples

Tips, Notes, and Warnings

Supplementary Materials

Want to Take Your Learning Further?

Getting Started with MySQL

Installing MySQL on Linux

Installing via a Package Manager

Installing from Source

Installing MySQL on Windows

Communicating with the Server

MySQL Accounts and Security

Conclusion

Storing Data

Creating Tables

Data Types and Storage Requirements

Numeric Types

String Types

Temporal Types

Spacial Data Types

Storage Engines

Adding Data

Using Transactions

Retrieving and Updating Data

Deploying Sakila

Retrieving Data

Ordering Results

Managing the Number of Returned Rows

Aggregate Functions and Grouping

Keeping Data Fresh

Updating Data

Deleting Data

Working with Multiple Tables

Joining Tables

Types of Joins

Abstracting with Views

Normal Forms

First Normal Form

Second Normal Form

Third Normal Form

Altering Tables

Connecting from Code

Connecting from Python with Connector/Python

Basic Querying

Buffered and Unbuffered Results

Prepared Statements

Connecting from PHP with PDO

Handling Errors

Connecting from R with RMySQL

Working with Tables

Programming the Database

Learning the Basics

Functions

Stored Procedures

Triggers

Events

User-defined Functions

Backups and Replication

Logical Backups

Using mysqldump

Redirecting SELECT

Physical Backups

Replication

Setting up Replication

Fixing Broken Replication

Plan Ahead.

Conclusion.

Notes:

Description based upon print version of record.

ISBN:

9781457192807

1457192802

9781457192838

1457192837

9781457192821

1457192829

OCLC:

908557327