SQL Bootcamp Remote (Online)
29

Friday, 29 December

10 am – 5 pm CST

GA Dallas (Online)

Online
Dallas
$300 USD
Regular Ticket
$300 USD
Total

Questions? Read our FAQs

SQL Bootcamp Remote (Online)

Eric Plummer Photo


Operations Manager, Lyft

29

Friday, 29 December

10 am – 5 pm CST

GA Dallas (Online)

Online
Dallas
$300 USD
Regular Ticket
$300 USD
Total

Questions? Read our FAQs

About This Workshop

Imagine that you have a spreadsheet containing every data point about your customers — their preferences, their web browsing behavior, the products they’ve bought. What would you do with all that information? When you know SQL, you can slice and dice that data any way you want, providing critical insights that drive business strategy.

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 — and start using the tool immediately.

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.

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.
  • This bootcamp is taken completely online across two different 3-hour sessions.
  • We will provide login information and a link to the platform on the day of each session
  • You will need a computer and a strong internet connection

Prior to class: Watch this Introduction to SQL video. Download the DB Browser that is compatible with your operating system.

About the Instructor

Eric Plummer Photo

Operations Manager,
Lyft

Eric is an Operations Manager at Lyft & Business Analytics Consultant with over seven years of experience helping businesses make better strategic decisions through leveraging their data. He has has led impactful data analytics initiatives for businesses ranging from a $40B financial institution to a $5M venture capital backed e-commerce start-up. Plummer's breadth of experience includes projects in the financial services, retail, automotive, consumer packaged goods, and non-profit industries.

His experiences include utilizing advanced data analytics techniques to develop actionable financial models, reveal financial inefficiencies, create competitive analysis, segment customer base, and improve business operations. Plummer holds a Masters in Management from Wake Forest University and a Bachelors in Economic from Princeton University. He currently lives and works in Detroit, MI.

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.

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.