Using Single Row Functions to Customize Output

Practice Labs Module
Time
36 minutes
Difficulty
Intermediate

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

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

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
Learning Partner
Comprehensive Learning

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