Basics of SQL: A First Course in Using Relational Databases to Analyze Publicly Available Data

June 12, 2023 - June 16, 2023

 8:30 – 11:30 a.m., each day

Registration deadline: June 2nd

This course will be conducted via a virtual Zoom meeting format and Canvas. Access to a computer/laptop with internet access is required. Please contact Professional Development with any questions.

15 CEUs/CPH units

Balaji Golla, MS
Database Developer/Programmer, Health Communication Research Laboratory
Brown School

This course will introduce students to the database language SQL, using the open-source relational database management system MySQL. The class will begin with an introduction to databases, and then cover the major features of a database. Students will learn to create tables and fields; define relationships between tables; and manipulate numbers, strings, and dates.

Students will obtain a solid knowledge of the language, and how to retrieve and manage data efficiently. By the end of the class, students will be able to download a publicly available dataset, import it into MySQL, and query to filter/extract subsets of data.

The course will consist of daily live Zoom class meetings from 8:30 – 11:30 a.m. (Central Time), and additional course material in Canvas.

Class size is limited to 25.

$650 General admission
$450 Non-profit/government employees (1st Summer Institute class)
$400 Non-profit/government employees (Additional Summer Institute classes)

This class will include both degree-seeking graduate students and practicing professionals. Individuals registering through Professional Development will receive continuing education units – but not academic credit – for the class.

*Registration will open in a new window

About the Instructor:

As a programmer and database developer at the Brown School’s Health Communications Research Laboratory, Balaji Golla develops web-based and stand-alone databases. He is responsible for creating innovative solutions for computer-related research projects, training researchers, recommending new technologies, contributing to the design of research projects, and maintaining servers.  Balaji holds a Master’s degree in electrical and computer engineering from Southern Illinois University – Edwardsville.

Return to our list of Summer Institute classes