This section of the course will prepare you to take your SQL queries to the next level with subqueries, wildcard searches, and range based queries.

This guide examines how to leverage the BETWEEN constraint to query data that fits inside or outside of a specific range of values.

Having the ability to search through strings in SQL is a very common task, and in this guide we'll walk through how to perform wildcard queries.

This guide examines how to leverage the WHERE/IN command in order to decrease duplicate OR clauses and streamline a SQL script codebase.

This guide will introduce you to the concept of SQL subqueries, which allow you to run nested queries inside of a SQL statement and generate dynamic data.

In this lesson we'll walk through additional examples of SQL subqueries and how they can be used to run advanced query scripts.

This guide walks through how to leverage subqueries for insert statements to dynamically records in outside tables.