SQL Bootcamp Remote (Online)
30

Monday, 30 September

11 am – 5 pm EDT

GA D.C. (Online)

Online Class
Livestream
$250 USD
Regular Ticket
$250 USD
Total
`

Questions? Read our FAQs

SQL Bootcamp Remote (Online) | September 30

Michael Valeri Photo


Sr. Analytics Consultant, Avenue In Consulting

30

Monday, 30 September

11 am – 5 pm EDT

GA D.C. (Online)

Online Class
Livestream
$250 USD
Regular Ticket
$250 USD
Total
`

Questions? Read our FAQs

About This Workshop

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

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 via Zoom and Slack
  • We will provide login information and a link to the platform on the day of the session.
  • You will need a computer and a strong internet connection
  • Each participant must have purchased a ticket

Please install the latest version of PgAdmin4 prior to class

About the Instructor

Michael Valeri Photo

Sr. Analytics Consultant,
Avenue In Consulting

Valeri is senior analytics professional with 5 years of experience mining, refining, and presenting big data across multiple Fortune 500 companies including Amazon, GoDaddy, Expedia, and Big Fish Games..

Valeri believes everyone has the "right" to understand how their data is being used, regardless of their technical aptitude, experience, age, or background.

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.