SQL Programming Resources

𝐒𝐐𝐋 𝐂𝐚𝐬𝐞 𝐒𝐭𝐮𝐝𝐢𝐞𝐬 𝐟𝐨𝐫 𝐈𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰: Join for more: https://t.me/sqlanalyst 1. Danny’s Diner: Restaurant analytics to understand the customer orders pattern. Link: https://8weeksqlchallenge.com/case-study-1/ 2. Pizza Runner Pizza shop analytics to optimize the efficiency of the operation Link: https://8weeksqlchallenge.com/case-study-2/ 3. Foodie Fie Subscription-based food content platform Link: https://lnkd.in/gzB39qAT 4. Data Bank: That’s money Analytics based on customer activities with the digital bank Link: https://lnkd.in/gH8pKPyv 5. Data Mart: Fresh is Best Analytics on Online supermarket Link: https://lnkd.in/gC5bkcDf 6. Clique Bait: Attention capturing Analytics on the seafood industry Link: https://lnkd.in/ggP4JiYG 7. Balanced Tree: Clothing Company Analytics on the sales performance of clothing store Link: https://8weeksqlchallenge.com/case-study-7 8. Fresh segments: Extract maximum value Analytics on online advertising Link: https://8weeksqlchallenge.com/case-study-8

𝗧𝗼𝗽 𝟱 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗞𝗶𝗰𝗸𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗖𝗮𝗿𝗲𝗲𝗿 📊 Want to start a career in Data Science without spending money? Here are 5 beginner-friendly learning resources covering essential skills such as Python, SQL, Machine Learning and hands-on projects. 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:- https://pdlink.in/4ilAmok 🎯 Perfect for Students • Freshers • Beginners • Aspiring Data Scientists 💡 Learn → Practice → Build Projects → Create Your Portfolio

𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗙𝗥𝗘𝗘 𝗢𝗻𝗹𝗶𝗻𝗲 𝗠𝗮𝘀𝘁𝗲𝗿𝗰𝗹𝗮𝘀𝘀 😍 💫Accelerate your career in Data Science 💫Discover the skills, tools and career roadmap needed to enter this high-demand field. 🔥 Beginner-friendly online session—no prior experience required! 𝗥𝗲𝗴𝗶𝘀𝘁𝗲𝗿 𝗙𝗼𝗿 𝗙𝗥𝗘𝗘 👇:- https://pdlink.in/46adC3l (Only few slots left ) 📅 Date: September 11, 2026 ⏰ Time: 7:00 PM

🚀 𝗧𝗼𝗽 𝗧𝗲𝗰𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗟𝗮𝗻𝗱 𝗛𝗶𝗴𝗵-𝗣𝗮𝘆𝗶𝗻𝗴 𝗝𝗼𝗯𝘀 𝗶𝗻 𝟮𝟬𝟮𝟲😍 💰 Highest Salary: ₹41 LPA 📈 Average Salary: ₹7.4 LPA 🎓 2,000+ Students Placed 🏢 500+ Hiring Partners 💻 Full Stack :- https://pdlink.in/3SuUeuD 📊 Data Analytics :- https://pdlink.in/45vk5ph 💫AI Engineering :- https://pdlink.in/4fWJVID 🔥 Take the first step towards your high-paying tech career in 2026!

