SQL 101

Washington, D.C. Campus

GA D.C.
509 7th Street NW, 3rd Floor
Washington D.C. 20004

Past Locations for this Workshop

SQL 101 | Washington, D.C.

Washington, D.C. Campus

GA D.C.
509 7th Street NW, 3rd Floor
Washington D.C. 20004

Past Locations for this Workshop

About this workshop

Unleash the power of SQL to automate reports, access data beyond cookie-cutter tools and combine data from different sources. In this crash-course, you'll learn the basics of SQL. We'll also dip our toe into data visualisation options.

Please note: This class teaches PostgreSQL. Other flavours of SQL (e.g. MySQL, MS SQL) have subtle differences.

Takeaways

  • Setting up - What you need to access your database
  • What is SQL? Why use SQL? How does it differ from Excel?
  • Writing queries
  • Selecting, Filtering (on query level), Ordering & Grouping
  • Common data types
  • Aggregation functions (across rows)
  • Aggregating horizontally (across columns)
  • Casting types
  • Common functions
  • Joins – Combining tables
  • CTEs – Keep your queries structured
  • Creating views
  • Filtering on function level
  • Cases (if clauses)
  • Window functions
  • SQL and Excel
  • Visualisation options

Prereqs & Preparation

Everyone who wants to learn the fundamentals of SQL and be able to run/write queries on an existing database. No prior experience required but should be comfortable around technology.

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.