ViewTube

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

SQL vs NoSQL Database Comparison: Real-World Examples. - The Software Architect's Roadmap [Playlist]: ...

Using SELECT * can slow down your database Always select only required columns to improve performance ⚡ Follow for daily ...

A short(ish) description of what you can expect during my precon "Execution plans explained"

We detail the required composite indexing strategies, the specific SQL syntax using compound WHERE clauses, and how to ...

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

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

They can be used almost anywhere in a SQL statement where expressions are allowed. Topics covered: What single row ...

Learn how to install Microsoft SQL Server 2025 on Windows 10. With that, we will also install SQL Server Management Studio.

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

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

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

Every Java team debates Hibernate at some point: productivity champion or performance liability? Both are right. This video ...