Descriptions
MySQL for Developers, Join Aaron Francis in this MySQL for Developers course and master schemas, indexing, and efficient querying to become an expert database user—no DBA skills required. The curriculum is designed for application developers who want to confidently use MySQL in production, focusing on practical skills that keep applications fast and reliable. You will learn effective schema design, explore various data types and their use cases, and understand the drawbacks of each. The course covers indexing strategies, query optimization, and hands-on techniques for writing efficient queries that leverage indexes for speed. Through practical demonstrations using TablePlus, you will run actual queries, examine tables, and analyze results in real time, applying all concepts to real-world scenarios often encountered by developers. No prior deep database knowledge is required, and the lessons avoid slides in favor of interactive, visual learning.
What you’ll learn
- Master schema design for efficient and reliable MySQL databases
- Understand and apply various data types and their use cases
- Implement effective indexing strategies to optimize query performance
- Write and optimize queries that leverage indexes for speed
- Analyze tables and results in real time using TablePlus
- Apply learned concepts to real-world scenarios faced by developers
Who this course is for
- Application developers seeking practical MySQL skills for production environments
- Developers who want to demystify database internals without becoming DBAs
- Anyone interested in efficient schema design, indexing, and query optimization
Specificatoin of MySQL for Developers
- Publisher : DatabaseSchool
- Teacher : Aaron Francis
- Language : English
- Level : All Levels
- Number of Course : 63
- Duration : 7 hours and 41 minutes
Content of MySQL for Developers
Introduction
Introduction to schema
Integers
Decimals
Strings
Binary strings
Long strings
Enums
Dates
JSON
Unexpected types
Generated columns
Recap
Introduction to indexes
B+ trees
Primary keys
Secondary keys
Primary key data types
Where to add indexes
Index selectivity
Prefix indexes
Composite indexes
Covering indexes
Functional indexes
Indexing JSON columns
Indexing for wildcard searches
Fulltext indexes
Invisible indexes
Duplicate indexes
Foreign keys
Introduction to queries
Explain overview
Explain access types
Explain analyze
Index obfuscation
Redundant and approximate conditions
Select only what you need
Limiting rows
An overview of joins
Cursor pagination
Indexing joins
Subqueries
Common table expressions
Recursive CTEs
Unions
Window functions
Sorting and limiting
Sorting with indexes
Sorting with composite indexes
Counting resu
Dealing with NULLs
Introduction to examples
MD5 column
MD5 over multiple columns
Bitwise operations
Timestamps versus booleans
Claiming rows
Summary tables
Meta tables
Offset limit pagination
Deferred joins
Geographic searches
Thank you
Pictures
Sample Clip
Installation Guide
Extract the files and watch with your favorite player
Subtitle : Not Available
Quality: 1080p
Download Links
Downloadly
Rapidgator
Password file(s): www.downloadly.ir
File size
2.44 GB
