$300

Multiple Dates

Intensive SQL: Ramping Up On BigQuery

Event Information

Share this event

Date and Time

Location

Location

1460 Broadway

New York, NY 10036

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This 2 day event is intended to ramp up absolute beginners on basic SQL and using the Google BigQuery database system to use in their organizations and work. SQL is one of the most critical skills in an analytics professional's skillset and beyond. This tutorial will take you through one of the most important aspects of SQL, mastering the SELECT statement. We'll also cover important concepts within BigQuery itself that apply to almost all SQL database systems.

We'll wrangle multiple open-source databases which are available through Google's BigQuery, a cloud based data service. Here are some quick bullets on what we'll be learning about:

- Core SELECT statement clauses

- Aggregation Functions

- Mathematical & Logical Operators

- JSON functions

- Creating database views

Once you've learned a mastery of the UI and using command line tools to execute queries in BQ, you'll be well on your way to being apply similar steps to almost all other databases.

From a practical perspective, we provide some simulated and real datasets from digital and non-digital products to help you get down to real-world usecases around generating insights as you will be expected to in your profession or organization. This includes tasks like generating a calculation of customer retention, cleaning messy URL data, and merging multiple revenue reporting resources together into one standardized view. Additionally, each topic has it's own deep-dive into a specific area, for instance in covering mathematical operators, we'll be learning to apply a complex forumula to generate the Hirfindahl-Hirshman Index (an economics term).

Share with friends

Location

1460 Broadway

New York, NY 10036

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved