Control Flow in SQL


Not CompletedIntroduction to Control Flow in SQL

This set of guides will walk you through how to integrate control flow into SQL scripts to generate dynamic output.

Not CompletedDefining Aliases in SQL Queries and Exporting Data to CSV

This guide walks through the syntax needed to implement aliases in SQL queries to help with cleaning up column names in a result set. Additionally, we'll walk through how to export query data to a CSV file in MySQL Workbench.

Not CompletedHow to Alias Table Names in SQL

This guides provides the syntax for assigning alias names to tables in SQL. Additionally, we'll discuss when table name aliases are practical to use.

Not CompletedHow to Use Case Statements in SQL Queries to Implement Conditional Logic

In this lesson you'll learn how to implement case statements in SQL in order to dynamically add labels to a result set based on conditional logic. Specifically, we'll add the ability for queries to return a new column that contains a status based on revenue.

Quizzes


Control Flow in SQL
    Control Flow in SQL
      Unsupported Browser

      devCamp does not support ancient browsers.
      Install a modern version for best experience.