SQL Bootcamp
7

Saturday, 7 December

10 am – 5 pm PST

GA Los Angeles (Santa Monica)

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

Questions? Read our FAQs

SQL Bootcamp | December 7

David Bickham Photo


Data Analytics Manager, Fandango

7

Saturday, 7 December

10 am – 5 pm PST

GA Los Angeles (Santa Monica)

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

Questions? Read our FAQs

About This Workshop

This workshop will build upon the skills developed in the GA SQL For Beginners course. SQL provides powerful but reasonably simple tools for data analysis and manipulation. The workshop uses a combination of lecture and in-class exercises to ensure that students leave with a working grasp of the SQL skills covered in class. Students will immediately be able to apply their skills at work. This is an Intermediate-Advanced course and is best suited for students with some basic SQL knowledge (Understand SELECT-FROM-WHERE statements and basic filtering). Beginner level students should attend GA’s SQL for Beginners course prior to this workshop.

Takeaways

• Review SQL vocabulary such as tables, schema, functions, and joins
• Review basic SQL syntax with SELECT-FROM-WHERE statements (also LIMIT/ ORDER BY)
• Complex filtering using WHERE clauses
• Grouping and Aggregations [MIN, MAX, SUM, AVG, COUNT]
• CASE Statements
• Mathematical calculations in the SELECT statement
• Understanding Primary and Foreign Keys
• JOINs and UNIONs using aliases
• Subqueries
• Using Common Tables Expressions (CTEs) to break up complex queries
• Useful SQL Functions (Date/ String manipulation)

Preparation

This is an intermediate/advanced class. Please make sure you have attended SQL for Beginners course or have a basic familiarity with SQL syntax. 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

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.