This SQLAlchemy ORM crash part 2 course shows you how to use advanced SQLAlchemy features and continues where the first part left off. In this course we cover Abstract Models, declared attributes, adding columns to models, SQL functions such as Count, Sum, Average, Coalesce, Case, Aliasing tables, and Subqueries.
Chapters:
00:00:00 Intro
00:00:50:02 Tools Used
00:01:40:05 Activating environment & Installing dependencies
00:02:30:07 Creating Models
00:17:23:16 Creating the database tables
00:19:38:13 Seeding the database
00:25:05:23 Adding columns
00:28:44:18 SQL Count
00:32:18:08 SQL Average
00:34:43:13 SQL Coalesce
00:39:12:03 SQL Sum
00:41:19:17 SQL Subquery
00:48:00:23 SQL Case
00:54:09:05 SQL Alias (aliased)
Code:
https://github.com/demoskp/sqlalchemy-crash-course-part-2
Personal website:
http://www.petsas.consulting
