Python Data Persistence Magazine - First Edition 2019

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.

Table of Contents

1. Getting Started

2. Program Flow Control

3. Structured Python

4. Python – OOP

5. File IO

6. Object Serialization

7. RDBMS Concepts

8. Python DB-API

9. Python – SQLAlchemy

10. Python and Excel

11. Python – PyMongo

12. Python – Cassandra

Appendix A: Alternate Python Implementations

Appendix B: Alternate Python Distributions

Appendix C: Built-in Functions

Appendix D: Built-in Modules

Appendix E: Magic Methods

Appendix F: SQLite Dot Commands

Appendix G: ANSI SQL Statements

Appendix H: PyMongo API Methods

Appendix I: Cassandra CQL Shell Commands

About the Author

Malhar Lathkar is an Independent software professional / Programming technologies trainer/E-Learning Subject matter Expert. He is a of Director Institute of Programming Language Studies, having an academic experience of 33 years. His expertise is in Java, Python, C#, IoT, PHP, databases.

His linkedIn: linkedin.com/in/malharlathkar

His blog: indsport.blogspot.comDesigned 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.

Table of Contents

1. Getting Started

2. Program Flow Control

3. Structured Python

4. Python – OOP

5. File IO

6. Object Serialization

7. RDBMS Concepts

8. Python DB-API

9. Python – SQLAlchemy

10. Python and Excel

11. Python – PyMongo

12. Python – Cassandra

Appendix A: Alternate Python Implementations

Appendix B: Alternate Python Distributions

Appendix C: Built-in Functions

Appendix D: Built-in Modules

Appendix E: Magic Methods

Appendix F: SQLite Dot Commands

Appendix G: ANSI SQL Statements

Appendix H: PyMongo API Methods

Appendix I: Cassandra CQL Shell Commands

About the Author

Malhar Lathkar is an Independent software professional / Programming technologies trainer/E-Learning Subject matter Expert. He is a of Director Institute of Programming Language Studies, having an academic experience of 33 years. His expertise is in Java, Python, C#, IoT, PHP, databases.

His linkedIn: linkedin.com/in/malharlathkar

His blog: indsport.blogspot.comDesigned 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.

Table of Contents

1. Getting Started

2. Program Flow Control

3. Structured Python

4. Python – OOP

5. File IO

6. Object Serialization

7. RDBMS Concepts

8. Python DB-API

9. Python – SQLAlchemy

10. Python and Excel

11. Python – PyMongo

12. Python – Cassandra

Appendix A: Alternate Python Implementations

Appendix B: Alternate Python Distributions

Appendix C: Built-in Functions

Appendix D: Built-in Modules

Appendix E: Magic Methods

Appendix F: SQLite Dot Commands

Appendix G: ANSI SQL Statements

Appendix H: PyMongo API Methods

Appendix I: Cassandra CQL Shell Commands

About the Author

Malhar Lathkar is an Independent software professional / Programming technologies trainer/E-Learning Subject matter Expert. He is a of Director Institute of Programming Language Studies, having an academic experience of 33 years. His expertise is in Java, Python, C#, IoT, PHP, databases.

His linkedIn: linkedin.com/in/malharlathkar

His blog: indsport.blogspot.comDesigned 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.

Table of Contents

1. Getting Started

2. Program Flow Control

3. Structured Python

4. Python – OOP

5. File IO

6. Object Serialization

7. RDBMS Concepts

8. Python DB-API

9. Python – SQLAlchemy

10. Python and Excel

11. Python – PyMongo

12. Python – Cassandra

Appendix A: Alternate Python Implementations

Appendix B: Alternate Python Distributions

Appendix C: Built-in Functions

Appendix D: Built-in Modules

Appendix E: Magic Methods

Appendix F: SQLite Dot Commands

Appendix G: ANSI SQL Statements

Appendix H: PyMongo API Methods

Appendix I: Cassandra CQL Shell Commands

About the Author

Malhar Lathkar is an Independent software professional / Programming technologies trainer/E-Learning Subject matter Expert. He is a of Director Institute of Programming Language Studies, having an academic experience of 33 years. His expertise is in Java, Python, C#, IoT, PHP, databases.

His linkedIn: linkedin.com/in/malharlathkar

His blog: indsport.blogspot.com