⚠️ 20. Double Counting in Multiple JOINs If both "orders" and "payments" have multiple rows per customer, joining them directly can create a many-to-many multiplication. Example: 2 orders × 3 payments = 6 joined rows. SUM() will overcount. Understand the grain of each table before joining. 🧠 21. JOINs and Table Grain Before writing a JOIN, identify: Table 1 - One row = one customer, Table 2 - One row = one order → One-to-Many relationship. Understanding table grain helps prevent: duplicate counts, inflated revenue, incorrect averages, incorrect KPIs. 🎤 SQL Interview Questions Q1. What is a JOIN? Combines rows from multiple tables using a related condition. Q2. What is the difference between INNER JOIN and LEFT JOIN? INNER returns only matching, LEFT returns all from left + matching from right. Q3. How do you find customers who never placed an order? LEFT JOIN + WHERE o.customer_id IS NULL Q4. What is a SELF JOIN? Joins a table to itself, for hierarchical relationships. Q5. What is a CROSS JOIN? Creates every possible combination. Q6. Why can JOINs create duplicate rows? Because of one-to-many or many-to-many relationships. Q7. Why should you understand table grain? Because grain determines how rows multiply and whether aggregations become inaccurate. Q8. What happens when there is no match in a LEFT JOIN? Columns from right become NULL. Q9. How do you count unique customers after a JOIN? COUNT(DISTINCT customer_id) Q10. Can a query contain multiple JOINs? Yes. 📝 Practice Questions Practice 1: Return customer names and their orders.

SELECT c.customer_name, o.order_id 
FROM customers c 
JOIN orders o ON c.customer_id = o.customer_id;

Practice 2: Find customers who have never ordered.

SELECT c.customer_id, c.customer_name 
FROM customers c 
LEFT JOIN orders o ON c.customer_id = o.customer_id 
WHERE o.customer_id IS NULL;

Practice 3: Calculate total spending per customer.

SELECT c.customer_id, c.customer_name, SUM(o.amount) AS total_spending 
FROM customers c 
JOIN orders o ON c.customer_id = o.customer_id 
GROUP BY c.customer_id, c.customer_name;

Practice 4: Return all customers and their order counts, including zero orders.

SELECT c.customer_id, c.customer_name, COUNT(o.order_id) AS order_count 
FROM customers c 
LEFT JOIN orders o ON c.customer_id = o.customer_id 
GROUP BY c.customer_id, c.customer_name;

Practice 5: Find number of unique customers who placed orders.

SELECT COUNT(DISTINCT c.customer_id) AS unique_customers 
FROM customers c 
JOIN orders o ON c.customer_id = o.customer_id;

🧪 Mini SQL Challenge Write a query that returns: Customer name, Product name, Category, Amount - Only orders > ₹1,000. Solution:

SELECT c.customer_name, p.product_name, p.category, o.amount 
FROM customers c 
JOIN orders o ON c.customer_id = o.customer_id 
JOIN products p ON o.product_id = p.product_id 
WHERE o.amount > 1000 
ORDER BY o.amount DESC;

📌 JOINs are the bridge between database tables. But writing a JOIN is only half the skill. A strong Data Analyst also understands: What each table represents → How tables are related → How rows will multiply → How that affects the KPI. Double Tap ❤️ For More ----- 1.64 ₽ · /balance_help

SELECT c.customer_id, c.customer_name, SUM(o.amount) AS total_spending 
FROM customers c 
INNER JOIN orders o ON c.customer_id = o.customer_id 
GROUP BY c.customer_id, c.customer_name;

💰 11. Include Customers with Zero Spending

SELECT c.customer_id, c.customer_name, COALESCE(SUM(o.amount), 0) AS total_spending 
FROM customers c 
LEFT JOIN orders o ON c.customer_id = o.customer_id 
GROUP BY c.customer_id, c.customer_name;

🔢 12. JOIN + COUNT()

SELECT c.customer_id, c.customer_name, COUNT(o.order_id) AS order_count 
FROM customers c 
LEFT JOIN orders o ON c.customer_id = o.customer_id 
GROUP BY c.customer_id, c.customer_name;

Why COUNT(o.order_id) instead of COUNT(*)? Because COUNT(*) would count the LEFT JOIN row even when the customer has no matching order. ⚠️ 13. A Very Common JOIN Mistake

SELECT ... WHERE o.amount > 500; -- This removes NULLs and behaves like INNER JOIN

Correct:

LEFT JOIN orders o ON c.customer_id = o.customer_id AND o.amount > 500;

