The videos below walk through writing basic SQL queries in the Insights product. For other questions, please see our querying FAQ within the Insights article collection.

Introduction to SQL

This video introduces basic SQL concepts. You will learn SELECT clause, FROM clause, AS clause and column calculation. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

Writing queries using WHERE and JOIN

This video introduces WHERE and JOIN clauses of SQL. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

CTEs, ORDER BY, LIMIT, and OFFSET

This video introduces the concept of the CTE, as well as the ORDER BY, LIMIT, and OFFSET clauses. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

Using Aggregate Functions

This video introduces aggregate functions and GROUP BY clause of SQL. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

Partitions and JSON Manipulation

This video introduces the PARTITION BY clause to which the window function is applied and JSON processing functions. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

Window Functions

This video introduces window functions, which allow for a calculation across a set of table rows that are somehow related to the current row. After you learn these topics, you will be able to practice using them on your own in the Benchling’s Insights application.

Did this answer your question?