Last Updated: 2016

This guide explores the fundamentals of MySQL, an open-source relational database management system, including installing MySQL, setting up databases and tables, querying and manipulating data, optimizing performance, and learning essential SQL concepts like joins, aggregation, and subqueries.

eBook Contents

Introduction - MySQL Practical Guide - Databases manipulation - Language - Language/Browsing the databases - Language/Specifying table names - Language/Definitions - Language/User Variables - Language/Alias - Language/Data Types - Language/Table manipulation - Language/Data manipulation -
Language/Queries - Language/Using/Dealing with NULL - Language/Operators - Language/Import / export - Language/Functions - Language/Stored Programs - Language/Spatial databases -Pivot table - Administration - Replication - Optimization

eBook License: Creative Commons

Free eBook to download in PDF - 713 Kb - 82 pages

• Electronic books / Computers
• Electronic books / Computers / Databases
• Electronic books / Computers / Databases / MySQL
• Electronic books / Courses and tutorials