Sanjeev Thiyagarajan teaches how to build, test, and deploy a full-featured REST API using Python, FastAPI, and PostgreSQL.
Learn Python API development in one of the most comprehensive courses ever on the topic. You will build a full-fledged API in Python using FastAPI. You will learn the fundamentals of API design including routes, serialization/deserialization, schema validation, and models. You will also learn about SQL, testing with pytest, and how to build out a CI/CD pipeline using GitHub actions.
💻 Code: github.com/Sanjeev-Thiyagarajan/fastapi-course
✏️ Course from Sanjeev Thiyagarajan. Check out his channel: youtube.com/channel/UC2sYgV-NV6S5_-pqLGChoNQ
⭐️ Course Contents
Intro
Project Overview
Mac Python Installation
Mac VS Code install and setup
Windows Python Installation
Windows VS Code install and setup
Python virtual Env Basics
Virtual Env on windows
Virtual Env on Mac
Install dependencies w/ pip
Starting FastAPI
Path Operations
Intro toman
HTTP Requests
Schema Validation with Pydantic
CRUD Operations
Storing in Array
Creating
Postman Collections & saving requests
Retrieve One
Path order Matters
Changing response Status Codes
Deleting
Updating
Automatic Documentation
Python packages
Database Intro
Postgres Windows Install
Postgres Mac Install
Database Schema & Tables
Managing Postgres with PgAdmin GUI
Your first SQL Query
Filter results with "where"
SQL Operators
IN
Pattern matching with LIKE
Ordering Results
LIMIT & OFFSET
Modifying Data
Setup App Database
Connecting to database w/ Python
Database CRUD
ORM intro
SQLALCHEMY setup
Adding CreatedAt Column
Get All
Create
Get by ID
Delete
Update
Pydantic vs ORM Models
Pydantic Models Deep Dive
Response Model
Creating Users Table
User Registration Path Operation
Hashing Passwords
Refractor Hashing Logic
Get User by ID
FastAPI Routers
Router Prefix
Router Tags
JWT Token Basics
Login Process
Creating Token
OAuth2 PasswordRequestForm
Verify user is Logged In
Fixing Bugs
Protecting Routes
Test Expired Token
Fetching User in Protected Routes
Postman advanced Features
SQL Relationship Basics
Postgres Foreign Keys
SQLAlchemy Foreign Keys
Update Schema to include User
Assigning Owner id when creating new
Delete and Update only your own
Only Retrieving Logged in User's
Sqlalchemy Relationships
Query Parameters
Cleanup our main.py file
Env Variables
Vote/Like Theory
Votes Table
Votes Sqlalchemy
Votes Route
SQL Joins
Joins in SqlA
Why it's here
2 people recommend this
What people say. Recommended as a comprehensive beginner-friendly course on building APIs with FastAPI.
Got my designation changed to an Associate Data Engineer.
As the title says, I am now an Associate Data Engineer from being a Junior Data Analyst. I don’t have any software engineering background. All the knowledge I have came from Udemy courses, YouTube videos and books.
I am proficient in Python and SQL. I mostly use BigQuery for my work and dbt along with it. Python comes into play, if I need to do some kind of automation. I can write R codes also. I maintain data pipelines using xplenty (intergrate.io).
I want to learn the necessary knowledge so I can add value to the role I have. I was looking into some LinkedIn profiles of Data Engineers and what they do. Based on those, I thought…
On “GitHub - bootdotdev/curriculum: A free-to-audit CS curriculum for backend developers”
link to this video I found this on YouTube which might have things you are looking. Of course this is also geared towards beginners and may not cover all that you want but it does cover a fair bit. Might be helpful for some one else as well.
