How to use SQL in Python

How to use SQLite in python, how to import data and perform different operations on it. SQL is no doubt the industry standard for querying databases and python brings power of simple coding, these both got together when we use SQLite in python.
#SQL, #python, #sqlite, #use