Here is my SQL portfolio, where you can find an overview of how to implement SQL queries and commands in Python. I make use of PostgresSQL to manage the databases used throughout the examples. I also use Psycopg2 (which is the most common PostgreSQL adapter for Python) to connect Python with the databases and Pandas to present the results.