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. WATCH PARTS 1 & 2 HERE: Part 1 - https://www.youtube.com/watch?v=kbKty5ZVKMY Part 2 - https://www.youtube.com/watch?v=gm6tNK_iOHs 🚨 WANT MORE? GET MY FULL SQL COURSE HERE: https://geni.us/lbia_sql Don't forget to check out part 1 to learn what is SQL. What you learn over the course of these videos can be applied to MySQL, PostgreSQL, SQL Server and others. 🙏🏻 SUPER THANKS If you found this video valuable and would like to show your appreciation, you can make a donation via the Super Thanks option under the video. It helps me keep the channel going and the free content coming! 🔵 THANK YOU TO OUR SPONSOR LearnSQL.com - https://geni.us/learnsql ➡️ JOIN THE LEARNBI.ONLINE FACEBOOK GROUP https://www.facebook.com/groups/816317545978660 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://www.youtube.com/watch?v=0zN0MM1SJMw BI For Beginners Playlist -    • BI For Beginners   NAVICAT https://navicat.com/ GET THE CHEAT SHEET https://geni.us/sql3cheatsheet ⚙️ DATA HUBS: Power My Analytics: https://geni.us/YLc9Re Windsor.ai - https://geni.us/windsorai 🧰 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 30-day free trial of Skillshare Premium! https://geni.us/skillshare30day →Udemy https://geni.us/udemy_vb →Coursera https://geni.us/coursera_analytics 📕 FREE EBOOKS TO DOWNLOAD 7 Top Tips For Better Dashboard Design https://geni.us/dashdes-ebook The Skills You Need To Succeed In Business Intelligence https://geni.us/biskills-ebook 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