MySQL Notes for Professionals

• Getting started with MySQL
• Data Types
• SELECT
• Backticks
• NULL
• Limit and Offset
• Creating databases
• Using Variables
• Comment MySQL
• INSERT
• DELETE
• UPDATE
• ORDER BY
• Group By
• Error 1055: ONLY_FULL_GROUP_BY: something is not in GROUP BY clause ...
• Joins
• JOINS: Join 3 table with the same name of id.
• UNION
• Arithmetic
• String operations
• Date and Time Operations
• Handling Time Zones
• Regular Expressions
• VIEW
• Table Creation
• ALTER TABLE
• Drop Table
• MySQL LOCK TABLE
• Error codes
• Stored routines (procedures and functions)
• Indexes and Keys
• Full-Text search
• PREPARE Statements
• JSON
• Extract values from JSON type
• MySQL Admin
• TRIGGERS
• Configuration and tuning
• Events
• ENUM
• Install Mysql container with Docker-Compose
• Character Sets and Collations
• MyISAM Engine
• Converting from MyISAM to InnoDB
• Transaction
• Log files
• Clustering
• Partitioning
• Replication
• Backup using mysqldump
• mysqlimport
• LOAD DATA INFILE
• MySQL Unions
• MySQL client
• Temporary Tables
• Customize PS1
• Dealing with sparse or missing data
• Connecting with UTF-8 Using Various Programming language.
• Time with subsecond precision
• One to Many
• Server Information
• 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

Download file

Others related eBooks about MySQL Notes for Professionals