Day 17: Master SQL String Functions | Learn UPPER, LOWER, LENGTH, SUBSTRING, TRIM | 30-Day SQL

Channel:
India Tech With Nicks
Subscribers:
10,900
Published on ● Video Link: https://www.youtube.com/watch?v=Mydu9m274ww


Duration: 0:00
258 views
3

Day 17: Master SQL String Functions | Learn UPPER, LOWER, LENGTH, SUBSTRING, TRIM | 30-Day SQL
Welcome to Day 17 of my 30-Day SQL Challenge! Today we dive into some of the most useful String Functions in SQL πŸ’»

πŸ“š Topics Covered:

UPPER() – Convert text to uppercase

LOWER() – Convert text to lowercase

LENGTH() – Get number of characters

SUBSTRING() – Extract part of a string

TRIM() – Remove spaces from text

These functions are essential when working with text data β€” especially in data cleaning, formatting names, standardizing values, and preparing dashboards or reports.

🧠 Whether you're a beginner or prepping for interviews, these SQL string functions will make your queries more powerful!

πŸ“Œ Tools Used: PostgreSQL, pgAdmin
πŸ“… #Day17 of #30DayDataChallenge
πŸŽ₯ Channel: Tech With Nicks

#Day17 #SQLChallenge #StringFunctions #PostgreSQL #LearnSQL #TechWithNicks #SQLforBeginners #UPPER #LOWER #TRIM #SUBSTRING #DataCleaning #pgAdmin



Other Videos By Tech With Nicks


2025-07-01Day 24: Data Analyst SQL Project πŸ” | Customer + Orders Analysis in PostgreSQL | Real-World Business
2025-07-01Day 23: Mastering CTEs in SQL | WITH Clause & Common Table Expressions in PostgreSQL
2025-07-01Day 22: SQL JOINS Explained | INNER, LEFT, RIGHT, FULL JOIN in PostgreSQL with Real Examples
2025-06-25Day 21: Learn Window Functions in SQL | RANK(), ROW_NUMBER(), PARTITION BY in PostgreSQL
2025-06-24Day 20: COALESCE Function in SQL Explained with Examples | PostgreSQL Data Cleaning Tip πŸ’‘
2025-06-24Day 19: Mastering CASE Function in SQL | PostgreSQL Logic Building with Real Examples | Learn SQL
2025-06-21How to Make Drop-Down List in Excel | Data Validation Excel Tip
2025-06-20IF with AND in Excel | Apply Multiple Conditions Easily
2025-06-19Excel Progress Bar with Conditional Formatting | Dashboard Tricks
2025-06-19Day 18: Date & Time Functions in SQL | Extract, NOW(), AGE(), CURRENT_DATE & More | Learn SQL Fast
2025-06-19Day 17: Master SQL String Functions | Learn UPPER, LOWER, LENGTH, SUBSTRING, TRIM | 30-Day SQL
2025-06-18Remove Duplicates in Excel with One Click | Excel Tips for Beginners
2025-06-18Extract First Names in Excel Without Formula | Excel Flash Fill Trick
2025-06-18How to Split Full Name into First and Last in Excel | Excel Formula Tip
2025-06-18How to Highlight Duplicate Values in Excel | Excel Tips for Beginners
2025-06-18Excel Tip: How to Average Without Zeros or Blanks | Data Analyst Shortcut
2025-06-16Day 16: Learn SQL Aggregate Functions (SUM, COUNT, AVG, MAX, MIN) in PostgreSQL | SQL Challenge
2025-06-15ORDER BY, LIMIT & DISTINCT in PostgreSQL πŸ’‘ | Learn SQL Fast with Tech With Nicks
2025-06-15BETWEEN, LIKE & IN in PostgreSQL πŸ” | Learn SQL Fast with Tech With Nicks
2025-06-15Master Logical Operators in PostgreSQL 🧠 | SQL in 60 Seconds with Tech With Nicks
2025-06-15PostgreSQL Comparison Operators in 60 Seconds! πŸ” | Learn SQL with Tech With Nicks