SQL Pocket Primer

Master SQL and MySQL with this detailed guide for data professionals, featuring practical examples and in-depth explanations.Key FeaturesComprehensive coverage of SQL and MySQLPractical examples and exercisesIntroduction to NoSQL and SQLiteBook DescriptionAs 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 MySQL as the primary RDBMS. It features Python-based code samples for accessing data from MySQL tables in Pandas data frames and Java-based samples for data access in MySQL, along with handling XML and JSON documents. The book also introduces NoSQL, with an overview of MongoDB, 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.What you will learnInstall and configure MySQL effectivelyExecute SQL statements proficientlyCreate and manage database tablesUtilize joins, views, and subqueriesImplement various SQL functionsWork with NoSQL and SQLite databasesWho this book is forIdeal for data scientists and machine learning engineers with basic SQL knowledge. Readers should have experience executing SQL statements and a general understanding of databases.