SQL 101

Online Campus

Online
Anywhere
Online

SQL 101 | Online

Online Campus

Online
Anywhere
Online

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

I have read and acknowledge General Assembly's Privacy Policy and Terms of Service. SMS message and data rates may apply.