What you will learn

• Identify a subset of data needed from a column or set of columns and write a SQL query to limit to those results.

• Use SQL commands to filter, sort, and summarize data.

• Create an analysis table from multiple queries using the UNION operator.

• Manipulate strings, dates, & numeric data using functions to integrate data from different sources into fields with the correct format for analysis.