kirklandnuts/sql_de_mayo

Material for SQL de Mayo, a SQL workshop being held in Spring 2018

SQL de Mayo

Data Science at UCSB, in conjunction with Actuarial Association, FACTOR (Female Actuarial Organization), and FAME (Financial Analysis and Management Education) is hosting a SQL workshop this quarter (SPRING 2018)! This repository contains the workshop material.

Contributors

Here are the folks who helped create the material for this workshop!
Samantha Lee
Timothy Nguyen
Raul Eulogio
Shon Inouye
Jason Freeberg

Contents

installation_and_setup covers the process of getting up and running with PostgreSQL and Jupyter. Participants install those tools, configure a local database, and load it with data to be used in the workshop.

beginner is focused on introducing participants to the concept of databases as well as the SQL syntax. Participants will learn about the properties of tabular data and relational databases. Additionally, this section focuses on the fundamentals of SQL querying including SELECT statements, conditioning, and aliasing.

intermediate focuses on practically applying the concepts learned in the beginner session in various realistic scenarios. This introduces additional SQL concepts such as joins and database creation.