Скачать с ютуб Learn Basic SQL in 15 Minutes (PART 3/3) | SQL Functions Tutorial | Business Intelligence в хорошем качестве

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

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: https://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 | Business I...   Part 2 -    • Learn Basic SQL in 15 Minutes (PART 2/3) |...   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 - https://geni.us/learnsql 📄 GET THE CHEAT SHEET https://geni.us/sql3cheatsheet NAVICAT https://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 🎯 Want to become a Business Intelligence Analyst or level up your data skills? Explore practical tools, real-world projects, and expert-led courses to boost your BI career. ============================= 🎯 LEARNING PATHS ============================= BI Analyst Starter Program – https://geni.us/lbia_biasp BI Consultant Masterclass – https://geni.us/lbia_bicm ============================= 🛠️ LEARN BI TOOLS ============================= Excel – https://geni.us/lbia_excel SQL – https://geni.us/lbia_sql Power BI – https://geni.us/lbia_powerbi Tableau – https://geni.us/lbia_tableau Looker Studio – https://geni.us/lbia_lookerstudio ============================= 📊 PRACTICE PROJECTS ============================= All Projects – https://geni.us/lbia_projects Ben’s Pizzeria – https://geni.us/pizzaproject Hotel Reservations – https://geni.us/hotelproject Multi-Channel Marketing – https://geni.us/multichannelproject Call Centre – https://geni.us/callcentreproject ============================= 🔧 BI TOOLS (Free & Paid) ============================= RFM Tool (Paid) – https://rfm-tool.com Market Basket Tool (Paid) – https://marketbasket.io File Combiner (Free) – https://filecombiner.online Data Cloaker (Free) – https://datacloaker.com Dataset Scout (Free) – https://datasetscout.com ============================= 🎥 RECOMMENDED VIDEOS ============================= 7 Steps to Your 1st BI Job – https://geni.us/7stepstobivid Learn Basic SQL (15 min) – https://geni.us/learnbasicsql15-1 BI For Beginners Playlist – https://geni.us/biforbeginners-play ============================= 📚 FREE EBOOKS ============================= Dashboard Design Tips – https://geni.us/dashdes-ebook Skills for BI Success – https://geni.us/biskills-ebook 7 Steps to Your 1st BI Job – https://geni.us/7stepstobi-ebook 100 BI Analyst Interview Questions – https://geni.us/100-bi-questions ============================= 📈 DATA SOURCES & TOOLS ============================= Power My Analytics – https://geni.us/YLc9Re Windsor.ai – https://geni.us/windsorai Kaggle – https://www.kaggle.com/ Statista – https://www.statista.com/ Data World – https://data.world/ ============================= 📬 CONNECT WITH ME ============================= LinkedIn – https://geni.us/adamfiner-linkedin Contact – https://learnbi.online/contact Book a Call – https://geni.us/bookacall-adamfiner Join My Mailing List – https://geni.us/PSgRsF --- Some links are affiliate links, which means I may earn a small commission if you make a purchase—at no extra cost to you. Thanks for your support! 🙏 #sqltutorial #sqlfunctions #learnsql