Gen-AI Developer Classroom notes 18/Oct/2025

SQL Alchmey

• Engine:
  • Database connector & Execution engine
  • In addition to sqlalachemy wwe will be installing driver
  • Connection URL
    • mysql: “
• Session
• Connection

Defining entities/models

• Here we define a class for a table

python-dotenv

• lets add this package

uv add python-dotenv

• Create a file called as .env in the root folder

SQL Alchemy to store user details

• Lets create a new project

uv add sqlalchemy

• Create a jupyternotebook demonstration.ipynb Refer Here

Institute

• Institute has multiple courseofferings (like AI, Ops, Dev, data)
• A course offering will have multiple courses (AI will have GenAI Development, Ops will have DevOps and Cloud, Dev will have full stack python, full stack java )
• A Student can be enrolled into multiple courses
• A faculty can teach multiple courses
• Classes to be created are

Institute
CourseOffering
Course
Student
Enrollement (Student To Course)
FaculyEnrollMent (Faculty to Course)