Reporting with SQL Course (How To)

SQL can be used to generate reports and present information on websites. This course covers powerful SQL features in helping you answer more interesting questions about your data.

What you'll learn

• Ordering, limiting and paging through a result set
• Manipulating text
• Working with numbers
• Working with dates

Ordering, Limiting and Paging Results

Databases can store a lot of data. Retrieving all of that in one go isn't performant or helpful to users.

Chevron 9 steps

• Overview

  3:07

• Retrieving Results in a Particular Order

  5:13

• Ordering Results

  3 objectives

• Limiting the Number of Results

  2:49

• Limiting Results

  2 objectives

• Paging Through Results

  2:33

• Paging Through Results

  2 objectives

• Practice Session

  1:08

• Review: Ordering, Limiting and Paging Results

  5 questions

Working with Text

Being able to manipulate text is vital for displaying information in a more human readable or standardized way. In this stage we'll take a look at some key ways we can format and manipulate text.

Chevron 14 steps

• What Are Functions?

  3:12

• Adding Text Columns Together

  3:39

• instruction

  Single vs Double Quotes

• Concatenating Text

  2 objectives

• Finding the Length of Text

  2:50

• Getting the Length of a String

  1 objective

• Changing the Case of Text Columns

  2:45

• Changing Cases of Strings

  2 objectives

• Creating Excerpts From Text

  2:19

• Creating Excerpts

  1 objective

• Replacing Portions of Text

  1:58

• Replacing Strings

  1 objective

• Practice Session

  3:27

• Review: Working with Text

  5 questions

Aggregate and Numeric Functions

Performing mathematic operations on groups of rows, like getting a total or getting an average is super handy. In this stage you'll learn this and more.

Chevron 14 steps

• Counting Results

  4:41

• Counting Results

  2 objectives

• Counting Groups of Rows

  2:21

• Counting Groups

  2 objectives

• Getting the Grand Total

  5:31

• Summing Values

  1 objective

• Calculating Averages

  2:01

• Averaging Values

  1 objective

• Getting Minimum and Maximum Values

  2:08

• Calculating the Minimum and Maximum Values

  1 objective

• Performing Math on Numeric Types

  4:35

• Performing Math

  1 objective

• Practice Session

  2:31

• Review: Aggregate and Numeric Functions

  5 questions

Date and Time Functions

Displaying results based on dates and times is crucial for reporting and presenting information that's time sensitive or to perform analysis. We'll take a look at how we can use dates in our reporting and how we can format dates too.

Chevron 9 steps

• Differences Between Databases

  1:20

• Creating Up-to-the-Minute Reports

  2:17

• Today's Report

  1 objective

• Calculating Dates

  4:03

• Calculating Dates

  1 objective

• Formatting Dates For Reporting

  3:17

• Formatting Dates and Times

  1 objective

• Practice Session

  1:22

• Review: Reporting with SQL

  15 questions