Mastering SQLAlchemy

Interact with databases with Python's "batteries included" library: SQLAlchemy. Managing database connections & sessions with minimal boilerplate, create data models, and query your data using the built-in ORM. Learn to leverage built-in integrations with popular libraries such as Flask and Pandas to make database interactions trivial.

What You'll Learn

  • Spin up database connections with minimal effort
  • Write data models for MVC applications
  • Fetch and modify data via the ORM or plaintext SQL queries
  • Define one-to-one, one-to-many, and many-to-many relationships via the ORM
  • Perform JOINs and aggregations on data models

For those who...

  • Have an understanding of Python
  • Grasp the underlying concepts of relational databases
  • Prefer to handle application data layers via an ORM

Tags

Python Software DevOps Data Engineering Architecture Pandas Excel Data Analysis SQL Data Science REST APIs JavaScript Flask Code Snippet Corner AWS NodeJS Google Cloud Frontend MySQL Apache Data Vis BI NoSQL GraphQL Spark PostgreSQL ExpressJS ETL Pipelines Tableau PowerBI SQLAlchemy GatsbyJS Powerpivot Machine Learning Automation Big Data Atlassian Mapbox Golang Scraping JAMStack Data Warehouses Plotly Docker Concurrency Hashicorp Django ReactJS SaaS Products Frameworks Java FastAPI Terraform Microsoft

Series'

Data Analysis with Pandas 11
Build Flask Apps 11
Learning Apache Spark 6
Google Cloud Architecture 6
Mastering SQLAlchemy 4
GraphQL Tutorials 4
Welcome to SQL 4
Working with MySQL 4
Mapping Data with Mapbox 3
Web Scraping With Python 2
Python Concurrency with Asyncio 2
Getting Started with Django 2