What is SQL:
SQL is a language that's used to query, modify and update data in databases, tasks commonly associated with data scientists and data analysts.
About the Bootcamp:
This workshop will give you a basic introduction to SQL, and is for those new to SQL who are looking to get familiar with language. The class will start with the basics and build into some intermediate aspects of SQL.
Agenda:
Introduction
Make sure everyone is set up with Mode and can access interface and dataset
Topics Covered: How to query a table, Where clause, Group By, Order By and Limit
Required Materials/ Prework:
1. Laptop
2. Register for Mode Analytics (
https://modeanalytics.com/) and click on “New Report” in the top right corner. We will use datasets from the publicly available tutorials.
About the Instructor:
Divya is a data analyst at a ADARA, an ad-tech company based in San Francisco. He uses SQL on a daily basis for ad-hoc analysis and to feed data visualizations. He is an alumni of UC Irvine and graduated with an Economics major and a Statistics minor.