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

🏠 JOIN THE LEARN BI ACADEMY - https://geni.us/lbi_academy
🚀 BECOME A BI ANALYST - https://geni.us/lbia_biasp
🏆 TAKE THE BI CONSULTANT MASTERCLASS - https://geni.us/lbia_bicm

🧰 TOOLS & SKILLS
Excel For BI Analysts - https://geni.us/lbia_excel
SQL For BI Analysts - https://geni.us/lbia_sql
Power BI For BI Analysts - https://geni.us/lbia_powerbi
Tableau For BI Analysts - https://geni.us/lbia_tableau
Looker Studio For BI Analysts - https://geni.us/lbia_lookerstudio

📊 DATA ANALYST 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

🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - https://geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - https://geni.us/learnbasicsql15-1
BI For Beginners Playlist - https://geni.us/biforbeginners-play

📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - https://geni.us/dashdes-ebook
Skills You Need To Succeed In BI - https://geni.us/biskills-ebook
7 Steps to Your 1st BI Job - https://geni.us/7stepstobi-ebook

📊 DATA HUBS & WEBSITES:
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/

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 - https://learnbi.online/contact
CONSULTING CALL WITH ADAM - https://geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - https://geni.us/PSgRsF
FACEBOOK GROUP - https://geni.us/learnbi-fbg

#sqltutorial #sqlfunctions #learnsql