ViewTube

How to Install Oracle & SQL Developer on Windows 10/11 This video shows how to download and install Oracle SQL Developer ...

Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpkj-sql-cheat-sheets/?video=g4pNdyK1olY Master SQL ...

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

Transform your architecture with AI built into the database. The Oracle AI Database unifies vectors, JSON, relational, graph, and ...

In this video, we explore the native BOOLEAN datatype in Oracle AI Database (Oracle 23ai and 26ai) and how it completely ...

In this lesson, you'll get an introduction to group functions, also known as aggregate or analytical functions. What you'll learn: ...

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

In this lesson, you'll learn how to join tables using the USING keyword, a cleaner alternative to natural joins when column names ...

In this lesson, we cover how to convert text into DATE, TIMESTAMP, and TIMESTAMP WITH TIME ZONE values in Oracle SQL.

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

In this lesson, you'll get an overview of SQL joins and why they're essential when working with relational databases. What ...

In this lesson, you'll learn how to combine or “nest” functions within SQL queries. What you'll learn: How to nest multiple ...

In this lesson, you'll learn what non-equijoins are and how they differ from the more common equijoins used in SQL. What you'll ...

In this lesson, we explore the DECODE function, an alternative to CASE for handling conditional logic in SQL. What you'll learn: ...

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

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 lesson, you'll learn how to use the SUM, AVG, and MEDIAN group functions to perform calculations across multiple rows in ...

In this lesson, you'll learn how to filter grouped results using the HAVING clause. What you'll learn: Why the WHERE clause ...

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