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 Oracle SQL analytical functions LAG and LEAD and how they work with the OVER clause to access ...

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

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 quick lesson, we cover how to measure the length of a string in Oracle SQL using the LENGTH function. It's simple, fast, and ...

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

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 cover the most important numerical functions in Oracle SQL, used for calculations, rounding, and numeric ...

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 explore how to remove unwanted characters from strings in Oracle SQL using trimming functions like RTRIM, ...

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 learn how to concatenate strings in Oracle SQL using different approaches. You'll see how to combine columns, ...

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 Oracle SQL date functions and how to work with dates, times, and intervals. ⏱ What you'll learn: Getting ...

Download the PowerPoint & All Queries: https://www.dondata.ai This is a complete SQL (T-SQL) course for data analytics — from ...

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 ...

In this lesson, we take a quick look at additional Oracle SQL analytical functions commonly used in reporting and data analysis.