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

Description

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.

This course is offered by: Washington University of St. Louis - Brown School of Social Work

Registration fee:

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

For more information and to register, click here: https://brownschool.wustl.edu/Resources-and-Initiatives/Professional-Development/Pages/Basics-of-SQL.aspx

Sessions: (8:30 am - 11:30 am)

  1. 6/12/2023
  2. 6/13/2023
  3. 6/14/2023
  4. 6/15/2023
  5. 6/16/2023

Use Tab key to loop through the section below. Press Enter or Space to enter content for each tab button. Press Esc key to exit and to go to the next section at any time.

Extension resources