SQL Bootcamp Remote (Online)
6

Saturday, 6 January

10 am – 5 pm AEST

GA Brisbane (Online)

Online
Brisbane
$250 AUD
Regular Ticket
$250 AUD
Total

Questions? Read our FAQs

SQL Bootcamp Remote (Online)

Jerry Strazzeri Photo


Analytical Lead, Google Double Click

6

Saturday, 6 January

10 am – 5 pm AEST

GA Brisbane (Online)

Online
Brisbane
$250 AUD
Regular Ticket
$250 AUD
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

  • 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

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

Important Note: Prior to class, you must have PostgreSQL and PGadmin installed. To do so, please follow these instructions for installation.

About the Instructor

Jerry Strazzeri Photo

Analytical Lead,
Google Double Click

Jerry Strazzeri is an Analytical Lead and an entrepreneur. Jerry has worked in the industry for more than a decade, for companies like Google, The Walt Disney Company, Fairfax Media and NewsCorp, leading data analytics projects and providing data science solutions, extracting deep insights from data to help stakeholders and clients to make informed, less risky and more profitable business decisions.

He was also the co-founder of a technology startup in education based in Sydney and Silicon Valley.

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.