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

Size : 1.88 MB
File type : pdf
Downloads: 2793
Created: 2019-04-30

Others MySQL Tutorials

Essential MySQL

MySQL Notes for Professionals

MySQL – Create Database free PDF

Learning MySQL

Others related eBooks about MySQL tutorial for professionals

React in patterns

This book about common design patterns / techniques used while developing with React. It i..., download free React tutorial in PDF (107 pages) created by ....

Understanding the DOM

Download free course Understanding the DOM, pdf file on 126 pages by Tania Rascia....

Understanding the DOM

JavaScript is the de facto programming language of the web, but the language itself does n..., download free DOM tutorial in PDF (126 pages) created by Tania Rascia ....

PHP: The Right Way

Download free course PHP: The Right Way, pdf file on 76 pages by Phil Sturgeon, Josh Lockhart....

AngularJS Web Application Development Cookbook

Packed with easy-to-follow recipes, this practical guide will show you how to unleash the ..., download free Angular tutorial in PDF (346 pages) created by Matt Frisbie ....

Go for Javascript Developers

This book compares between two programming languages, Golang (or Go) and ECMAScript (or Javascript / JS). The merits of this pairing is the popularity of these languages. That's it. They are not similar, in fact, they are quite different. Javascript is an event driven, dynamically typed and interpre...

HTML5 canvas tutorial

Download free HTML5 tutorial course in PDF, training file in 18 chapters and 180 pages. Free unaffiliated ebook created from Stack OverFlow contributor....

Eloquent JavaScript, 3rd Edition

JavaScript lies at the heart of almost every modern web application, from social apps like..., download free JavaScript tutorial in PDF (472 pages) created by ....

AngularDart Succinctly

Download free course AngularDart Succinctly, pdf file on 114 pages by by Ed Freitas....

Learn to build with PHP

This is a free PHP PDF tutorial in 9 chapters and 29 pages. This course aims to give students the basics of PHP concepts. This is a pretty short book, but we're going to cover a lot. In just a few pages, we're going to create a simple clone of Twitter....