MySQL Tutorials - Herong's Tutorial Examples - v4.46, by Herong Yang
About This Book
This section provides some detailed information about this book - MySQL Tutorials - Herong's Tutorial Examples.
Title: MySQL Tutorials - Herong's Tutorial Examples
Author: Herong Yang - Contact by email via herong_yang@yahoo.com.
Category: COMPUTERS / Database Administration & Management
Version/Edition: v4.46, 2023
Number of pages: 400
Description: This MySQL tutorial book is a collection of notes and sample codes written by the author while he was learning MySQL himself, an ideal tutorial guide for beginners. Topics include introduction of Structured Query Language (SQL); installation of MySQL server on Windows, Linux, and macOS; using MySQL client program; accessing MySQL server from PHP, Java and Perl programs; SQL data types, literals, operations, expressions, and functions; Statements of Data Definition Language (DDL), Data Manipulation Language (DML), and Query Language; creating and using indexes; using window functions; stored procedures; transaction management; locks and deadlocks; InnoDB and other storage engines. Updated in 2023 (Version v4.46) with minor changes.
Keywords: CREATE, cursor, datatype, DBD, DBI, deadlock, export, FETCH, HAVING, import, INDEX, isolation, Linux, lock, macOS, MySQL, query, RDBMS, SQL, SQL-92, stored procedure, TIMESTAMP, transaction, Windows, XML.
Copyright:
Revision history:
Web version: https://www.herongyang.com/MySQL - Provides free sample chapters, latest updates and readers' comments. The Web version of this book has been viewed a total of:
PDF/EPUB version: https://www.herongyang.com/MySQL/PDF-Full-Version.html - Provides information on how to obtain the full version of this book in PDF, EPUB, or other format.
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Window Functions for Statistical Analysis
Use Index for Better Performance
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
System, User-Defined and Stored Procedure Variables
Storage Engines in MySQL Server
InnoDB Storage Engine - Primary and Secondary Indexes
Performance Tuning and Optimization
Installing MySQL Server on Linux