CF

MySQL for Developers

7h 41m
English
Paid

MySQL for Developers, taught by Aaron Francis, is a practice-oriented course tailored for application developers looking to enhance their skills in database management. This course provides a systematic approach to learning, hence it is advisable to follow the modules in the given sequence.

Course Overview

This program commences with a focus on schema design. You will learn about constructing effective table structures, choosing appropriate data types, and understanding their constraints and limitations. The course further delves into the crucial area of indexing, explaining what indexes are, their role in speed optimization, and their internal workings.

Optimizing SQL Queries

One of the core elements of this course is mastering the art of writing efficient queries. This section provides strategies for formulating queries that leverage the benefits of the established indexes.

Practical Cases and Applications

The concluding part of the course presents real-world scenarios, enabling you to apply the principles learned. These practical cases are designed to equip you with the skills to tackle common challenges faced by developers.

Target Audience

This course is tailored for developers eager to enhance their understanding of database processes without the need for extensive database administrator expertise. While no prior deep knowledge is necessary, a fundamental familiarity with databases will be beneficial.

Learning Methodology

Our primary teaching method is an interactive hands-on approach using the TablePlus client. You will actively execute queries, explore various tables, and analyze outcomes in a dynamic and real-time setting.

About the Author: Aaron Francis

Aaron Francis thumbnail

Aaron Francis is a Texas-based developer and educator who runs Try Hard Studios and is best known in the PHP / Laravel community for his deep production-database content. His videos and courses focus on the parts of working software that don't get attention from the framework documentation: SQL performance, database internals, and the realities of running databases at scale.

His CourseFlix listing reflects that focus — three database courses (High Performance SQLite, Mastering Postgres, MySQL for Developers) plus two on screencasting craft (Screencasting.com and Screenflow for Screencasters) covering the workflow he uses to produce the database material itself. The database courses are unusually rigorous for the YouTube-tutorial market: each one runs many hours and treats the database as a first-class object of study, not a black box behind an ORM.

Watch Online 63 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 63 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Introduction
All Course Lessons (63)
#Lesson TitleDurationAccess
1
Introduction Demo
03:21
2
Introduction to schema
03:21
3
Integers
06:31
4
Decimals
05:23
5
Strings
07:51
6
Binary strings
04:52
7
Long strings
04:13
8
Enums
05:06
9
Dates
09:19
10
JSON
07:13
11
Unexpected types
06:12
12
Generated columns
09:54
13
Recap
01:51
14
Introduction to indexes
06:23
15
B+ trees
05:41
16
Primary keys
12:23
17
Secondary keys
04:46
18
Primary key data types
05:08
19
Where to add indexes
12:04
20
Index selectivity
09:39
21
Prefix indexes
06:30
22
Composite indexes
18:40
23
Covering indexes
10:33
24
Functional indexes
09:53
25
Indexing JSON columns
13:56
26
Indexing for wildcard searches
06:29
27
Fulltext indexes
09:45
28
Invisible indexes
02:58
29
Duplicate indexes
04:20
30
Foreign keys
10:38
31
Introduction to queries
01:04
32
Explain overview
11:40
33
Explain access types
07:39
34
Explain analyze
06:57
35
Index obfuscation
04:00
36
Redundant and approximate conditions
06:18
37
Select only what you need
08:05
38
Limiting rows
09:46
39
An overview of joins
09:29
40
Cursor pagination
08:45
41
Indexing joins
13:21
42
Subqueries
09:44
43
Common table expressions
09:12
44
Recursive CTEs
11:49
45
Unions
05:41
46
Window functions
09:23
47
Sorting and limiting
06:06
48
Sorting with indexes
08:38
49
Sorting with composite indexes
05:54
50
Counting resu
05:24
51
Dealing with NULLs
06:58
52
Introduction to examples
00:58
53
MD5 column
06:48
54
MD5 over multiple columns
06:08
55
Bitwise operations
09:35
56
Timestamps versus booleans
03:49
57
Claiming rows
05:49
58
Summary tables
05:22
59
Meta tables
06:04
60
Offset limit pagination
08:31
61
Deferred joins
06:09
62
Geographic searches
07:12
63
Thank you
03:49
Unlock unlimited learning

Get instant access to all 62 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Related courses

Frequently asked questions

What is MySQL for Developers about?
MySQL for Developers , taught by Aaron Francis, is a practice-oriented course tailored for application developers looking to enhance their skills in database management. This course provides a systematic approach to learning, hence it is…
Who teaches this course?
It is taught by Aaron Francis. You can find more courses by this instructor on the corresponding source page.
How long is the course?
It contains 63 lessons with a total runtime of 7 hours 41 minutes. Every lesson is available to watch online at your own pace.
Is it free to watch?
It is part of CourseFlix's premium catalog. A subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch it online?
The course is available to watch online on CourseFlix at https://courseflix.net/course/mysql-for-developers. The page hosts every lesson with the integrated video player; no download is required.