Python Database - 2 Day

Relational Databases and Python - Concepts & Resources

• relational data model, data normalization, ERD (Entity-Relationship)
• SQL, CRUD (Create, Read, Update, Delete), DDL (Data Definition Language)
• Object-Relational Mapping (ORM)
• Python Object DBs

SQLAlchemy

• the toolkit
• batch and high-performance concepts
• ORM case-study

Case-Study: Data Management in Python (from flat files to an SQL DB)

A project in MySQL

• Installation of Database and Connector
• Python Database API
• Database Creation
• CRUD run through

Some Python SQL Libraries: CRUD run through in SQLite and PostgreSQL

PyODBC

• ODBC Drivers
• ODBC Connection Configuration
• getting data into Pandas

Pandas SQL

• pandas.read_sql_query()
• pandas.read_sql_table()
• pandas.read_sql()
• pandas.DataFrame.to_sql()
• reading/writing data in chunks

Python Object Databases

• ZODB
• pickledb
• tinydb