MySQL for Developers
7h 41m
English
Paid
Course description
The course "MySQL for Developers" led by Aaron Francis is a practice-oriented introduction to working with databases, specifically designed for application developers. The program is structured sequentially, so it is recommended to go through the materials in order.
The first part covers schema design: effective table structures, selection and assignment of different data types, as well as their constraints and potential drawbacks. This is followed by a detailed analysis of indexing—what indexes are, why they ensure high speed, and how they function. The course then moves on to techniques for writing optimal queries that make the most out of the created indexes. The final block is dedicated to practical cases that demonstrate the application of all studied principles in typical developer tasks.
The course is aimed at developers seeking to gain a deeper understanding of database operations without delving into the duties of a DBA. No deep preliminary knowledge is required. The main format is a hands-on approach using the TablePlus client: executing real queries, exploring tables, and analyzing results in real-time.
Watch Online
0:00
/ #1: Introduction
All Course Lessons (63)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 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 subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Just Use Postgres!
Sources: Denis Magda
Find out how Postgres handles generative AI tasks, geospatial data, and many more. Get the most out of one of the most popular DBMS.
Apache Kafka Series - Kafka Streams for Data Processing
Sources: udemy
Learn the Kafka Streams API with Hands-On Examples, Learn Exactly Once, Build and Deploy Apps with Java 8. Learn the Kafka Streams data processing library, for
4 hours 50 minutes 7 seconds
Fundamentals of Backend Engineering
Sources: udemy
Backend engineering is an art. During my 18 years career working with and building backend applications, I discovered that certain communication design patterns
16 hours 53 minutes 4 seconds
Ludicrous Speed Postgres
Sources: Creston Jamison
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database usage. It is designed for those...
12 hours 27 minutes 44 seconds
Effective Database Design
Sources: Ben Brumm
The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
1 hour 3 minutes 56 seconds