README.md

Kaggle SQL Summer Camp 2019

A week long course on SQL by using Google BigQuery

Course Structure

1. Introduction to SQL, Part1

   • Getting Started With SQL and BigQuery (Lesson and Exercise)
   • Select, From & Where (Lesson and Exercise)
   • Group By, Having & Count (Lesson and Exercise)

2. Introduction to SQL, Part2

   • Order by (Lesson and Exercise)
   • As & With (Lesson and Exercise)
   • Joining Data (Lesson and Exercise)

3. BigQuery ML Workshop (Lesson and Exercise)

4. Advanced SQL

   • JOINs and UNIONs (Lesson and Exercise)
   • Analytic Functions (Lesson and Exercise)
   • Nested and Repeated Data (Lesson and Exercise)
   • Writing Efficient Queries (Lesson and Exercise)

Kaggle Courses - Setup

You can find everything, apart from the BigQuery ML Workshop on Intro to SQL and Advanced SQL. Run the notebooks on Kaggle which has everything preinstalled.