SQL Databases Using SQLAlchemy: Getting Started

There are many advantages to using SQLAlchemy including using native Python language constructs for queries transactions and stored procedures and easily porting code between database servers. You begin this course by installing MySQL on both Windows and Macintosh platforms. Youll then learn how to access a database from SQLAlchemy using the create_engine method and how to specify the driver dialect and server information correctly. You move on to creating database tables as well as associated constraints from Python using SQLAlchemys Core API and the Table abstraction. Youll then query that table using a fluent-style API from SQLAlchemys SQL Expression Language. Youll also learn how to specify primary key unique and not null constraints. At the end of the course youll have a solid handle on basic functionalities of the core APIs of SQLAlchemy.