This section of the course will teach you how to work with SQL functions,. This is a critical skill when it comes to leveraging SQL in order to generate reports and to output non trivial data result sets.

Before learning about functions we need to change the data type of one of our columns, this will allow us to efficiently and accurately work with financial data.

In this guide we'll examine how to leverage some of the more common SQL functions available for summarizing queries, such as: MIN, MAX, SUM, AVG, and COUNT.

One of the most common tasks that SQL developers are asked to do is build summary reports from a data set. In this guide we'll examine how to combine the GROUP BY and various aggregate functions to generate summary reports.

This guide explains the two syntax options you have for adding comments to a SQL script. Additionally, we'll examine some of the issues that can arise when comments are not properly updated.

In this guide we'll walk through how to turn safe mode off in MySQL. Additionally, we'll discuss the few times when turning safe mode off is necessary.

This guide walks through how to add a new column in MySQL Workbench, and then how to populate the new column with randomized data by leveraging the SQL RAND() function.

This guide provides a step by step walk through for how to build a SQL query with calculated fields. This will allow you to perform mathematical calculations on data in the database at query time to build summary reports.

This guide explains how to integrate custom row and cell names in a SQL query to explicitly label data.