Categories
Marketing Analytics and Reporting

Learn Basic SQL in 15 Minutes (PART 3) | SQL Functions Tutorial [Video]

Learn Basic SQL in 15 Minutes (PART 3) | SQL Functions Tutorial

In this third and final part of the Learn Basic SQL in 15 minutes series, we’re going to be learning how to use different SQL functions to both clean data and create new fields from existing data.

THANK YOU TO OUR SPONSOR
LearnSQL.comhttps://geni.us/learnsql

JOIN THE LEARNBI.ONLINE FACEBOOK GROUP
https://www.facebook.com/groups/816317545978660

WATCH PARTS 1 & 2 HERE:
Part 1 – https://youtu.be/kbKty5ZVKMY
Part 2 – https://youtu.be/gm6tNK_iOHs

TIMESTAMPS
00:00 Intro
01:22 Tutorial start
02:28 TRIM, LTRIM & RTRIM functions
04:08 LEFT & RIGHT functions
05:15 LPAD & RPAD functions
06:30 SUBSTRING function
07:22 LENGTH function
08:58 LOCATE function
09:37 Separating first & last names
12:08 UPPER & LOWER functions
12:34 CONCAT function
13:20 Conditional Expressions
13:50 CASE statements
16:11 Outro

🎥 OTHER USEFUL VIDEOS
7 Steps to Your 1st BI Analyst Job – https://youtu.be/0zN0MM1SJMw
BI For Beginners Playlist – https://www.youtube.com/playlist?list=PLR0triVyTrBXF6iIJrRRUj1-SNJvinLWE

NAVICAT
https://navicat.com/

GET THE CHEAT SHEET
https://mailchi.mp/learnbi/functionscheat

⚙️ DATA HUBS:
Power My Analytics: https://geni.us/YLc9Re
Supermetrics: https://geni.us/5SNn
Data Slayer: https://geni.us/dataslayer

🧰 BI TOOLS
Power BI – https://powerbi.microsoft.com/
Tableau – https://www.tableau.com/
Data Studio – https://datastudio.google.com/

📊 DATA WEBSITES
Kaggle – https://www.kaggle.com/
Statista – https://www.statista.com/
Data World – https://data.world/
NYC Open Data – https://opendata.cityofnewyork.us/
UN Data – https://data.un.org/

🎓 ONLINE LEARNING
→ Ultimate Guide to Google Data Studio
https://geni.us/vbi-edu
→ Skillshare
Get a 14 day free trial and 30% off your 1st year of Premium
https://skillshare.eqcm.net/c/2534277/677296/4650
→Udemy
https://geni.us/udemy_vb
→Coursera
https://geni.us/coursera_analytics

📕 FREE EBOOKS TO DOWNLOAD
7 Top Tips For Better Dashboard Design – https://mailchi.mp/vitaminbi/dashboard-design-top-tips

The Skills You Need To Succeed In Business Intelligence – https://mailchi.mp/vitaminbi/bi-skills

Disclaimer: Some of the above links are affiliate links where I’ll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏

✅ LET’S CONNECT:

For business inquiries visit https://learnbi.online/contact

Sign up for my mailing list to be the first to hear about new videos and special offers
https://geni.us/PSgRsF

#sqltutorial #sqlfunctions #learnsql

Watch/Read More