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: 2795
Created: 2019-04-30

Others MySQL Tutorials

Learning MySQL

Essential MySQL

MySQL – Create Database free PDF

MySQL Notes for Professionals

Others related eBooks about MySQL tutorial for professionals

Hacking Exposed Web Applications

Download free course Hacking Exposed Web Applications, pdf file on 416 pages by Joel Scambray, Mike Shema....

Modern Web Development on the JAMstack

Learn how to run your web projects - everything from simple sites to complex applications ..., download free JAMstack tutorial in PDF (127 pages) created by Mathias Biilmann ....

jQuery Fundamentals

With this unique, project-oriented book, author Rebecca Murphey teaches even the most novice of JavaScript users how to quickly get started utilizing the JavaScript jQuery Library to decrease the amount of code that needs to be written and tested. A four-color code syntax highlighting system provi...

Introduction to web development with Python and Django

Download introduction to web development with Python and Django, free training document in PDF under 28 pages....

A Practical Guide to Designing for the Web

A Practical Guide to Designing for the Web aims to teach you techniques for designing your website using the principles of graphic design. Featuring five sections, each covering a core aspect of graphic design: Getting Started, Research, Typography, Colour, and Layout. Learn solid graphic design...

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 ....

HTML5 tutorial for professionals

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

How to Code in HTML5 and CSS3

Download free course How to Code in HTML5 and CSS3, pdf file on 124 pages by Damian Wielgosik....

The React Beginner's Handbook

The React Beginner's Handbook follows the 80/20 rule: learn in 20% of the time the 80% of ..., download free React tutorial in PDF (40 pages) created by ....

Twitter Bootstrap 4 Succinctly

Download free course Twitter Bootstrap 4 Succinctly, pdf file on 115 pages by Peter Shaw....