Important concept: With an OUTER JOIN, the location of a filter can change the result. 🔗 14. Joining More Than Two Tables

SELECT c.customer_name, o.order_id, p.product_name, o.amount 
FROM customers c 
JOIN orders o ON c.customer_id = o.customer_id 
JOIN products p ON o.product_id = p.product_id;

🏢 15. Real-World Business Example

SELECT p.category, SUM(o.amount) AS total_revenue 
FROM orders o 
JOIN products p ON o.product_id = p.product_id 
GROUP BY p.category 
ORDER BY total_revenue DESC;

This is a typical Data Analyst query. 📈 16. JOIN + WHERE + GROUP BY + HAVING Question: «Find customers who spent more than ₹50,000.»

SELECT c.customer_id, c.customer_name, SUM(o.amount) AS total_spending 
FROM customers c 
JOIN orders o ON c.customer_id = o.customer_id 
GROUP BY c.customer_id, c.customer_name 
HAVING SUM(o.amount) > 50000 
ORDER BY total_spending DESC;

Logical flow: JOIN → GROUP BY → HAVING → ORDER BY 🪞 17. SELF JOIN A table can also be joined to itself.

SELECT e.employee_name AS employee, m.employee_name AS manager 
FROM employees e 
LEFT JOIN employees m ON e.manager_id = m.employee_id;

🔢 18. CROSS JOIN "CROSS JOIN" produces every possible combination of rows. 5 products x 4 regions = 20 rows 🚨 19. The Biggest JOIN Problem: Duplicate Rows One customer has five orders → customer appears five times. This is the natural result of a one-to-many relationship. If you want unique customers:

SELECT COUNT(DISTINCT c.customer_id)

🚀 SQL Roadmap 2026 — Part 10 SQL JOINs — Combining Data from Multiple Tables In real-world databases, information is rarely stored in one table. For example: customers, orders, products, payments, employees, departments A customer may exist in one table while their orders exist in another. JOINs allow us to combine related data from multiple tables. This is one of the most important SQL concepts for a Data Analyst. 🧠 1. Why Do We Need JOINs? Suppose we have two tables: customers

customer_id | customer_name
101         | Alice
102         | Bob
103         | Charlie

orders

order_id | customer_id | amount
1        | 101         | 500
2        | 101         | 800
3        | 102         | 300

The customer name is stored in "customers". The order amount is stored in "orders". To answer: «How much did each customer spend?» We need to combine the tables. That's where JOIN comes in. 🔗 2. Basic JOIN Structure

SELECT
    c.customer_name,
    o.order_id,
    o.amount
FROM customers c
JOIN orders o
    ON c.customer_id = o.customer_id;

Here: customers → c, orders → o. These are called table aliases. The condition: ON c.customer_id = o.customer_id tells SQL how the tables are related. 🔑 3. The JOIN Key A JOIN usually connects tables through a related column.

customers.customer_id ↓ orders.customer_id

Often: one table contains a primary key, another table contains the corresponding foreign key. Example: customers.customer_id → Primary Key, orders.customer_id → Foreign Key. 🧩 4. INNER JOIN "INNER JOIN" returns only rows that have a match in both tables.

SELECT c.customer_name, o.order_id, o.amount 
FROM customers c 
INNER JOIN orders o ON c.customer_id = o.customer_id;

Result:

Alice | 1 | 500
Alice | 2 | 800
Bob   | 3 | 300

Charlie is missing because Charlie has no matching order. Customers ∩ Orders - Only matching records. 👈 5. LEFT JOIN "LEFT JOIN" returns: All rows from the left table + matching rows from the right table.

SELECT c.customer_name, o.order_id, o.amount 
FROM customers c 
LEFT JOIN orders o ON c.customer_id = o.customer_id;

Result includes:

Charlie | NULL | NULL

🎯 6. Finding Customers Who Never Ordered This is a very common interview and analytics problem.

