As part of the best-selling Pocket Primer series, this book is designed for data scientists and machine learning engineers seeking to deepen their SQL knowledge using My SQL as the primary RDBMS. It features Python-based code samples for accessing data from My SQL tables in Pandas data frames and Java-based samples for data access in My SQL, along with handling XML and JSON documents.
The book also introduces No SQL, with an overview of Mongo DB, and SQLite, an open-source RDBMS for mobile devices. The final section covers diverse topics like normalization, schemas, database optimization, and performance. This comprehensive approach ensures a well-rounded understanding of SQL and related technologies, enhancing data manipulation and database management skills.
Numerous code samples and listings throughout the book support the various topics covered. Companion files with source code and figures are available from the publisher, making this an essential resource for advancing your SQL proficiency and database management expertise.