New to Weld? Getting started on your analytics journey? Join the community.
Product
CORE FEATURES
SQL Editor
Create and manage your data models as a team
Extract (ELT)
Extract, load and transform customer data to your data warehouse, up to every minute
Activate (Reverse-ETL)
Sync customer data to all your tools, up to every minute
MORE FEATURES
Metrics Store
Lineage & Observability
Enterprise
Managed Data Warehouse
NEW
WELD FOR...
E-commerce
Data Analysts
CTOs
Commercial Leaders
Integrations
Pricing
Pricing
Resources
GET SMART ABOUT DATA
Blog
Develop your data knowledge, and stay up to date with the industry’s latest trends
eBooks
Tactical playbooks that help you take action on your data
Guides
Dive deeper in the core topics of data and analytics
RESOURCES
About us
Careers
SQL Tutorial
Partners
Customers
Security
Docs
👋 UPCOMING EVENT
The 2nd edition of our data-led series is coming up on August 24th: how to get event tracking right. Sign up here!
FEATURED CONTENT
5 Reasons your ecommerce company needs to invest in a modern data stack
The modern data stack is bringing data-led growth to ecommerce businesses big and small. Learn why you shouldn't wait to invest in your data.
Learn SQL
SQL Templates
Log in
Sign up
Book a demo
Log in
Sign up
Book a demo
Start learning SQL
Jump in to our fun, free and engaging SQL course and become a skilled data analyst faster than you can say "left join".
Browse course content
Start from scratch with the introductory lesson, or jump to the skill you want to develop by picking the lesson you want.
Lesson
1
•
Introduction
Introduction: Analyzing Data with SQL
In this introductory lesson, learn what SQL is, what you can do with it, and how you can start honing your skills.
Go to lesson
Lesson
2
•
Preparation
Connecting data, tables, and creating a model
The first step in getting going with SQL is connecting your data and tables and learning the architecture for building your first model.
Go to lesson
Lesson
3
•
SELECTing
SELECTing your first data with SQL
The most basic SQL query grabs data from a table, and consists of a SELECT statement and a FROM statement.
Go to lesson
Lesson
4
•
Filtering
Introduction to filtering (WHERE)
The ‘where’ clause in SQL is a very simple way to filter out rows in your data set based on the content of it.
Go to lesson
Lesson
5
•
Filtering
Using !, =, <, > to filter data in SQL
You can use symbols like !, =, <, and > to filter data in SQL. Learn the basics of how each symbol works.
Go to lesson
Lesson
6
•
Filtering
AND / OR: Filtering your data with several conditions
Learn how to combine several conditions in your ‘where’ statement by using the statements ‘and’ & ‘or’.
Go to lesson
Lesson
7
•
Filtering
Filtering on non-exact values with LIKE
In cases where you're unable to define the conditions exactly, you can use 'like' clause to filter on values that match more or less.
Go to lesson
Lesson
8
•
Filtering
Filtering when conditions are NOT fulfilled
To filter out based on values that are not exact, you can use the 'not' statement.
Go to lesson
Lesson
9
•
Creating Columns
Introduction to columns
In this section of the tutorial, you’ll work with something new: creating new content to be included in your table.
Go to lesson
Lesson
10
•
Creating Columns
Creating a new column and naming it AS something
Apart from selecting columns from the existing data, it’s also very simple to create new columns, and name them using 'as'.
Go to lesson
Lesson
11
•
Creating Columns
Making calculations in columns
Creating your own columns in SQL becomes even more useful for business analysis when you include calculations in the columns.
Go to lesson
Lesson
12
•
Creating Columns
Using CASE WHEN as IF statements in SQL
In SQL the ‘case’ statement functions the same way as the 'if' function in Excel.
Go to lesson
Lesson
13
•
Aggregating Data
Introduction to data aggregation
This lesson introduces data aggregation. More specifically, you'll learn what to expect in this chapter and how to aggregate data.
Go to lesson
Lesson
14
•
Aggregating Data
Using COUNT, SUM, AVG, MIN, and MAX
COUNT, SUM, AVG, MIN, and MAX are the SQL functions you'll use most for aggregating data.
Go to lesson
Lesson
15
•
Aggregating Data
GROUP BY and ORDER BY
GROUP BY and ORDER BY help you summarize the results on a level in between looking at all the rows in a table and only looking at one.
Go to lesson
Lesson
16
•
Aggregating Data
Avoid failing queries with aggregate functions and GROUP BY
Learn to avoid the common causes of fails when using aggregate functions and GROUP BY.
Go to lesson
Lesson
17
•
Sub-queries
Introduction to sub-queries and CTE
Sub-queries and CTEs are ways to create temporary tables than can then be treated in a separate step in your query.
Go to lesson
Lesson
18
•
Sub-queries
SQL WITH
The SQL WITH clause is a CTE that allows you to create a temporary table which you can then treat in a separate step in your query.
Go to lesson
Lesson
19
•
JOINing
Introduction to JOIN
Introduction to the JOIN function. Learn how to increase the width of the resulting table by adding columns from other tables.
Go to lesson
Lesson
20
•
JOINing
Finding Common Identifiers & Choosing your Primary Table
Joining tables in SQL requires you to have a common identifier between tables A & B. Learn how to find it.
Go to lesson
Lesson
21
•
JOINing
Using the JOIN function to combine tables
Joining tables is a way to get data from multiple tables in your SQL query. This is great if you want to query data on separate tables.
Go to lesson
Lesson
22
•
JOINing
Combining CTEs with JOIN
Combining CTEs with JOINs allows you to have an even greater level of data to analyze, without unnecessarily overloading your query.
Go to lesson
Lesson
23
•
Conclusion
What’s next? Start analyzing your own business data
Congratulations! You've made it through our SQL tutorial. The next step is to start analyzing your own business data.
Go to lesson
Lesson
24
•
Tips & Tricks
The order of the elements in your query
In order for your SQL query to return any results, your functions should follow a specific order. Learn what that order is in this lesson.
Go to lesson
Lesson
25
•
Tips & Tricks
LIMITing the amount of data with SQL
Limiting the amount of rows your SQL query returns is a nifty way to see an excerpt of your query's results (or to see if it has no errors).
Go to lesson
Lesson
26
•
Tips & Tricks
Formatting best practices
Learn the various different ways you can format your SQL code to improve readability and understandability.
Go to lesson
Lesson
27
•
Tips & Tricks
Documenting your code
Documenting your code ensures that you and others can go back and understand what the code is doing and how it’s structured.
Go to lesson