ViewTube

MENTORSHIP – Ready to become a standout data analyst? Applications for the March 2026 cohort are now open! Apply here ...

In this episode, we are looking at SQL commands in programmed functions and the new SQL Query button, where we write SQL ...

In this lesson, we introduce Single Row Functions, also known as scalar functions in SQL. Single row functions process data row ...

In this lesson, we explore nesting SQL functions and why combining functions is essential for real-world data manipulation.

In this lesson, we explore Oracle SQL analytical functions LAG and LEAD and how they work with the OVER clause to access ...

In this lesson, we learn how to extract parts of a string in Oracle SQL using the SUBSTR function. What you'll learn: How ...

In this video, you will learn the difference between WHERE and HAVING in SQL with practical examples using an Employees table ...

In this quick lesson, we cover how to measure the length of a string in Oracle SQL using the LENGTH function. It's simple, fast, and ...

Which SQL Mistake Did You Make in 2025? Want more guided learning, practice packs, and deep-dive SQL content? You'll find ...

In this lesson, we explore the INITCAP character function in SQL. This function formats text by converting the first letter of each ...

In this lesson, we learn how to concatenate strings in Oracle SQL using different approaches. You'll see how to combine columns, ...

In this lesson, we explore Oracle SQL date functions and how to work with dates, times, and intervals. ⏱ What you'll learn: Getting ...

In this lesson, we explore the SOUNDEX function in Oracle SQL, which allows you to find words that sound similar, even if they ...

In this lesson, we cover the most important numerical functions in Oracle SQL, used for calculations, rounding, and numeric ...

In this lesson, we learn how to use the UPPER and LOWER character functions in SQL. These functions convert text to uppercase ...

In this lesson, we explore how to remove unwanted characters from strings in Oracle SQL using trimming functions like RTRIM, ...

In this lesson, we dive into Oracle SQL analytical functions and learn how to calculate running totals and window-based ...

In this lesson, we explore text padding in Oracle SQL using the LPAD and RPAD functions. You'll learn how to format output by ...

Learn how to find duplicate records in SQL using GROUP BY and COUNT() function. In this video I will show how to detect ...

In this lesson, we learn how to search for text inside a string in Oracle SQL using the INSTR function. It helps you find the exact ...