Intro to SQL and Bottle for Building AI Apps in Python (Full Day)

https://www.youtube.com/watch?v=AJ1qw8xYuxM

Code and Workbook on Github

https://github.com/SiliconDojo/In-Person-Classes/tree/main/Intro%20to%20SQL%20and%20Bottle%20for%20Building%20AI%20Apps%20in%20Python%20(Full%20Day)

Description

Our previous full day class taught you to use Python and Ollama to build AI powered scripts. Now we will take that to the next level by adding SQL so that you project can store records, and by using the Bottle Web App framework so that you can build a GUI web application.

By the end of the class you will be able to build a useful AI powered web app that demonstrates the key components to an AI "Stack"

This class will go over:

• What are Relational Databases

• What is SQLite

• How to create databases, tables and records in SQL

• How to modify and delete databases, tables and record in SQL

• How to JOIN tables in SAL

• How to use Python to interact with a SQL database

• What Bottle and Web App frameworks are

• How the MVC model works in Bottle

• How to build and run web apps with Bottle

• Dealing with Static Files in Bottle

• Template and Template Languages in Bottle

• How to connect Bottle to Ollama for AI functionality

• How to deploy a Bottle Web App to production.