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

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql 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 -    • Learn Basic SQL in 15 Minutes | Busin...   Part 2 -    • Learn Basic SQL in 15 Minutes (PART 2...   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. 🔵 THANK YOU TO OUR SPONSOR LearnSQL.com - geni.us/learnsql 📄 GET THE CHEAT SHEET geni.us/sql3cheatsheet NAVICAT navicat.com/ 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 🏠 JOIN THE LEARN BI ACADEMY - geni.us/lbi_academy 🚀 BECOME A BI ANALYST - geni.us/lbia_biasp 🏆 TAKE THE BI CONSULTANT MASTERCLASS - geni.us/lbia_bicm 🧰 TOOLS & SKILLS Excel For BI Analysts - geni.us/lbia_excel SQL For BI Analysts - geni.us/lbia_sql Power BI For BI Analysts - geni.us/lbia_powerbi Tableau For BI Analysts - geni.us/lbia_tableau Looker Studio For BI Analysts - geni.us/lbia_lookerstudio 📊 DATA ANALYST PROJECTS All Projects - geni.us/lbia_projects Ben’s Pizzeria - geni.us/pizzaproject Hotel Reservations - geni.us/hotelproject Multi-Channel Marketing - geni.us/multichannelproject Call Centre - geni.us/callcentreproject 🎥 RECOMMENDED VIEWING 7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1 BI For Beginners Playlist - geni.us/biforbeginners-play 📕 FREE EBOOKS 7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook Skills You Need To Succeed In BI - geni.us/biskills-ebook 7 Steps to Your 1st BI Job - geni.us/7stepstobi-ebook 📊 DATA HUBS & WEBSITES: Power My Analytics - geni.us/YLc9Re Windsor.ai - geni.us/windsorai Kaggle - www.kaggle.com/ Statista - www.statista.com/ Data World - data.world/ 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! BUSINESS INQUIRIES - learnbi.online/contact CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner JOIN MY MAILING LIST - geni.us/PSgRsF FACEBOOK GROUP - geni.us/learnbi-fbg #sqltutorial #sqlfunctions #learnsql