SQL Bootcamp: Learning the Language
19

Saturday, 19 October

10 am – 5 pm PDT

GA San Diego

2159 India St.
San Diego, CA 92101
$250 USD
Regular Ticket
$250 USD
Total
`

Questions? Read our FAQs

SQL Bootcamp: Learning the Language | October 19

Alejandro Hohmann Photo


Senior Marketing Insights Analyst, Jack in the Box

19

Saturday, 19 October

10 am – 5 pm PDT

GA San Diego

2159 India St.
San Diego, CA 92101
$250 USD
Regular Ticket
$250 USD
Total
`

Questions? Read our FAQs

About This Workshop

SQL is a powerful language, and tool, for data analysis and data handling. In this bootcamp, you’ll dive deep into SQL syntax and database structures, while applying your new SQL skills to address business problems. This bootcamp will take absolute beginners through the basics of SQL to an ability to write queries with confidence.

Takeaways

  • Understand SQL vocabulary such as tables, schema, functions and JOINS
  • Understand the differences between different data management systems for SQL databases
  • Create basic SQL queries by applying Boolean logic, sorting functions, and commenting
  • Apply SQL aggregate functions [MIN, MAX, SUM, AVG, COUNT]
  • Use CAST to change a column’s type for a query
  • Use advanced SQL commands [OR, GROUP BY, HAVING] and conditional operators [ =,!=,>,<, IN, NOT IN, and BETWEEN] to filter data
  • Apply string, date, and math functions to manipulate how data is presented
  • Apply UNION to tables and columns for merging data
  • Use JOINS to create relationships between tables to obtain data

Preparation

A basic technical aptitude, orientation to computers, and curiosity to learn new tools will make you successful in this bootcamp. No prior knowledge of SQL is required.

Prior to class: Download the DB Browser that is compatible with your operating system.

About the Instructor

Alejandro Hohmann Photo

Senior Marketing Insights Analyst,
Jack in the Box

Alejandro serves as analytics lead to Product Marketing and Strategic Initiatives at Jack in the Box, Inc. He works on data science and marketing analytics projects ranging from mobile app upsell technology to answering questions like, “how many tacos does the typical late-night customer eat”.

Prior to Jack in the Box, Alejandro worked in similar roles with United Parcel Service and Pernod Ricard USA. Alejandro is also the founder and former commissioner of an amateur baseball league. He has a Marketing and Business Analytics degree from Temple 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.