SQL Pocket Primer / / Oswald Campesato.

• VerfasserIn: Campesato, Oswald,
• Place / Publishing House: Dulles, VA : : Mercury Learning and Information, , [2022]; ©2022
• Year of Publication: 2022
• Language: English
• Series: Pocket Primer
• Physical Description: 1 online resource (292 p.)

As part of the best-selling Pocket Primer series, this book is primarily for data scientists and machine learning engineers who want to expand their current knowledge of SQL using MySQL as the primary RDBMS. It includes Python-based code samples to access data from a MySQL table in a Pandas data frame and Java-based code samples for accessing data in a MySQL database, along with XML documents and JSON documents. The book also introduces NoSQL, presents an overview of MongoDB, and SQLite--an open-source RDBMS available on mobile devices. The final chapter of the book covers a diverse set of miscellaneous topics, such as normalization, schemas, database optimization, and performance. Numerous code samples and listings are included to support myriad topics. Companion files with source code and figures are available from the publisher. FEATURES:Covers extensive topics related to SQL, using MySQL as the primary RDBMSIntroduces NoSQL, presents an overview of MongoDB, and SQLite--an open-source RDBMS available on mobile devicesFeatures companion files with source code and figures from the book

Table of Contents

Frontmatter -- Contents -- Preface -- Chapter 1: Introduction to RDBMSs and MySQL -- Chapter 2: Working with SQL and MySQL -- Chapter 3: Joins, Views, and Subqueries -- Chapter 4: Assorted SQL Functions -- Chapter 5: NoSQL, SQLite, and Python -- Chapter 6: Miscellaneous Topics -- Appendix: Introduction to Probability and Statistics -- Index