MySQL Optimization

Description

MySQL is introduced from the ground up in seven PDF lessons. You start with the basics and data types and constraints, then learn the CRUD operations for creating, reading, updating and deleting data.

The later lessons explain table relationships and joins, filtering and sorting, and aggregate functions for summarising data. The final lesson introduces indexes and how they affect performance. After reading, you will be able to read and write basic queries and understand why some queries run faster than others. Exercises and tables accompany most lessons. Each lesson builds on the previous one, so the order of the PDFs is worth following.

Who it is for: beginners who want a first working knowledge of MySQL and how to keep queries efficient.

What’s included
7 PDF lessons · 66 pages · about 15,000 words
One ZIP download that is yours to keep — read on any device, no subscription or app needed.

Course programme

1. Getting Started with MySQL Basics
2. Working with Data Types and Constraints
3. Mastering CRUD Operations
4. Understanding Table Relationships and Joins
5. Filtering and Sorting Data Efficiently
6. Using Aggregate Functions for Analysis
7. Introduction to Indexes and Performance

MySQL is a trademark of its owner. This course is independent and is not affiliated with, endorsed or sponsored by the trademark owner.