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

Warning: Trying to access array offset on false in /home/tutovnfz/public_html/article.php on line 233

Others MySQL Tutorials

MySQL – Create Database free PDF

Essential MySQL

MySQL Notes for Professionals

Learning MySQL

Others related eBooks about MySQL tutorial for professionals

Practical Semantic Web and Linked Data Applications

The next major advance in the Web will be Web 3.0 which will be built on semantic Web technologies. ...

Transforms in CSS

Present information in stunning new ways by transforming CSS elements in two- and three-di..., download free CSS tutorial in PDF (52 pages) created by ....

Learning JQuery

This is a jQuery tutorial for beginners, it provides in-depth knowledge of jQuery technology. This jQuery tutorial will help you learn jQuery basics, examples, selectors, events, effects, CSS, and attributes....

Learning Node.js

Node.js is an event-based, non-blocking, asynchronous I/O framework that uses Google's V8 ..., download free Node.js tutorial in PDF (414 pages) created by ....

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

Node.js programming by example

Download Free training document about Node.js under 16 pages intended to advanced level-users....

Deep Learning with JavaScript: Neural Networks in TensorFlow.js

Deep learning has transformed the fields of computer vision, image processing, and natural language applications. Thanks to TensorFlow.js, now JavaScript developers can build deep learning apps without relying on Python or R....

Reintroducing React

Download free course Reintroducing React, pdf file on 257 pages by Ohans Emmanuel....

Angular Testing Succinctly

Though sometimes perceived as a hurdle, testing can save developers from heartbreak in the..., download free Angular tutorial in PDF (94 pages) created by Joseph Booth ....

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