String Functions In SQL With Examples

Опубликовано: 14 Февраль 2023
на канале: Analytics School

178

In this session of ‪@analyticsschool‬ , we will discuss how to use String functions in SQL. SQL string functions are used primarily for string manipulation by performing an operation on the input string(s) to return an output string.

We will use PostgreSQL syntax.

Chapters:

00:00 - Introduction
00:49 - CONCAT Function
01:34 - INITCAP Function
01:50 - Column Alias
02:19 - TRIM, LTRIM and RTRIM Functions
03:15 - LENGTH, LPAD and RPAD Functions
04:20 - REPLACE Function
05:18 - SUBSTRING Function

#sqlforbeginners #sqlfordatascience #sqlfordataengineers #analytics #dataanalysis #analyticsschool