Intro to AI with SQL - Add Databases to Your Intelligent Projects
Details
NOTE: Our classes are for any one of any level who is interested in the subject. The first half will be seminar, and the second half will be hands on writing code. (You can leave after the seminar if you like). If you want to build the examples just bring a Windows/Mac/Linux laptop with preferably over 8 GB of RAM.
This will be an introductory class on SQL and how to add a relational database to your AI projects. We will be using Python and SQLite to build simple AI apps that are able to have a record store with a relational database. We will show how you can create cacheing mechanisms, memory, and much more.
SQLite is a very simple, but powerful database system that comes with Python. It has the administrative overhead of a text file, with the capabilities of a database system.
This is an important class for understanding how to create more complicated projects as we delve into more complex projects in future classes.
This class will go over:
- Why SQL Matters
- How Databases can be used with AI systems
- What SQLite is
- How to use SQLite
- Basic SQL Queries and how to build a database and tables
- Connecting SQLite to Python
- How build apps using AI, Python and SQL
We will explain how these services work. Demonstrate how to use these services in live code, and you will have time to create simple labs to get the feel for how easy AI can be.
The first part of the class will be seminar, and then the second part is where you will write code and I'll be able to help troubleshoot any problems you run into.
Note 2: We don't have any food/ drink sponsors so please eat beforehand, or... bring enough for the class!
Note 3: This will be at American Underground after normal hours. I will send out the key code to get into the building before the class so make sure to look in your email for the code before you come. I will be in the classroom by 5pm. Please feel free to come early to talk or setup your computer.
