** This is a paid workshop. Please purchase your ticket here: https://generalassemb.ly/education/sql-bootcamp/denver/125936 **

About This Workshop
SQL provides powerful but reasonably simple tools for data analysis and handling. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence. We will use a combination of lecture and in-class exercises to ensure that students leave with a working grasp of SQL fundamentals.

The well-being of our employees, students, clients, instructors, and guests is our number one priority here at General Assembly. We are monitoring COVID-19 very carefully and are adjusting delivery of our programs.

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one.

Takeaways
Background on SQL
Basic SELECT-FROM-WHERE statements
LIMIT clauses
Math operations and constant expressions in SELECT statements
Booleans and complex conditions in the WHERE clause
Pattern matching in the WHERE clause
NULL values
JOIN operations
Grouping and aggregations
HAVING clauses
ORDER BY clauses
Subqueries
Preparation
Basic technical aptitude and orientation to computers, and curiosity to learn new tools. Willingness to learn about a text-based/principle driven analytic tool with little real GUI support, and determination to push through the natural frustration of confronting new concepts.

Please install the latest version of PgAdmin4 prior to class.

You will need access to a laptop or computer with a working webcam and microphone as well as a strong internet connection.
This class will be geared towards beginners, looking to get acclimated with the fundamentals of visual/graphic design.
This course will occur completely online using Zoom and Slack.
Course set up information will be emailed to all students signed up around 24 hours before (and again an hour before) your course launches.

About the Instructor
Craig Sakuma
Founder,
QuantSprout

Craig has been a data science and analytics instructor at General Assembly since 2014 and he has over 2,000 hours of teaching experience. Prior to teaching at General Assembly, he worked as a data scientist at Euclid Analytics. Craig has also founded an e-commerce furniture business, Deal Decor, and worked as a consultant at the Boston Consulting Group. He has an engineering degree from Northwestern and an MBA from Wharton. For fun, Craig enjoys traveling and has spent a total of 5 years living overseas in three different countries.