SQL Bootcamp
18

Saturday, 18 March

10 am – 5 pm PDT

GA Los Angeles (Santa Monica)

1520 2nd Street
Santa Monica , CA 90401
$170 USD
Regular Ticket
$170 USD
Total

Questions? Read our FAQs

SQL Bootcamp

Dan Wilhelm Photo


Data Science Consultant

18

Saturday, 18 March

10 am – 5 pm PDT

GA Los Angeles (Santa Monica)

1520 2nd Street
Santa Monica , CA 90401
$170 USD
Regular Ticket
$170 USD
Total

Questions? Read our FAQs

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 necessary for querying popular relational/SQL-based databases such as MySQL and PostgreSQL.

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

What past students say:.

"Dan Wilhelm is a great instructor, and he had deep knowledge of the class material. We did what was advertised. It was a really useful class." — Flora Montufar

"Great class, the instructor explained everything very clearly and gave us ample opportunity to practice the skills he taught." — Kaleb Erickson

"Dan did an incredible job introducing SQL to us in a user-friendly, embracing way. Nobody was left behind and he prepared enough material to keep us engaged the entire day." — Hunter Klein

Prereqs & 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.

We will be pausing to let students run and write queries of their own, so students should bring laptops. We will use the first 10 minutes of class to install SQLite on laptops for use in class.

About the Instructor

Dan Wilhelm Photo

Data Science Consultant

Dan Wilhelm independently consults in data science and software development with a focus in machine learning. He has developed four complete flagship products for three startups, from ideation to deployment, in addition to numerous solutions for companies in search, natural language processing, and machine learning. Dan teaches data science and web development at General Assembly, authored open source neural network software for Google Summer of Code, wrote a book chapter on AI, and interned at Microsoft and two national laboratories. Dan was a Dept. of Homeland Security graduate fellow, receiving an MS from Caltech in Computation and Neural Systems and a BS from Purdue University in Computer Engineering. For fun, he has performed in over 200 improv shows.

Refund Policy

Plans change. We get it. But if you can't make it to a class/workshop, please email us at least 7 days before the scheduled event date. No refunds will be given after this timeframe.

Coming up near you

Let’s Keep You Updated

Enter your email to start following

By providing us with your email, you agree to the terms of our Privacy Policy and Terms of Service.