SQL WorkShop QCL Literacy: L1-Coding

Instructor: Graduate Fellow of the Quantitative and Computing Lab at Claremont McKenna College Summary

SQL is acronym for Structured Query Language. It is a language designed to access and work with relational databases. Relational databases store and provides access to data points that are related. Workshop will look at Data Definition Language (DDL), Data Manipulation Language (DML), and Data Query Language (DQL). Target Audience

This workshop is designed for beginners in SQL. No prior programming knowledge is needed. Required Software/Account

DataGrip - Download (Windows and Mac users) Agenda

SQL Intro
MySQL and DataGrip
Importing data
Creating a table
Inserting data
Querying a table
Joining tables
Hand-on activity

Before you start:

MySQL and DataGrip program download (how to available: SQL_preworkshop)

https://www.mysql.com/downloads/

https://www.jetbrains.com/datagrip/

Data

-https://corgis-edu.github.io/corgis/

State Crime CSV File
State Demographics CSV and SQL Files

#Workshop creation by Vanessa Casillas, QCL Grad Fellow (01-26-22)