MySQL Notes for Professionals
GoalKicker
Nearly 200 pages of practical MySQL know-how: data types, joins, indexes, stored routines, triggers, replication, backups with mysqldump, user permissions, and performance tuning.
Loading the book...
Keep reading
- Databases: MySQL Introduction
A course workbook with step-by-step exercises. You set up a MySQL server, create databases and tables, write queries, link tables with keys, and manage users and privileges.
Verified PDF · Secure download - Postgres: The First Experience
A small book for your first steps with PostgreSQL. It covers installation on Linux and Windows, writing queries on a demo database, transactions, basic server setup, and useful extensions.
Verified PDF · Secure download - PostgreSQL Notes for Professionals
A compact reference with working examples: data types, window functions, common table expressions, JSON support, triggers, PL/pgSQL, backups, roles, and high availability.
Verified PDF · Secure download - PostgreSQL 14 Internals
A deep look at how PostgreSQL works under the hood. It explains isolation and MVCC, the buffer cache and WAL, locks, query execution and planning, and every index type from B-tree to BRIN.
Verified PDF · Secure download