SELECT c.customer_id, c.customer_name 
FROM customers c 
LEFT JOIN orders o ON c.customer_id = o.customer_id 
WHERE o.customer_id IS NULL;

This technique is often called an anti-join pattern. 👉 7. RIGHT JOIN "RIGHT JOIN" returns: All rows from the right table + matching rows from the left table. In practice, many analysts prefer rewriting a RIGHT JOIN as a LEFT JOIN by switching table order because it is often easier to read. 🔄 8. FULL OUTER JOIN "FULL OUTER JOIN" returns: All rows from both tables, whether they match or not. Conceptually: LEFT JOIN + RIGHT JOIN It can reveal: matching records, customers without orders, orders without matching customers. ⚠️ Not every database supports "FULL OUTER JOIN" directly. 🆚 9. INNER JOIN vs LEFT JOIN • INNER JOIN = Returns only customers with matching orders. • LEFT JOIN = Returns all customers, including those without orders. Simple rule: INNER JOIN = matching records, LEFT JOIN = keep everything from the left table. 📊 10. JOIN + Aggregation Question: «How much has each customer spent?»

🚀 𝗧𝗔𝗧𝗔 𝗚𝗿𝗼𝘂𝗽 𝗙𝗥𝗘𝗘 𝗩𝗶𝗿𝘁𝘂𝗮𝗹 𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽 𝗣𝗿𝗼𝗴𝗿𝗮𝗺𝘀 😍 Tata Group/TCS virtual job simulations let you work through industry-style tasks and strengthen your resume. 🎓 3 FREE Virtual Programs: 📊 Data Visualisation 🔐 Cybersecurity 🌱 ESG (Environmental, Social & Governance) 💻 Virtual & flexible 🎓 Free Certificate on Completion 📄 Add the experience to your Resume/LinkedIn 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:- https://pdlink.in/4yoXEOI 🔥 Perfect for Students • Freshers • Job Seekers

🚨Here is a comprehensive list of #interview questions that are commonly asked in job interviews for Data Scientist, Data Analyst, and Data Engineer positions: ➡️ Data Scientist Interview Questions Technical Questions 1) What are your preferred programming languages for data science, and why? 2) Can you write a Python script to perform data cleaning on a given dataset? 3) Explain the Central Limit Theorem. 4) How do you handle missing data in a dataset? 5) Describe the difference between supervised and unsupervised learning. 6) How do you select the right algorithm for your model? Questions Related To Problem-Solving and Projects 7) Walk me through a data science project you have worked on. 8) How did you handle data preprocessing in your project? 9) How do you evaluate the performance of a machine learning model? 10) What techniques do you use to prevent overfitting? ➡️Data Analyst Interview Questions Technical Questions 1) Write a SQL query to find the second highest salary from the employee table. 2) How would you optimize a slow-running query? 3) How do you use pivot tables in Excel? 4) Explain the VLOOKUP function. 5) How do you handle outliers in your data? 6) Describe the steps you take to clean a dataset. Analytical Questions 7) How do you interpret data to make business decisions? 8) Give an example of a time when your analysis directly influenced a business decision. 9) What are your preferred tools for data analysis and why? 10) How do you ensure the accuracy of your analysis? ➡️Data Engineer Interview Questions Technical Questions 1) What is your experience with SQL and NoSQL databases? 2) How do you design a scalable database architecture? 3) Explain the ETL process you follow in your projects. 4) How do you handle data transformation and loading efficiently? 5) What is your experience with Hadoop/Spark? 6) How do you manage and process large datasets? Questions Related To Problem-Solving and Optimization 7) Describe a data pipeline you have built. 8) What challenges did you face, and how did you overcome them? 9) How do you ensure your data processes run efficiently? 10) Describe a time when you had to optimize a slow data pipeline. I have curated best 80+ top-notch Data Analytics Resources 👇👇 https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02 Hope this helps you 😊

