MySQL tutorial for professionals

Download free MySQL tutorial course in PDF, training file in 70 chapters and 199 pages. Free unaffiliated ebook created from Stack OverFlow contributor.

Table of contents

• About
• Getting started with MySQL
• Getting Started
• Information Schema Examples
• Data Types
• CHAR(n)
• DATE, DATETIME, TIMESTAMP, YEAR, and TIME
• VARCHAR(255) -- or not
• INT as AUTO_INCREMENT
• Others
• Implicit / automatic casting
• Introduction (numeric)
• Integer Types
• Fixed Point Types
• Floating Point Types
• Bit Value Type
• SELECT
• SELECT with DISTINCT
• SELECT all columns (*)
• SELECT by column name
• SELECT with LIKE (%)
• SELECT with CASE or IF
• SELECT with Alias (AS)
• SELECT with a LIMIT clause
• SELECT with BETWEEN
• SELECT with WHERE
• SELECT with LIKE(_)
• SELECT with date range
• Backticks
• Backticks usage
• NULL
• Uses for NULL
• Testing NULLs
• Limit and O?set
• Limit and O?set relationship
• Creating databases
• Create database, users, and grants
• Creating and Selecting a Database
• MyDatabase
• System Databases
• Using Variables
• Setting Variables
• Row Number and Group By using variables in Select Statement
• Comment MySQL
• Adding comments
• Commenting table de?nitions
• Data Types
• Backticks
• Limit and Offset
• Using Variables
• INSERT
• UPDATE
• Group By
• Joins
• UNION
• String operations
• Handling Time Zones
• VIEW
• ALTER TABLE
• MySQL LOCK TABLE
• Stored routines (procedures and functions)
• Full-Text search
• JSON
• MySQL Admin
• Configuration and tuning
• ENUM
• Character Sets and Collations
• Converting from MyISAM to InnoDB
• Log files
• Partitioning
• Backup using mysqldump
• LOAD DATA INFILE
• MySQL client
• Customize PS1
• Connecting with UTF-8 Using Various Programming language.
• One to Many
• SSL Connection Setup
• Create New User
• Security via GRANTs
• Change Password
• Recover and reset the default root password for MySQL 5.7+
• Recover from lost root password
• MySQL Performance Tips
• Performance Tuning
• Reserved Words

It is a free MySQL ebook created for beginners. The content is extracted from Stack Overflow pltaform, which is written by many MySQL developers and contributors.

The content is released under Creative Commons BY-SA