Building Web Applications with FastAPI and Databases Training Course

Module I: Fundamentals of Web Applications and APIs
1. Web application architecture – client-server model
2. HTTP protocol mechanisms: requests, responses, resources
3. Basic concepts: URI, URL, endpoint
4. Overview of popular API interfaces and methods for communicating with them
5. Postman as an HTTP client
6. Type annotations in Python

Module II: The FastAPI Framework – Fundamentals
1. First application in FastAPI
2. Defining routes and routing mechanisms
3. Handling POST requests – request body and validation with Pydantic
4. Path parameters
5. Handling HTTPException exceptions and the 404 error code
6. Using JSONResponse and configuring default status codes
7. Implementing DELETE requests and the 204 No Content response
8. Updating resources using the PUT method
9. Automatically generated documentation (Swagger UI and ReDoc)
10. Defining response schemas
11. Using the requests library for API communication
12. Advanced Pydantic features

Module III: Database Integration
1. Configuring database connections in the project
2. The Psycopg library – basics of PostgreSQL management
3. SQLAlchemy ORM – object-relational mapping

Module IV: CRUD
1. CRUD principles – analysis of individual operations
2. Implementing database operations using SQLAlchemy
3. Query parameters – sorting and filtering data
4. Testing endpoints using TestClient

Module V: Advanced Application Aspects
1. Security – password hashing and storage
2. User authentication and authorization mechanisms
3. A simple Python-based frontend for the API