Learn SQL with Microsoft SQL Server | String Manipulation | Part 8

String Manipulations are used to change the way strings are seen, without changing the actual values in a table. String Functions are used to perform an operation on a string input value and retrieve a string or numeric value. The different ways of doing String Manipulation in SQL Server demonstrated in this video are ALIAS, STUFF, REPLACE, SUBSTRING, CONCAT, and CONCAT_WS
Some String Functions in SQL Server demonstrated in this video are CHARINDEX, REVERSE, UPPER, LOWER, RIGHT, LEFT, and LEN

--LINK TO SQL QUERY--
https://github.com/AllThingsDataWithAngelina/SQL-Server/blob/main/String_Manipulation_String_Functions.sql

--LINKS TO PLAYLISTS--
Learn SQL with Microsoft SQL Server: https://youtube.com/playlist?list=PL3QIj0dCAeARFktUaoy1I4C3qvpeptSjK

Data Analyst Portfolio Projects: https://youtube.com/playlist?list=PL3QIj0dCAeARnHKdYGIEQ--mFFlSb0FNL

HAPPY WITH THE CONTENT?
SUBSCRIBE NOW! CLICK HERE - https://www.youtube.com/c/AngelinaFrimpong
OR HERE - https://bit.ly/angelinafrimpong

Timestamps:
00:00 Intro
00:16 String Manipulation
00:23 String Function
01:32 Answering Questions from the previous Demo
03:34 Choosing Data Source for Demo
05:33 ALIAS
07:33 STUFF
10:12 REPLACE
11:38 SUBSTRING
13:00 CONCAT
15:49 CONCAT_WS
16:42 CHARINDEX
18:27 REVERSE
19:13 UPPER and LOWER
19:27 RIGHT and LEFT
20:22 LEN
21:15 TO DO (Assignment)
21:38 Outro


#SQL #LearnSQL #Data