🚀 𝗙𝗥𝗘𝗘 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝘁𝗼 𝗟𝗲𝗮𝗿𝗻 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 📊 Want to build a career in Data Analytics but don’t know where to start? Learn the most important skills completely FREE with these expert YouTube resources. 🔥 Learn → Practice → Build Projects → Become Job-Ready 🔗 𝗘𝗻𝗿𝗼𝗹𝗹 𝗳𝗼𝗿 𝗙𝗥𝗘𝗘 👇:- https://pdlink.in/4ysm4XS 🎯 Perfect for Students • Freshers • Job Seekers • Aspiring Data Analysts

This single query demonstrates a practical data-cleaning workflow using several string functions. 📌 Double Tap ❤️ For More ----- 1.57 ₽ · /balance_help

Think of it as a pipeline: Raw Data → TRIM() → LOWER()/UPPER() → REPLACE() → Clean Data ⚠️ 23. Common Mistakes Mistake 1 — Ignoring spaces: • 'Alice' and ' Alice' may behave as different values depending on the database and comparison context. • Use TRIM(customer_name) when appropriate. Mistake 2 — Ignoring capitalization: • Premium, premium, PREMIUM can create inconsistent groups. • Use UPPER(TRIM(customer_type)) when the business meaning is case-insensitive. Mistake 3 — Assuming all databases use the same syntax: • String functions differ between PostgreSQL, MySQL, SQL Server, and Oracle. • Always verify the syntax for your SQL dialect. Mistake 4 — Modifying data unnecessarily: • There is a difference between SELECT TRIM(name) and actually updating the stored value. • Always understand whether you're transforming data for analysis or permanently modifying the database. 🎤 SQL Interview Questions Q1. What is the purpose of string functions? • They are used to manipulate, clean, transform, search, and extract text data. Q2. What does TRIM() do? • It removes leading and trailing spaces from a string. Q3. Difference between UPPER() and LOWER()? • UPPER() converts text to uppercase. LOWER() converts text to lowercase. Q4. What does CONCAT() do? • It combines multiple strings into one value. Q5. What does REPLACE() do? • It replaces occurrences of one substring with another. Q6. How can you find the length of a string? • Commonly LENGTH(column_name) or, depending on the database, CHAR_LENGTH(column_name). Q7. How would you standardize customer categories? • For example UPPER(TRIM(customer_type)). This removes surrounding spaces and standardizes capitalization. Q8. How can you extract the last four characters of a value? • In databases supporting it: RIGHT(column_name, 4). Q9. How can you combine first and last names? • CONCAT(first_name, ' ', last_name) Q10. Why are string functions important for data analysts? • Because real-world text data often contains inconsistent capitalization, spaces, formats, prefixes, suffixes, and unwanted characters. 📝 Practice Questions Practice 1: Convert customer names to uppercase.

SELECT UPPER(customer_name) AS customer_name FROM customers;

Practice 2: Remove unnecessary spaces from product names.

SELECT TRIM(product_name) AS product_name FROM products;

Practice 3: Create a full name from first and last name.

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM customers;

Practice 4: Remove hyphens from phone numbers.

SELECT REPLACE(phone, '-', '') AS cleaned_phone FROM customers;

Practice 5: Find products whose names contain more than 50 characters.

SELECT * FROM products WHERE LENGTH(product_name) > 50;

🧪 Mini SQL Challenge You have this table: customers: customer_id, first_name, last_name, email, customer_type, phone Write a query that returns: Customer ID, Cleaned full name, Cleaned lowercase email, Standardized customer type, Phone number without hyphens. Solution:

SELECT
    customer_id,
    CONCAT(TRIM(first_name), ' ', TRIM(last_name)) AS full_name,
    LOWER(TRIM(email)) AS cleaned_email,
    UPPER(TRIM(customer_type)) AS customer_type,
    REPLACE(TRIM(phone), '-', '') AS cleaned_phone
