MySQL Tutorials - Herong's Tutorial Examples - v4.46, by Herong Yang
Full Version in PDF/EPUB
This section provides information on how to obtain the full version of this book in PDF, EPUB, or other format.
There are several ways to obtain the full version of this book:
Amazon Kindle Store for eBook Version at $9.99 - Follow this link https://www.amazon.com/dp/B07VQ2YGK2 to purchase. Free preview pages of the book are available.
Amazon Kindle Store for Paperback Version at $29.99 - Follow this link https://www.amazon.com/dp/1084166518 to purchase. Free preview pages of the book are available.
Google Play store for ePUB Version at $9.99 - Follow this link https://play.google.com/store/books/details?id=hA4QEAAAQBAJ to purchase. Free preview pages of the book are available.
Google Play store for PDF Version at $9.99 - Follow this link https://play.google.com/store/books/details?id=hg4QEAAAQBAJ to purchase. Free preview pages of the book are available.
Some sample pages in PDF format -
Please send email to herong_yang@yahoo.com to obtain a free updated PDF version, if you have purchased a full version of this book in any 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