MySQL-8.0-Complete-Learning-Guide/index.html at main · JMT-24/MySQL-8.0-Complete-Learning-Guide · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>MySQL 8.0 Complete Learning Guide</title>
<style>
:root{--pri:#1a73e8;--pri-d:#0d47a1;--bg:#f5f7fa;--card:#fff;--txt:#1e293b;--txt-l:#64748b;--bdr:#e2e8f0;--ok:#22c55e;--warn:#f59e0b;--err:#ef4444}
*,*::before,*::after{box-sizing:border-box;margin:0;padding:0}
body{font-family:'Segoe UI',system-ui,-apple-system,sans-serif;background:var(--bg);color:var(--txt);line-height:1.7}
.hero{background:linear-gradient(135deg,#1e3a5f,#0d47a1,#1a73e8);color:#fff;padding:60px 36px;text-align:center}
.hero h1{font-size:2.4rem;margin-bottom:8px;font-weight:800}
.hero p{font-size:1.1rem;opacity:.9;max-width:650px;margin:0 auto 16px}
.hero .stats{display:flex;justify-content:center;gap:32px;margin-top:24px;flex-wrap:wrap}
.hero .stat{text-align:center}
.hero .stat .num{font-size:2rem;font-weight:800;display:block}
.hero .stat .lbl{font-size:.8rem;opacity:.8}
.content{max-width:900px;margin:0 auto;padding:40px 24px 80px}
h2{font-size:1.5rem;color:var(--pri-d);margin:40px 0 20px;padding-bottom:10px;border-bottom:2px solid var(--bdr)}
.grid{display:grid;grid-template-columns:1fr;gap:20px}
@media(min-width:700px){.grid{grid-template-columns:1fr 1fr}}
.card{background:var(--card);border:1px solid var(--bdr);border-radius:12px;padding:24px;box-shadow:0 2px 8px rgba(0,0,0,.04);transition:transform .2s,box-shadow .2s;text-decoration:none;color:var(--txt);display:block}
.card:hover{transform:translateY(-3px);box-shadow:0 8px 24px rgba(0,0,0,.1)}
.card-head{display:flex;align-items:center;gap:12px;margin-bottom:12px}
.card-num{background:var(--pri);color:#fff;width:44px;height:44px;border-radius:10px;display:flex;align-items:center;justify-content:center;font-weight:800;font-size:1.1rem;flex-shrink:0}
.card-title{font-size:1.1rem;font-weight:700}
.card-desc{font-size:.85rem;color:var(--txt-l);margin-bottom:14px}
.tags{display:flex;flex-wrap:wrap;gap:6px}
.tag{font-size:.68rem;padding:3px 8px;border-radius:6px;font-weight:600;background:#e2e8f0;color:#475569}
.tag.beg{background:#dcfce7;color:#166534}
.tag.int{background:#fef3c7;color:#92400e}
.tag.adv{background:#fee2e2;color:#991b1b}
.card-meta{display:flex;justify-content:space-between;align-items:center;margin-top:14px;padding-top:12px;border-top:1px solid var(--bdr)}
.card-count{font-size:.78rem;color:var(--txt-l);font-weight:600}
.card-arrow{color:var(--pri);font-size:1.2rem;font-weight:700}
.tip{background:linear-gradient(135deg,#eff6ff,#f0f9ff);border-left:4px solid var(--pri);border-radius:0 8px 8px 0;padding:16px 20px;margin:24px 0;font-size:.9rem}
.tip strong{color:var(--pri-d)}
.footer{text-align:center;padding:40px;color:var(--txt-l);font-size:.82rem;border-top:1px solid var(--bdr)}
</style>
</head>
<body>

<div class="hero">
<h1>MySQL 8.0 Complete Learning Guide</h1>
<p>A comprehensive, visual guide to every MySQL 8.0 syntax — from beginner to advanced. Every syntax has code examples AND visual output tables so you can see exactly what happens.</p>
<div class="stats">
<div class="stat"><span class="num">10</span><span class="lbl">Parts</span></div>
<div class="stat"><span class="num">34</span><span class="lbl">Sections</span></div>
<div class="stat"><span class="num">250+</span><span class="lbl">Syntaxes</span></div>
<div class="stat"><span class="num">250+</span><span class="lbl">Output Tables</span></div>
</div>
</div>

<div class="content">

<div class="tip">
<strong>How to use this guide:</strong> Click any part below to open it. Each syntax has a <strong>code example</strong> you can copy into MySQL, and a <strong>visual output table</strong> showing exactly what the result looks like. Examples use real-world data like employees, products, orders, and customers.
</div>

<h2>Foundations</h2>
<div class="grid">
<a class="card" href="mysql-guide/part1-basics.html">
<div class="card-head">
<div class="card-num">1</div>
<div class="card-title">SQL Basics</div>
</div>
<div class="card-desc">The foundation of everything — reading, writing, updating, and deleting data. JOINs to connect tables. Filtering, sorting, and grouping results.</div>
<div class="tags">
<span class="tag beg">Beginner</span>
<span class="tag">SELECT</span>
<span class="tag">INSERT</span>
<span class="tag">UPDATE</span>
<span class="tag">DELETE</span>
<span class="tag">JOIN</span>
<span class="tag">WHERE</span>
<span class="tag">GROUP BY</span>
</div>
<div class="card-meta">
<span class="card-count">29 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>

<a class="card" href="mysql-guide/part2-window-cte-aggregates.html">
<div class="card-head">
<div class="card-num">2</div>
<div class="card-title">Window Functions, CTEs & Aggregates</div>
</div>
<div class="card-desc">Ranking data, comparing rows, temporary named queries, and summarizing data with COUNT, SUM, AVG and more.</div>
<div class="tags">
<span class="tag int">Intermediate</span>
<span class="tag">ROW_NUMBER</span>
<span class="tag">RANK</span>
<span class="tag">LAG/LEAD</span>
<span class="tag">WITH (CTE)</span>
<span class="tag">COUNT</span>
<span class="tag">SUM</span>
</div>
<div class="card-meta">
<span class="card-count">30 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>
</div>

<h2>Functions Library</h2>
<div class="grid">
<a class="card" href="mysql-guide/part3-json-string-functions.html">
<div class="card-head">
<div class="card-num">3</div>
<div class="card-title">JSON & String Functions</div>
</div>
<div class="card-desc">Work with JSON data stored in columns, and manipulate text — concatenation, searching, replacing, regex, formatting.</div>
<div class="tags">
<span class="tag adv">Advanced (JSON)</span>
<span class="tag beg">Beginner (Strings)</span>
<span class="tag">JSON_EXTRACT</span>
<span class="tag">JSON_TABLE</span>
<span class="tag">CONCAT</span>
<span class="tag">REGEXP</span>
</div>
<div class="card-meta">
<span class="card-count">45 functions with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>

<a class="card" href="mysql-guide/part4-datetime-numeric-control.html">
<div class="card-head">
<div class="card-num">4</div>
<div class="card-title">Date/Time, Numeric & Control Flow</div>
</div>
<div class="card-desc">Date calculations, math operations, and conditional logic — IF, CASE, COALESCE for handling different scenarios in queries.</div>
<div class="tags">
<span class="tag beg">Beginner</span>
<span class="tag">NOW</span>
<span class="tag">DATEDIFF</span>
<span class="tag">DATE_FORMAT</span>
<span class="tag">ROUND</span>
<span class="tag">CASE WHEN</span>
<span class="tag">COALESCE</span>
</div>
<div class="card-meta">
<span class="card-count">44 functions with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>
</div>

<h2>Query Techniques</h2>
<div class="grid">
<a class="card" href="mysql-guide/part5-subqueries-sets-indexes.html">
<div class="card-head">
<div class="card-num">5</div>
<div class="card-title">Subqueries, Set Operations & Indexes</div>
</div>
<div class="card-desc">Queries within queries, combining result sets with UNION/INTERSECT/EXCEPT, and making queries fast with indexes.</div>
<div class="tags">
<span class="tag int">Intermediate</span>
<span class="tag">Subquery</span>
<span class="tag">EXISTS</span>
<span class="tag">UNION</span>
<span class="tag">INTERSECT</span>
<span class="tag">CREATE INDEX</span>
<span class="tag">EXPLAIN</span>
</div>
<div class="card-meta">
<span class="card-count">19 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>

<a class="card" href="mysql-guide/part6-tables-constraints-views.html">
<div class="card-head">
<div class="card-num">6</div>
<div class="card-title">Table Management, Constraints & Views</div>
</div>
<div class="card-desc">Creating and modifying tables, enforcing data rules with constraints (PRIMARY KEY, FOREIGN KEY, CHECK), and virtual tables with Views.</div>
<div class="tags">
<span class="tag beg">Beginner</span>
<span class="tag int">Intermediate</span>
<span class="tag">CREATE TABLE</span>
<span class="tag">ALTER TABLE</span>
<span class="tag">FOREIGN KEY</span>
<span class="tag">VIEW</span>
</div>
<div class="card-meta">
<span class="card-count">26 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>
</div>

<h2>Advanced & Administration</h2>
<div class="grid">
<a class="card" href="mysql-guide/part7-procedures-transactions-admin.html">
<div class="card-head">
<div class="card-num">7</div>
<div class="card-title">Procedures, Transactions, Admin & Data Types</div>
</div>
<div class="card-desc">Stored procedures & triggers for automation, transactions for safe multi-step operations, user/permission management, utility commands, and the complete data type reference.</div>
<div class="tags">
<span class="tag adv">Advanced</span>
<span class="tag int">Intermediate</span>
<span class="tag">PROCEDURE</span>
<span class="tag">TRIGGER</span>
<span class="tag">TRANSACTION</span>
<span class="tag">GRANT</span>
<span class="tag">Data Types</span>
</div>
<div class="card-meta">
<span class="card-count">50+ syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>
</div>

<h2>Complete MySQL Reference (Advanced)</h2>
<div class="grid">
<a class="card" href="mysql-guide/part8a-casting-info-inserts-fulltext.html">
<div class="card-head">
<div class="card-num">8A</div>
<div class="card-title">Type Casting, Info Functions, Insert Variations & Full-Text Search</div>
</div>
<div class="card-desc">Type conversion with CAST/CONVERT, system info functions (UUID, LAST_INSERT_ID), advanced INSERT patterns (UPSERT, REPLACE INTO), and full-text search with MATCH AGAINST.</div>
<div class="tags">
<span class="tag int">Intermediate</span>
<span class="tag">CAST</span>
<span class="tag">LAST_INSERT_ID</span>
<span class="tag">ON DUPLICATE KEY</span>
<span class="tag">MATCH AGAINST</span>
<span class="tag">UUID</span>
</div>
<div class="card-meta">
<span class="card-count">26 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>

<a class="card" href="mysql-guide/part8b-encryption-bits-prepared-cursors-errors.html">
<div class="card-head">
<div class="card-num">8B</div>
<div class="card-title">Encryption, Binary, Prepared Statements, Cursors & Error Handling</div>
</div>
<div class="card-desc">Hashing (MD5, SHA2), encryption (AES), bitwise operations, prepared statements for safe queries, cursors for row-by-row processing, and error handling in procedures.</div>
<div class="tags">
<span class="tag adv">Advanced</span>
<span class="tag">AES_ENCRYPT</span>
<span class="tag">SHA2</span>
<span class="tag">BIN/HEX</span>
<span class="tag">PREPARE</span>
<span class="tag">CURSOR</span>
<span class="tag">SIGNAL</span>
</div>
<div class="card-meta">
<span class="card-count">38 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>

<a class="card" href="mysql-guide/part8c-flow-events-partitions-locks-misc.html">
<div class="card-head">
<div class="card-num">8C</div>
<div class="card-title">Flow Control, Events, Partitioning, Locking & Miscellaneous</div>
</div>
<div class="card-desc">Procedural loops (WHILE, REPEAT, LOOP), scheduled events, table partitioning for large datasets, row/table locking for concurrency, and essential maintenance commands.</div>
<div class="tags">
<span class="tag adv">Advanced</span>
<span class="tag">WHILE/LOOP</span>
<span class="tag">CREATE EVENT</span>
<span class="tag">PARTITION BY</span>
<span class="tag">FOR UPDATE</span>
<span class="tag">OPTIMIZE TABLE</span>
</div>
<div class="card-meta">
<span class="card-count">52 syntaxes with outputs</span>
<span class="card-arrow">&rarr;</span>
</div>
</a>
</div>

<div class="tip" style="margin-top:40px">
<strong>Recommended learning order:</strong> Start with Part 1 (Basics) — this is the foundation for everything. Then Part 4 (Date/Time & Control Flow) since you'll use these daily. Then Part 2 (Window Functions & Aggregates) for reporting. Parts 3, 5, 6 can be learned as needed. Part 7 when you're comfortable with basics. Parts 8A-8C are the complete advanced reference — tackle these last when you want to master everything MySQL has to offer.
</div>

</div>

<div class="footer">
MySQL 8.0 Complete Learning Guide<br>
A free, open learning resource &mdash; February 2026
</div>

</body>
</html>