FROM customers;

You might get separate groups for Premium, premium, PREMIUM. Instead:

SELECT UPPER(TRIM(customer_type)) AS customer_type, COUNT(*) AS customer_count 
FROM customers 
GROUP BY UPPER(TRIM(customer_type));

Now logically equivalent values can be grouped together. 🧹 20. Cleaning Product Names Suppose product names contain unnecessary spaces and inconsistent capitalization.

SELECT UPPER(TRIM(product_name)) AS cleaned_product_name FROM products;

You can also remove unwanted characters:

SELECT REPLACE(TRIM(product_name), '-', ' ') AS cleaned_product_name FROM products;

Example: ' wireless-earbuds ' can become wireless earbuds. 💼 21. Real-World Business Example Suppose an e-commerce company stores customer names inconsistently. You have ' alice ', 'ALICE', 'Alice', ' alice' You can create a normalized version:

SELECT UPPER(TRIM(customer_name)) AS normalized_name FROM customers;

This produces ALICE, ALICE, ALICE, ALICE. The cleaned value can be used for analysis or as part of a data-matching strategy. String normalization alone does not guarantee that two records represent the same person. 🧩 22. Combining Multiple String Functions SQL becomes particularly powerful when functions are combined.

SELECT UPPER(TRIM(customer_name)) AS cleaned_name FROM customers;
SELECT LOWER(TRIM(email)) AS cleaned_email FROM customers;

SELECT LEFT(product_code, 3) AS category_code FROM products;

If product_code = ELE12345, Result: ELE. This can be useful when codes contain meaningful prefixes. 👉 10. RIGHT() Returns characters from the end of a string.

SELECT RIGHT(account_number, 4) AS last_four_digits FROM accounts;

Example: 1234567890, Result: 7890. This is commonly useful for reporting or identifying records without displaying the complete identifier. 🔗 11. CONCAT() Combines multiple strings.

SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM customers;

Example: first_name = Alice, last_name = Smith, Result: Alice Smith. ⚠️ 12. CONCAT vs + Operator Some SQL dialects allow string concatenation using operators such as first_name + ' ' + last_name while others use first_name || ' ' || last_name. CONCAT() provides a more portable and readable approach, although NULL behavior can still vary by database. 🔄 13. REPLACE() Replaces one piece of text with another.

SELECT REPLACE(phone, '-', '') AS cleaned_phone FROM customers;

Example: 987-654-3210 becomes 9876543210.

SELECT REPLACE(product_name, 'Old', 'New') AS updated_name FROM products;

📧 14. Extracting Information from Email Addresses Suppose email = 'alice@gmail.com'. You may want to identify the domain. One approach is database-specific string manipulation. For example, in PostgreSQL:

SELECT SPLIT_PART(email, '@', 2) AS email_domain FROM customers;

Result: gmail.com This is useful for: • Customer segmentation • Domain analysis • Corporate vs personal email analysis • Detecting invalid domains 📊 15. Grouping Customers by Email Domain Once you extract the domain, you can aggregate it.

SELECT
    SPLIT_PART(LOWER(TRIM(email)), '@', 2) AS email_domain,
    COUNT(*) AS customer_count
FROM customers
WHERE email IS NOT NULL
GROUP BY SPLIT_PART(LOWER(TRIM(email)), '@', 2)
ORDER BY customer_count DESC;

This combines several concepts: TRIM() → LOWER() → SPLIT_PART() → GROUP BY → COUNT() → ORDER BY This is much closer to real-world analytics work. 🔎 16. POSITION() POSITION() finds where a substring occurs.

SELECT POSITION('@' IN email) AS at_position FROM customers;

For alice@gmail.com it returns the position of @. This can help identify whether a string contains a particular character. 🧪 17. String Functions for Data Validation Suppose you want to identify potentially invalid emails.

