Pocket Primer Series Read Description

SQL Pocket Primer

Paperback
March 2022
9781683928140
More details
  • Publisher
    Mercury Learning and Information
  • Published
    16th March
  • ISBN 9781683928140
  • Language English
  • Pages 292 pp.
  • Size 6" x 9"
$41.95
Lib E-Book

Library E-Books

We are signed up with aggregators who resell networkable e-book editions of our titles to academic libraries. These editions, priced at par with simultaneous hardcover editions of our titles, are not available direct from Stylus.

These aggregators offer a variety of plans to libraries, such as simultaneous access by multiple library patrons, and access to portions of titles at a fraction of list price under what is commonly referred to as a "patron-driven demand" model.

March 2022
9781683928133
More details
  • Publisher
    Mercury Learning and Information
  • Published
    9th March
  • ISBN 9781683928133
  • Language English
  • Pages 292 pp.
  • Size 6" x 9"
$109.95
E-Book (ePub)
March 2022
9781683928126
More details
  • Publisher
    Mercury Learning and Information
  • Published
    9th March
  • ISBN 9781683928126
  • Language English
  • Pages 292 pp.
  • Size 6" x 9"
$34.95

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 RDBMS
  • Introduces NoSQL, presents an overview of MongoDB, and SQLite--an open-source RDBMS available on mobile devices
  • Features companion files with source code and figures from the book

1: Introduction to RDBMS and MySQL

2: Working with SQL and MySQL

3: Joins, Views, and Subqueries

4: Assorted SQL Functions

5: NoSQL, SQLite, and Python

6: Miscellaneous Topics

Appendix: Introduction to Probability and Statistics

Index

Oswald Campesato

Oswald Campesato (San Francisco, CA) is an adjunct instructor at UC-Santa Clara and specializes in Deep Learning, Java, Android, and TensorFlow. He is the author/co-author of over twenty-five books including TensorFlow 2 Pocket Primer, Python 3 for Machine Learning, and the NLP Using R Pocket Primer (all Mercury Learning).

Computer Science; Data Analytics; Programming; Machine Learning; Developers; SQL