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