Skip to main content

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

« back to classes page
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)

Participants should expect the class to meet for the full 3 hours on Monday, June 15.  On the following days, there will be lectures to view at your convenience, exercises to complete and optional instructor office hours from 9:00-10:00 a.m. (CST) daily.

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**

**Available discount class code may be entered during check out for the following:
SI001 - $450 Non-profit/government employees (1st Summer Institute class)
SI002 - $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.

Class Details

5 Sessions
Daily - Mon, Tue, Wed, Thu, Fri

Location
Online Webinar

Instructor
Balaji Golla 

CEUs : 15

General Admission: 

$650.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
6/15/2020 - 6/19/2020 Daily - Mon, Tue, Wed, Thu, Fri 8:30 AM - 11:30 AM St. Louis, Online Webinar  Map Balaji Golla