Description

This course introduces basic SQL functions that can be used to process different types of data. It focuses on the most-used and most useful standard SQL functions, including:
  • SQL text functions
  • SQL numeric functions
  • SQL date and time functions
  • SQL functions dealing with NULL
  • SQL aggregate functions

In this course, we'll focus on commonly-used standard SQL functions. The code we show should work in many SQL databases, although some minor modifications may be needed. However, not all databases comply with the SQL standard. If that's the case, we'll let you know in the exercise instructions.

Many databases offer non-standard functions which do the same thing as the standard functions we will discuss. We don't have the scope to cover non-standard syntax in this tutorial; your database's documentation is a good place to learn about any non-standard syntax it uses.

This course is not about user-defined functions. If you want us to create a course on writing and storing procedures or user-defined functions in SQL, let us know.

About the Standard SQL Functions Course
In addition to the above-mentioned functions, this tutorial will explain the CASE WHEN expression - a powerful SQL construction that facilitates conditional computations in SQL. We've also included a section on basic SQL reporting that explains how to put together computing ratios and percentages.

This course is intended for intermediate users. We assume the user knows the basics of SQL, such as:

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

What are the requirements?

  • A web browser
  • Knowledge of basic SQL, including JOINs and GROUP BY clauses

What am I going to get from this course?

You will find out how to use:
  • Basic SQL text functions
  • SQL numeric functions
  • Standard SQL date and time functions
  • SQL functions dealing with NULL

You'll also get a deeper understanding of SQL aggregate functions.

Who Should Take This Course?

  • Beginning database analysts
  • Beginning developers
  • Students taking classes in relational databases
  • Anyone who wants to learn about standard SQL functions

Table of contents

Intro Quiz

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% completed (7 of exercises done)

More Less
Try for free
Pretty Printing

Pretty Printing

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

0% completed (22 of exercises done)

More Less
Try for free
Numeric functions

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% completed (28 of exercises done)

More Less
Buy this course
Date and time functions

Date and time functions

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

0% completed (46 of exercises done)

More Less
Buy this course
Nulls

Nulls

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

0% completed (30 of exercises done)

More Less
Buy this course
Aggregate functions

Aggregate functions

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

0% completed (37 of exercises done)

More Less
Buy this course
CASE WHEN

CASE WHEN

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

0% completed (29 of exercises done)

More Less
Buy this course
Final Quiz

Final Quiz

Check the knowledge of SQL functions in the quiz.

0% completed (12 of exercises done)

More Less
Buy this course

Reviews

Average rating

4.5/590.0 (8)

Details

5 Stars 75 %
4 Stars 0 %
3 Stars 25 %
2 Stars 0 %
1 Stars 0 %
    0