Course Code: pythdataonedaybesp
Duration: 7 hours
Course Outline:

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)

SQLAlchemy

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

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

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

Pandas SQL

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