SELECT * FROM customers WHERE email IS NOT NULL AND POSITION('@' IN email) = 0;

This doesn't prove an email is valid, but it can identify obviously problematic records. For serious validation, application-level validation or dedicated data-quality tools may be more appropriate. 🏷️ 18. Standardizing Categories Suppose your database contains Premium, premium, PREMIUM, Premium. These may represent the same business category. You can standardize them:

SELECT UPPER(TRIM(customer_type)) AS standardized_type FROM customers;

Now they all become PREMIUM. This is particularly useful before grouping. 📈 19. String Functions + GROUP BY Without cleaning:

SELECT customer_type, COUNT(*) AS customer_count FROM customers GROUP BY customer_type;

🚀 SQL Roadmap 2026 — Part 9 SQL String Functions — Cleaning & Transforming Text Data In real-world databases, a huge amount of information is stored as text: • Customer names • Email addresses • Phone numbers • Product names • Cities • Categories • Addresses • Job titles But text data is rarely perfectly clean. You may encounter: • ' Alice ' • 'alice@example.com' • 'ALICE@EXAMPLE.COM' • 'Premium Customer' • ' Mumbai' SQL string functions allow you to clean, search, extract, combine, and transform text directly inside your queries. 🧠 1. What Are String Functions? String functions are SQL functions that operate on text values. Common functions include: • LENGTH() • UPPER() • LOWER() • TRIM() • LTRIM() • RTRIM() • SUBSTRING() • LEFT() • RIGHT() • CONCAT() • REPLACE() • POSITION() • CHAR_LENGTH() Exact function names and syntax can vary slightly between databases such as PostgreSQL, MySQL, SQL Server, and Oracle. 🔠 2. UPPER() Converts text to uppercase.

SELECT
    customer_name,
    UPPER(customer_name) AS uppercase_name
FROM customers;

Example: Alice becomes ALICE Useful for: • Standardizing text • Case-insensitive comparisons • Creating reports • Data cleaning 🔡 3. LOWER() Converts text to lowercase.

SELECT
    LOWER(email) AS email
FROM customers;

Example: ALICE@EXAMPLE.COM becomes alice@example.com A common data-cleaning pattern is:

SELECT
    LOWER(TRIM(email)) AS cleaned_email
FROM customers;

This handles both unnecessary spaces and inconsistent capitalization. 🧹 4. TRIM() Removes leading and trailing spaces.

SELECT
    TRIM(customer_name) AS cleaned_name
FROM customers;

For example ' Alice ' becomes 'Alice' This is extremely useful when importing data from Excel, CSV files, APIs, and external systems. ↩️ 5. LTRIM() and RTRIM() • LTRIM() removes spaces from the beginning:

  SELECT LTRIM(customer_name) FROM customers;
  

• RTRIM() removes spaces from the end:

  SELECT RTRIM(customer_name) FROM customers;
  

• While TRIM() generally handles both sides:

  SELECT TRIM(customer_name) FROM customers;
  

📏 6. LENGTH() Returns the number of characters in a string.

SELECT
    customer_name,
    LENGTH(customer_name) AS name_length
FROM customers;

Example: • Alice → 5 • Robert → 6 Function behavior can vary across SQL dialects, particularly with multibyte characters. 🔍 7. Finding Long or Short Values String length can be useful for data-quality checks. Example:

SELECT * FROM customers WHERE LENGTH(phone) < 10;

This can help identify potentially invalid phone numbers.

SELECT * FROM products WHERE LENGTH(product_name) > 100;

This can identify unusually long product descriptions. ✂️ 8. SUBSTRING() SUBSTRING() extracts part of a string. A common form is: SUBSTRING(column_name, start_position, length)

SELECT SUBSTRING(customer_name, 1, 3) AS first_three_characters FROM customers;

For Alexander the result would be Ale. Syntax differs by database, so always check the dialect you're using. 👈 9. LEFT() Returns characters from the beginning of a string.