Advanced SQL Tutorial | String Functions + Use Cases

In today's Advanced SQL lesson we walk through how to use String Functions.

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
____________________________________________

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[havinashz]

as a fellow office fan and an aspiring data analyst i love your content

[josephj]

This was exactly what I needed for one of my assignments in my course!
Thanks a ton!

[niroshamirthipati]

Thanks for creating this content, Alex. I request you to create a video on Ranking Window functions like Rank (), Dense_rank (), Row_Number () with the same database.

[SamFisherman]

loved the "Flenderson - Fired" ... good idea to keep the video informative and fun ... very clever.

[gwenchen]

Great video :)! Thanks so much!
is it possible to do tutorials or a video with your opinions on while loops, cursors or dynamic sql?
I'm wondering how useful they are/use cases for each and is it worth it to spend time studying them...

[JamesAndrewA]

I love this series please make more! I cant wait for your portfolio project.

[dhir]

Apparently you and Michael both hate Toby a lot. First giving him 0.0001% raise and now this.

[digileapmarketingservices]

very well explained. Thank you for sharing contents like this

[islammounier]

this course is very useful and quick not boring at all 😍🤩🤩

[ifedijnrezenwobodo]

I don’t know if this helps, but I found out you can run TRIM, LTRIM, RTRIM, Lower and Upper, all in one go from Select.
Example: SELECT EmployeeID, LTRIM(1002) As IDTRIM, LastName, RTRIM(‘John’) As Name, LastName, UPPER(‘Jim’) As New
FROM EmployeeErrors

[krishnabarfiwala]

Hey Alex, awesome video. Do you have a video for Windowing functions?

[Ifeypeters]

Thank you so much Alex, you've been a great help to my Data analytics journey. I noticed the original inputs on the error table doesn't change after using the TRIM functions, how do we achieve this?

[romanvasiura]

I am curious to know... Why Alex put comma(s) before line (Create/Insert statement)?
Thank you for these tutorial videos 😀

[ArbHunter]

Thanks well explained

Looking forward to your py videos, are you doing any pandas ones?

[catarinamacedo]

I didn't see bad data at all hahahah It'd not be a surprise if Michael Scott put Fired as the last name of Toby and write it wrong, and put Beasely and Jimbo nicknames as well 😂😂Gotta love the consistency with the show in this tutorial

[Quis]

Can you join on multiple fields? In other words, have multiple ON statements in a single join?

[YouTubeVenJiX-zlbj]

Hello sir can you please make one separate video on substring 🙂

[avidhakal]

Hey alex thanks for the video
Just a question
Why do sometime i need to refer to whole database and sometimes just the table name while refering to the tables during join or some other operations ?

[jonasvianney]

Hello Alex
My name is John all the way from Uganda(africa) I wanted to follow a path to becoming a data analyst through self study but all I need from you is what exactly do I need to study n concentrate on. otherwise thanks for the good work

[chvenkatesh]

Hi sir we have PROPER function in EXCEL do we have anything like that in SQL