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

--LINKS TO PLAYLISTS--

HAPPY WITH THE CONTENT?

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

[OutlierHUB]

The way she explain things are quite everything is perfect. Thanks for covering everything.

[simonoganga]

Amazing work Angelina, you make those difficult concepts easy to digest and comprehend, MUCH THANKS

[ikersanchez]

Amazing video
Suggested to-do challenge: Extract the last name from each full name
I used reverse for it