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 intended for intermediate users. In order to give you a general idea of what you should already know about SQL, we're going to start with a short revision quiz. It will consist of 5 questions with an increasing level of difficulty. We assume you already know how to:
- query a single table,
- query multiple tables with
JOIN data from multiple tables,
- sort and group rows
- and use the
So, are you ready?