Lathkar M. Python Data Persistence: With SQL and NOSQL Databases

India: BPB Publications, 2019. — 203 p. — ISBN13: 978-9388511759.Designed to provide an insight into the SQL and MySQL database concepts using python.
Key Features
A practical approach
Ample code examples
A Quick Start Guide to Python for beginners
Description
Python is becoming increasingly popular among data scientists. However, analysis and visualization tools need to interact with the data stored in various formats such as relational and NOSQL databases.
This book aims to make the reader proficient in interacting with databases such as MySQL, SQLite, MongoDB, and Cassandra.
This book assumes that the reader has no prior knowledge of programming. Hence, basic programming concepts, key concepts of OOP, serialization and data persistence have been explained in such a way that it is easy to understand. NOSQL is an emerging technology. Using MongoDB and Cassandra, the two widely used NOSQL databases are explained in detail.
The knowhow of handling databases using Python will certainly be helpful for readers pursuing a career in Data Science.
What will you learn
Python basics and programming fundamentals
Serialization libraries pickle, CSV, JSON, and XML
DB-AP and, SQLAlchemy
Python with Excel documents
Python with MongoDB and Cassandra
Who this book is for
Students and professionals who want to become proficient at database tools for a successful career in data science.Getting Started
Program Flow Control
Structured Python
Python - OOP
File IO
Object Serialization
RDBMS Concepts
Python DB-API
Python - SQLAlchemy
Python and Excel
Python – PyMongo
Python - Cassandra
Appendixes
Alternate Python Implementations
Alternate Python Distributions
Built-in Functions
Built-in Modules
Magic Methods
SQLite Dot Commands
ANSI SQL Statements
PyMongo API Methods
Cassandra CQL Shell Commands