Master SQL and MySQL with this detailed guide for data professionals, featuring practical examples and in-depth explanations.

Key Features

Comprehensive coverage of SQL and MySQL

Practical examples and exercises

Introduction to NoSQL and SQLite

Book Description

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 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 learn

Install and configure MySQL effectively

Execute SQL statements proficiently

Create and manage database tables

Utilize joins, views, and subqueries

Implement various SQL functions

Work with NoSQL and SQLite databases

Who this book is for

Ideal for data scientists and machine learning engineers with basic SQL knowledge. Readers should have experience executing SQL statements and a general understanding of databases.