Session box

Introduction to SQL with SQLite In-Person

This workshop introduces participants to the fundamentals of Structured Query Language (SQL) and demonstrates its integration with Python for database operations. We will use SQLite and Python's built-in sqlite3 module and will cover the following:

  • What is an SQL database and why would you use it?
  • Create and configure a conda environment for SQLite and Python development.
  • Basic SQL Commands and Syntax
  • Hands-On SQL Practice - write SQL queries to create tables, manage data, and retrieve data.
  • Integrating SQL with Python – Use Python to connect to SQLite databases, execute SQL commands, and handle query results programmatically.


This is a Research Data Services student led workshop. Contact: Vincent Scalfani, UA Libraries, vfscalfani@ua.edu

Date:
Wednesday, February 19, 2025
Time:
10:00am - 11:00am
Time Zone:
Central Time - US & Canada (change)
Location:
Scholars' Station - Rodgers Library
Event Type:
Workshop
Categories:
  Research Data Services (Open Session)  
Registration has closed.

Session Organizer

Vincent Scalfani

More sessions like this...