About the Authors
Table of Contents
Learn Database Programming with Python
MODULE 1: Python MySQL
PART 1: Introduction
1: Install MySQL connector package in Python
2: MySQL-Connector-Python module in Python
What is MYSQL Connector/Python?
Installing module
3: Connect MySQL database using MySQL
Connecting to the Database
PART 2: Python MySQL Queries
1: Python MySQL – Create Database
2: MySQL Create Table
Table
3: Python MySQL – Insert into Table
Inserting data
4: Python MySQL – Select Query
Select Query
5: Python MySQL – Where Clause
Where Clause In Python
Python3
6: Python MySQL – Order By Clause
OrderBy Clause
7: Python MySQL – Delete Query
Deleting query from tables
8: Python MySQL – Drop Table
Drop Table Command
9: Python MySQL – Update Query
Update Clause
10: Python MySQL – Limit Clause
LIMIT Clause Of SQL
11: Python MySQL – Join
JOIN Clause Of SQL
12: Commit & RollBack Operation in Python
MODULE 2: Python SQLite
PART 1: Introduction
1: Introduction to SQLite in Python
Serverless
Self-Contained
Zero-Configuration
Transactional
Single-Database
Understanding of SQLite Module Working in Python
2: Python SQLite – Connecting to Database
Connecting to the Database
3: SQLite Datatypes and its Corresponding Python Types
Storage Class in SQLite
Corresponding Python Datatypes
Python3
PART 2: Python SQLite Queries
1: Python SQLite – Cursor Object
Cursor Object
2: Python SQLite – Create Table
3: Python SQLite – Insert Data
4: Python SQLite – Select Data from Table
Read All Rows:
Read Some Rows:
Read Only one Row:
5: Python SQLite – WHERE Clause
WHERE Clause in SQLite using Python:
6: Python SQLite – ORDER BY Clause
7: Python SQLite – LIMIT Clause
8: Python SQLite – JOIN Clause
Join Clause
Creating a Database
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
9: Python SQLite – Deleting Data in Table
10: Python SQLite – DROP Table
11: Python SQLite – Update Data
12: Python SQLite – Update Specific Column
MODULE 3: Python JSON
PART 1: Introduction
1: JavaScript JSON
What is JSON?
What is it used for?
Why JSON?
Characteristics of JSON
JSON Syntax Rules
Convert a JSON Text to a JavaScript Object
2: JSON | Data Types
3: Working With JSON Data in Python
Serializing JSON:
Example: Serialization
Deserializing JSON:
Example: Deserialization
Encoding and Decoding:
Command-Line Usage
Searching through JSON with JMESPath
Real-World Example:
PART 2: Python JSON – Reading and Writing
1: Reading and Writing JSON to a File in Python
Writing JSON to a file in Python
Method 1: Writing JSON to a file in Python using json.dumps()
Method 2: Writing JSON to a file in Python using json.dump()
Reading JSON from a file using Python
Reading JSON from a file using json.load()
2: Append to JSON file using Python
Functions Used:
PART 3: Parsing JSON
1: Parse Data From JSON into Python
2: Convert Python Dictionary To JSON
Methods used to Convert Python to JSON and Writing JSON
Convert Dictionary Python to JSON File using json.dump()
Convert Python to JSON object Using dumps() function
Difference Between Dictionary and JSON
3: Convert JSON to string
4: Ways to convert string to json object
Convert String to JSON Object in Python
Convert String to JSON Using json.loads() Method in Python
Convert String to JSON Using eval() Method in Python
Convert String to JSON Using ast.literal_eval() Method
5: Convert JSON data Into a Custom Python Object
PART 4: Python JSON – Serializing and Deserializing
1: Serializing JSON data in Python
json.dump()
json.dumps()
2: json.dump() in Python
3: json.dumps() in Python
Json.dumps()
4: Difference between json.dump() and json.dumps()
json.dumps()
Python3
Python3
5: Deserialize JSON to Object in Python
6: json.load() in Python
json.load()
7: json.loads() in Python
What are JSON loads () in Python?
Python json.loads() method
JSON Parsing using json.load() in Python
Iterating over JSON Parsed Data using json.load() in Python
8: Difference Between json.load() and json.loads()
json.load()
json.loads()
9: Encoding and Decoding Custom Objects in Python-JSON
Getting Started
Encoding and Decoding Custom Objects
10: Serialize and Deserialize complex JSON in Python
Complex Objects
Conclusion