Books like Sams teach yourself SQL in 10 minutes by Ben Forta

A practical, 7th‑edition guide that teaches SQL from the ground up, covering design, security, data retrieval, and new SQL/XML 2008 features across Access, Oracle, SQL Server, and MySQL.

SQL in a Nutshell is a practical reference that details the SQL99 standard and its application across major databases—including Microsoft SQL Server 2000, Oracle 8i, MySQL, and PostgreSQL 7.0—using clear syntax examples.

Updated for the latest database management systems, this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations, annotated examples, and exercises to let you practice the skills you learn.

Learn standard SQL with hands‑on examples, exercises, and solutions that keep you actively practicing the fundamentals, from beginner concepts to more advanced techniques.

Such textbooks are very necessary, because if you delve into the topic, you can understand many complexities. I also want to recommend a useful article where you learn about mysql optimize table https://www.devart.com/dbforge/mysql/studio/optimize-mysql-table.html . By the way, the powerful dbForge Studio integration environment will help you with this, as it contains a complete set of necessary tools.

A practical, 24‑hour, one‑hour‑per‑lesson guide that builds a programmer from PHP fundamentals to advanced features, covering forms, cookies, authentication, databases, system components, email, LDAP, and sockets.

Learn to query, update, and maintain relational databases with the latest edition of Sams Teach Yourself SQL in 21 Days, featuring up-to-date MySQL and Oracle examples, object‑oriented SQL, ODBC, JDBC, and embedded SQL.

A reader's first book for learning SQL, the structured query language for most major database systems. Teaches SQL quickly and easily for those with little or no programming experience. The end user's path to proficiency in SQL. New code examples written to an open source database like MySQL; avoids complexity and teaches practical basics. Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database. Ryan Stephens and Ron Plew are President and Vice President of Perpetual Technologies, Inc, where their duties include Oracle® database administration and consulting and training in Oracle, SQL and UNIX. They have both been teaching at the college level for over five years as adjunct professors at Indiana University-Purdue University in Indianapolis. Both are Oracle Certified Professionals. Ryan and Ron have co-authored the following successful books: Sams Teach Yourself SQL in 24 Hours, Second Edition, 0672318997, Sams, 3/00, and Sams Teach Yourself SQL in 21 Days, Third Edition, 0672316749, Sams, 12/99.

Sams Teach Yourself UNIX in 24 Hours, Third Edition is designed to take users from a novice to an accomplished user in just 24 one-hour sessions. Written by an expert in the field, the book starts off with an introduction to UNIX, then covers file handling, pipes and filters, the vi and emacs text editors, shells, job control, permissions, printing, and connecting to remote computers via the Internet. The book also discusses UNIX programming and includes a special appendix on working with the Apache Server.