Reporting with SQL Course (How To)

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.

• 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.

• 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.

• 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.

• 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