Overview

Introduction

Using Single Row Functions to Customize Output

This module explores the concepts of single row functions to customize the output in relational tables.

  • Describe various types of functions available in SQL
  • Using various Single Row Functions in a SELECT statement

Exercise 1 - Functions Available in SQL

In this exercise, you will learn the following about the single row functions:

  • Establishing a Connection to the Database
  • Distinct Types of Single Row Functions

Exercise 2 - Using General Functions in SELECT statements

In this exercise you will learn the following about the single row functions:

  • Use Numeric Functions in a SELECT Statement
  • Use Character Functions in a SELECT Statement
  • Use Datetime Functions in a SELECT Statement
  • Use Conversion Functions in a SELECT Statement
  • Use General Functions in a SELECT Statement

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.