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

YouTube Excerpt: 🚨 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 - https://youtu.be/kbKty5ZVKMY Part 2 - https://youtu.be/gm6tNK_iOHs 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. 📄 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

🚨 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...

Read Full Article 🔍

Curious about Learn Basic SQL In 15 Minutes (PART 3/3) | SQL Functions Tutorial | Business Intelligence's Color? Explore detailed estimates, income sources, and financial insights that reveal the true scope of their profile.

Source ID: w3ea4fKiS2g

Category: color style guide