SQL Bootcamp (Santa Monica)

Upcoming in Los Angeles

1

Saturday, 1 December
Los Angeles

Los Angeles campuses

GA Los Angeles (DTLA)
360 E. 2nd Street, Suite 400
Los Angeles CA 90012

GA Los Angeles (Santa Monica)
1520 2nd Street
Santa Monica CA 90401

Past Locations for this Class

SQL Bootcamp (Santa Monica)

Los Angeles

Upcoming in Los Angeles

1

Saturday, 1 December
Los Angeles

Los Angeles campuses

GA Los Angeles (DTLA)
360 E. 2nd Street, Suite 400
Los Angeles CA 90012

GA Los Angeles (Santa Monica)
1520 2nd Street
Santa Monica CA 90401

Past Locations for this Class

About this class

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.

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

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.

Please install the latest version of PgAdmin4 prior to class.

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.