Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Functions Masterclass: Text, Date, Numeric, and NULL Fun
New
Rating: 4.5 out of 5(1 rating)
149 students

SQL Functions Masterclass: Text, Date, Numeric, and NULL Fun

Learn how to use SQL text, date, numeric, and NULL functions to clean, transform, and analyze data efficiently.
New
Created byMousa Al-Salahi
Last updated 8/2026
English
English [Auto],

What you'll learn

  • Write SQL queries using text, date, and numeric functions.
  • Clean and transform data using built-in SQL functions.
  • Work with dates, strings, and numbers in real-world examples.
  • Apply SQL functions to solve practical data analysis tasks.

Course content

3 sections • 10 lectures • 1h 17m total length

  • 22 - concat english6:25
  • 23 - trim upper lower english5:17

    Explore SQL string functions by applying upper and lower case transformations, using trim to remove spaces, and aliasing results to show what the data is about.

  • 24 - replace substring english11:56
  • 25 - length english1:37

    This lecture explains the length function (length/len) to count characters in a column, demonstrated on the city column across rows and dialect variations like Postgres vs SQL Server.

Requirements

  • No prior SQL experience is required.
  • Basic computer skills are helpful.
  • A computer and internet connection are needed.
  • We will start from the basics, so beginners are welcome.

Description

In this course, you will learn how to use SQL functions effectively to clean, transform, and analyze data with confidence. SQL functions are one of the most useful parts of the language because they help you work with text, dates, numbers, and missing values in a practical and efficient way. Instead of writing complex queries from scratch every time, you will discover how built-in SQL functions can make your work faster, cleaner, and more professional. Throughout the course, we will focus on the most important categories of SQL functions, including text functions for handling strings, date and time functions for working with time-based data, numeric functions for performing calculations, and general functions for managing NULL values and other common situations. Each lesson is designed with clear explanations and practical examples so that you can immediately apply what you learn. Whether you are preparing for a job interview, improving your data analysis skills, or working on real database projects, this course will help you build strong and practical SQL knowledge. By the end of the course, you will be able to write queries that are more powerful, solve common data problems more efficiently, and understand how SQL functions support real-world reporting and analysis tasks. This course is suitable for beginners who want to learn step by step, as well as learners who already know basic SQL and want to improve their skills with hands-on practice.

  • Use SQL text functions to manipulate and format string data.

  • Apply date and time functions to work with calendar and timestamp values.

  • Perform calculations using numeric and mathematical SQL functions.

  • Handle NULL values and common data issues more effectively.

  • Clean and transform data for analysis and reporting.

  • Write more practical and efficient SQL queries for real-world use.

  • Improve your confidence in solving SQL problems through practice.

Who this course is for:

  • Aspiring data analysts and data professionals.
  • Beginners who want to learn SQL functions from scratch.
  • Anyone who works with databases and wants to improve query-writing skills.
  • Students and job seekers who want practical SQL skills for interviews and real projects.
  • Learners who want to clean, transform, and analyze data using SQL.

Report abuse