FastAPI and SQLModel are two of the hottest new Python technologies for developing asynchronous APIs with modern Python. If you're struggling with wrapping your head around how it all works, this course is for you. Here you'll learn all the most important fundamentals for creating APIs that support all database CRUD operations for adding, editing, and deleting database tables and rows.

The course takes a very hands-on approach. That’s because most of us learn by doing. All of the code generated in the course is also available for download, so you can use it for future reference when trying to remember how to accomplish some goal. Topics and techniques covered include:

· Creating SQLModel databases and tables

· Creating FastAPI routes and functions for posting, retrieving, updating, and deleting data

· Customizing API Request and Response Schemas

· Using RegEx validation in SQLModel

· Designing re-usable server-side validators

· Sorting and Searching with SQLModel

· Working with virtual deletes and undeletes

· Joining tables

· Customizing column names in responses

· Using HTML forms for database interactions

· Debug FastAPI and SQLModel with VS Code Breakpoints

In short, the course is all about learning how to do all the common day-to-day operations found in apps that allow users to interact with databases. All the code in the course is also available for download, and organized in a way to help students look up the code they need, on-the-fly, as-needed with minimum fuss.

Students need not already be familiar with FastAPI or SQLModel. However, students should already be familiar with basic Python programming. Some familiarity with SQL and databases also helpful.