SQL Databases Using SQLAlchemy: Manipulating Data

When you need access to data in a relational database while coding in Python SQLAlchemy provides an ideal abstraction layer. SQLAlchemy supports several database types. In this course youll work with MySQL. Youll start by learning how to construct and invoke select-from-where queries from Python using the SQLAlchemy core API. Youll then use the and_ or_ and not_ functions from the Expressions API before learning how to alter tables by adding and dropping columns and constraints. Following on youll practice deleting data and drop tables from SQLAlchemy. Youll then specify foreign key constraints to define parent-child relationships. To finish off youll perform simple select-from-where queries with logical and relational operators from SQLAlchemy add and drop columns and constraints and define foreign-key constraints and parent-child relationships.