Basics of SQL: A First Course in Using Relational Databases to Analyze Publicly Available Data | Brown School at Washington University in St. Louis
Skip Ribbon Commands
Skip to main content

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

 
Registration deadline: June 5th

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

15 CEUs/CPH units - (3 live, 12 self-paced)

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 relationship between tables; and manipulate numbers, strings and dates.

Students will obtain solid knowledge of the language, 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.

Workshop will consist of a live Zoom webinar from 8:30 - 11:30 a.m. on Monday, June 15th, with additional lectures and excercises in Canvas. Virtual office hours from 9:00 - 10:00 a.m. will be available daily.

Class size is limited to 15.

$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.

Important Notice:  A recent Chrome update is causing some registrations completed with Chrome to post in our software with missing data. For the present, we recommend using an alternative browser (such as Firefox, Explorer, Edge or Safari). Chrome users may experience a delay with registration confirmations.  

About the Instructor:

Portrait of Balaji GollaAs 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