Course

Basic

Standard SQL Functions

Learn how to process numerical, text, and other types of data with SQL’s most-used functions.

Table of contents

21 free interactive coding challenges

Lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

limited to this course only

$39

Buy now

Want a better deal?

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

Get unlimited lifetime access to all 69 present and future courses

Save $450

Unlimited lifetime access

B042DDD8-A1C9-4053-8AF3-463EB31543B8@2x

to all 69 present and future courses

$149

$599

75% OFF

Buy now
Details
211

Interactive exercises

18 h

Estimated time

58678

Users enrolled

☆☆☆☆☆
★★★★★

5147 ratings

Introduce yourself to the standard SQL functions used in data processing. This course shows you how to use SQL to work with the following data types:

  • Text
  • Numeric
  • Date and time
  • And more
 

Cover image for the course 'Standard SQL Functions'

You’ll also learn about:

  • Dealing with NULLs in SQL functions
  • SQL aggregate functions
 

You’ll also examine the CASE WHEN expression – a powerful SQL construction that facilitates conditional computations. Finally, the SQL reporting exercises explain how to work with computing ratios and percentages.

Note: This course uses examples written in standard SQL, but not all databases comply with the SQL standard. Some minor modifications may be needed. If that’s the case, we’ll let you know in the exercise instructions. Also, many databases offer non-standard functions that do the same thing as these standard functions. We don’t cover non-standard syntax in this course; your database documentation is a good place to learn about any non-standard syntax.

What Do You Need to Take This Course?

  • A web browser and an Internet connection
  • Some understanding of SQL, such as the concepts presented in our SQL Basics course

This Course Will Teach You How To:

  • Utilize common SQL text functions
  • Identify and use standard SQL numeric functions
  • Select and implement SQL date and time functions
  • Work with NULLs in standard SQL functions
  • Understand SQL aggregate functions
 

Plus, you’ll get to practice your skills on 211 interactive exercises.

Who Should Take This Course?

  • Anyone who wants to learn about standard SQL functions
  • Beginning database analysts
  • Beginning developers
  • Students taking classes in relational databases
  • Business database users who want to improve their skills

 

The material in Standard SQL Functions is intended for intermediate users. To complete this course, you’ll need to know:

  • How to select from a single table, including writing complex WHERE conditions
  • How to JOIN tables
  • How GROUP BY and HAVING work

 

This course is not about user-defined functions. If you're looking for a course about user-defined functions, see the Writing User-Defined Functions in PostgreSQL course.

Table of contents

Free

Paid content

0%

Course progress

0/211

Exercises completed

1.

Intro Quiz

In this course we assume that you know the basics of SQL: you know how to select information from a single table, you know how to join queries and group by query results. Take the test to find out if you know SQL well enough to follow the course.

0/7

Introductory Quiz

2.

Pretty Printing

Learn the basic SQL text functions to transform text values and make your reports look pretty.

0/22

Introduction

Concatenation

Simple text functions

How to modify strings

Review

3.

Numeric functions

Master numeric functions in SQL. Learn about the caveats of mathematical operators in SQL, various rounding functions in SQL and computing proportions in SQL.

0/28

Reviewing SQL and numbers

So you think you can count

Round and other functions

Review and practice

4.

Date and time functions

Study date and time functions and learn how to select events from a period of time.

0/46

Introduction

Dates

Time

Timestamps

Extract functions

Timezone conversion

Intervals

Current date and time

Review

5.

Nulls

NULLs are tricky. Learn how to avoid common mistakes with NULL and what SQL functions there are to deal with NULL.

0/30

Review

Comparisons with NULL

Functions with NULL

COALESCE to the rescue

NULLIF

Review and practice

6.

Aggregate functions

Deepen your understanding of SQL aggregate functions: COUNT, AVG and SUM. Practice which variant of COUNT or AVG to choose in typical use cases.

0/37

Introduction

Function COUNT

Function AVG

Functions SUM, MAX, MIN

Review

7.

CASE WHEN

Learn how to include conditions in your SQL queries. Practice computing simple summary reports.

0/29

Introduction

Simple CASE WHEN

Searched CASE WHEN

CASE WHEN with aggregates

CASE WHEN with GROUP BY

Summary

8.

Final Quiz

Check the knowledge of SQL functions in the quiz.

0/12

Final Quiz

Reviews (22)

Average rating

4.90/5

☆☆☆☆☆
★★★★★

5147 ratings

Details

5 stars

94%

4 stars

5%

3 stars

1%

2 stars

0%

1 stars

0%