This course introduces the most useful and popular common T-SQL functions. Along the way, you'll get to know basic T-SQL functions for:

• text data,
• numeric data,
• date and time data.

And we'll cover some other handy T-SQL functions, too.

Before we get started, let's take a short quiz. This will give you a general idea of what you should already know about T-SQL. We assume you already know how to:

• query a single table,
• query multiple tables using JOIN,
• sort and group rows,
• use the HAVING statement.

If you're ready, let's go!