Books like The practical SQL handbook by Judith S. Bowman

Sams Teach Yourself SQL in 10 Minutes—2nd Edition is a hands‑on tutorial that teaches SQL fundamentals and advanced techniques through bite‑size, 10‑minute lessons.

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.

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, hands‑on guide to SQL that teaches core concepts through running case studies and exercises, supporting Oracle 11g, Access 2007, and MySQL.

The Most Comprehensive SQL Resource AvailableGet in-depth details on all the powerful features and capabilities of SQL inside this one-stop guide. Featuring broad coverage of every aspect of this leading database language, this book provides you with an overview of SQL then shows you how to retrieve and update data, program with SQL, use stored procedures, and much more. Covering emerging standards and new related technologies including XML, Web services, EJB, J2EE, and JDBC, this book will help you gain the knowledge and essential skills you need to effectively work with SQL. Comprehensive, organized, and practical, this is the ultimate guide to understanding and using SQL.Master SQL basics and use simple, multi-table, and summary queries Understand key concepts and the latest developments in relational database technology Set up and manage SQL-based databases and write programs to access them Create and use the sample database to run the SQL query examples in the book Find out about Xpath, Xquery, and other XML-based database query standards Discover how J2EE-based applications relate to data management Use and program SQL databases with application servers to create powerful Web applications Preview the future of SQL—including MySQL and the impact of XML and Web ServicesNOTE: due to the large amount of text and graphics, this eBook file is 18.3 MG. We recommend that you download this eBook using the fastest Internet connection at your disposal, otherwise you may notice a longer downloading time than usual.

A practical guide that introduces SQL Server querying for readers with limited prior knowledge, covering database design basics, core objects, and advanced techniques like data retrieval, manipulation, and transactions.