SQL and Database explained! - VideoAndMovie

Need to understand SQL and Databases? You have come to the right place!

JSON Duality Views 101

3:45

JSON Duality Views 101

The Mysterious Jump between ACCESS and FILTER

9:14

The Mysterious Jump between ACCESS and FILTER

Virtual Columns get a boost in 23ai

5:23

Virtual Columns get a boost in 23ai

Deep Dive on 23ai Transaction Priorities

7:49

Deep Dive on 23ai Transaction Priorities

Is APPEND_VALUES really worth it?

9:06

Is APPEND_VALUES really worth it?

Can you give me a job reference?

3:33

Can you give me a job reference?

Store your Data Anywhere and STILL run SQL against it!

9:53

Store your Data Anywhere and STILL run SQL against it!

23ai - When Large Objects are not THAT large

5:11

23ai - When Large Objects are not THAT large

TURBO mode for reading Excel files from the database!

6:54

TURBO mode for reading Excel files from the database!

Partitioning on a budget

5:10

Partitioning on a budget

The ROLLUP cheat code that makes aggregation easy!

3:22

The ROLLUP cheat code that makes aggregation easy!

Keep track of all of your SQL statements

3:10

Keep track of all of your SQL statements

The FASTEST way to avoid DUPLICATE data

7:21

The FASTEST way to avoid DUPLICATE data

Converting LONG to CLOB - the performance trap!

6:32

Converting LONG to CLOB - the performance trap!

Quick Thoughts on Edition Based Redefinition (EBR)

1:51

Quick Thoughts on Edition Based Redefinition (EBR)

Data Redaction gets a BOOST in 23ai

10:37

Data Redaction gets a BOOST in 23ai

SQL Outlines, SQL Profiles and the Hints you should NOT use

7:23

SQL Outlines, SQL Profiles and the Hints you should NOT use

Hierarchical queries - Looking beyond CONNECT BY

8:34

Hierarchical queries - Looking beyond CONNECT BY

Can you UNPARTITION a table that is partitioned?

7:22

Can you UNPARTITION a table that is partitioned?

Make a table PARTIALLY read only

10:31

Make a table PARTIALLY read only

Build your own Database MULTIMEDIA engine!

9:14

Build your own Database MULTIMEDIA engine!

Which reserved words are REALLY reserved?

5:59

Which reserved words are REALLY reserved?

Which tables are BUSIEST on my database?

5:43

Which tables are BUSIEST on my database?

It's the DATA TYPES !

1:29

It's the DATA TYPES !

2025 ... My Predictions!

3:21

2025 ... My Predictions!

2024...Best...Year...Ever!

1:22

2024...Best...Year...Ever!

What is INTERNAL_FUNCTION in my execution plan?

4:39

What is INTERNAL_FUNCTION in my execution plan?

MONTH arithmetic is HARD! Even with ADD_MONTHS

6:58

MONTH arithmetic is HARD! Even with ADD_MONTHS

Blasting past the 1000-item limit for IN-LIST

8:09

Blasting past the 1000-item limit for IN-LIST

Performance boost for ALL_ARGUMENTS

5:20

Performance boost for ALL_ARGUMENTS