*SQL Short Courses are for current UT-Austin faculty, staff, and students.

*Seating for each class is limited to 40 students.

Instructor: Chris Golubski is a doctoral student in mathematics education at The University of Texas at Austin, specializing in statistics education. He is also simultaneously pursuing a master’s degree in statistics. He currently holds a Master of Science in Mathematics and teaches at several local colleges in Austin, with over 15 years of educational and professional experience in mathematics and computer science.  Chris also does IT consulting and software development in the area.

Introduction to SQL

This course will cover a brief overview of table design in a relational database, followed by an introduction to retrieving, inserting, updating, and deleting data in a single table.  Additionally, we will cover basic aggregation functions, sorting data, and indexes.  We will also cover special data types, like date/time and money.  Participants should have basic familiarity with the structure of relational databases.  No familiarity with SQL is necessary.

Intermediate SQL

This course will cover more advanced queries that build on the information taught in the beginning course, such as multi-table queries (joins), advanced queries for reporting, views, triggers, and an introduction to stored procedures if time permits.  Additionally, optimization tips will be given throughout the course.