Categories
Marketing Analytics and Reporting

Learn Basic SQL in 15 Minutes (PART 3) | SQL Functions Tutorial [Video]

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

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.

THANK YOU TO OUR SPONSOR
LearnSQL.com – https://geni.us/learnsql

JOIN THE LEARNBI.ONLINE FACEBOOK GROUP
https://www.facebook.com/groups/816317545978660

WATCH PARTS 1 & 2 HERE:
Part 1 – https://youtu.be/kbKty5ZVKMY
Part 2 – https://youtu.be/gm6tNK_iOHs

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

🎥 OTHER USEFUL VIDEOS
7 Steps to Your 1st BI Analyst Job – https://youtu.be/0zN0MM1SJMw
BI For Beginners Playlist – https://www.youtube.com/playlist?list=PLR0triVyTrBXF6iIJrRRUj1-SNJvinLWE

NAVICAT
https://navicat.com/

GET THE CHEAT SHEET
https://mailchi.mp/learnbi/functionscheat

⚙️ DATA HUBS:
Power My Analytics: https://geni.us/YLc9Re
Supermetrics: https://geni.us/5SNn
Data Slayer: https://geni.us/dataslayer

🧰 BI TOOLS
Power BI – https://powerbi.microsoft.com/
Tableau – https://www.tableau.com/
Data Studio – https://datastudio.google.com/

📊 DATA WEBSITES
Kaggle – https://www.kaggle.com/
Statista – https://www.statista.com/
Data World – https://data.world/
NYC Open Data – https://opendata.cityofnewyork.us/
UN Data – https://data.un.org/

🎓 ONLINE LEARNING
→ Ultimate Guide to Google Data Studio
https://geni.us/vbi-edu
→ Skillshare
Get a 14 day free trial and 30% off your 1st year of Premium
https://skillshare.eqcm.net/c/2534277/677296/4650
→Udemy
https://geni.us/udemy_vb
→Coursera
https://geni.us/coursera_analytics

📕 FREE EBOOKS TO DOWNLOAD
7 Top Tips For Better Dashboard Design – https://mailchi.mp/vitaminbi/dashboard-design-top-tips

The Skills You Need To Succeed In Business Intelligence – https://mailchi.mp/vitaminbi/bi-skills

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:

For business inquiries visit https://learnbi.online/contact

Sign up for my mailing list to be the first to hear about new videos and special offers
https://geni.us/PSgRsF

#sqltutorial #sqlfunctions #learnsql

Watch/Read More

Most Popular Posts Today

Set up and migration from Universal Analytics to Google Analytics 4, Reporting and Explore hub [Video]
►
Categories
Marketing Analytics and Reporting

Set up and migration from Universal Analytics to Google Analytics 4, Reporting and Explore hub [Video]

Set up and migration from Universal Analytics to Google Analytics 4, Reporting and Explore hub 

0:06 Introduction
 1:56 Agenda
 2:31 Migrating to Google Analytics 4
 3:36 GA4 Account Structure 
6:42 Demo - creating a GA4 property
 9:10 Demo - creating a Data Stream
 13:00 Demo - Google Ads linking with the GA4 Setup Assistant
 15:17 Measuring custom events in GA4 
19:03 Measuring Conversions in GA4
 26:15 Migrating users with the GA4 Setup Assistant
 29:50 Reporting & Explore in GA4
 34:35 Demo - Reporting
 38:00 Demo - Customization
 44:23 Demo - Explore

Most Popular This Week

“Google Ads Sales Tracking: How to Record and Analyze Data for Improved Performance” Ads conversion [Video]
►
Categories
Marketing Analytics and Reporting

"Google Ads Sales Tracking: How to Record and Analyze Data for Improved Performance" Ads conversion [Video]

If you're running Google Ads campaigns, it's important to track your sales performance to improve your return on investment (ROI). In this video, we'll walk you through the process of recording and analyzing data for your Google Ads sales. You'll learn about the different metrics you need to track, such as click-through rates, conversion rates, and cost per acquisition (CPA). We'll also show you how to use tools like Google Analytics and Google Ads reporting to gain insights into your data and make informed decisions about your advertising strategy. Whether you're a beginner or an experienced advertiser, this video will provide you with valuable tips and strategies to optimize your Google Ads sales and boost your ROI.#googleads #googleAds, #salestracking, #datarecording, #performanceanalysis, #ROI , #click-through-rates, #conversion rates, #CPA, #GoogleAnalytics, #advertising #strategy, #digitalmarketingcourse #digitalmarketingtips #digitalmarketingtraining #googleadscampaign #googleadwords #googleadwordstutorial #[email protected]