**$19.00**

What you get?

- 211 interactive exercises
- Lifetime access
- Certificate of completion
- 30 days money back guarantee

# Standard SQL Functions

Learn the most commonly used Standard SQL Functions.

This is the final price for customers outside the European Union. The European Union customers will be charged VAT at the country rate based on customer's location.

What you get?

- 211 interactive exercises
- Lifetime access
- Certificate of completion
- 30 days money back guarantee

Learn the most commonly used Standard SQL Functions.

- 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

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

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

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

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)

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

0% completed (22 of exercises done)

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)

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

0% completed (46 of exercises done)

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)

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)

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

0% completed (29 of exercises done)

Check the knowledge of SQL functions in the quiz.

0% completed (12 of exercises done)

0