SQL Bootcamp (Downtown LA)
23

Saturday, 23 February

10 am – 5 pm PST

GA Los Angeles (DTLA)

360 E. 2nd Street, Suite 400
Los Angeles, CA 90012
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

SQL Bootcamp (Downtown LA)

David Bickham Photo


Data Analytics Manager, Fandango

23

Saturday, 23 February

10 am – 5 pm PST

GA Los Angeles (DTLA)

360 E. 2nd Street, Suite 400
Los Angeles, CA 90012
$250 USD
Regular Ticket
$250 USD
Total

Questions? Read our FAQs

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 participants leave with a working grasp of SQL fundamentals.

The best parking structure to use is at 350 E. 2nd Street. It is directly next door (to the right) of our building. The cost is $2.00/15 min ($10 max), $5.00 flat rate after 4pm.

Gold line stop in Little Tokyo is a 5 minute walk to campus. Red line stop at Grand Park and Civic Center is about 10-15 minute walk.

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.

About the Instructor

David Bickham Photo

Data Analytics Manager,
Fandango

David is a proven analytics leader within the Media/Entertainment space. Currently at Fandango, he supports various departments by providing analytical solutions and actionable insights that drive business decision making. His previous roles include working as an analyst for Warner Bros. Entertainment Group and a leading digital marketing agency, where he enabled digital marketing teams to improve their CRM and email marketing programs through data-driven segmentation and customer focused analyses. His specialties include manipulating and extracting data for analysis via SQL, visualizing data using Tableau, and statistical analysis in R. He holds a BA in Economics from the University of California, Riverside and an MBA with a focus in Decision Sciences & Marketing from the Graziadio School of Business & Management at Pepperdine University.

Refund Policy

We understand that, sometimes, plans change. If you can no longer make it to a class or workshop, please email us at least 7 days before the scheduled event date. No refunds will be given to cancellations made within a week of the class or workshop.

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.