ViewTube

Welcome to the first practical session in my Oracle DBA learning journey! In this tutorial, we'll set up our Oracle DBA lab ...

Oracle Database 26ai new feature | Empty String on NULL for JSON Generation Explained In this video, you will learn about ...

What actually happens inside an Oracle Database when you INSERT, UPDATE, DELETE, ROLLBACK or execute DDL? Oracle ...

Put new data into a table. In this advanced-level lesson, "INSERT: Adding Rows", you type real queries, see the real results on ...

Design tables that protect your data. In this advanced-level lesson, "CREATE TABLE and Constraints", you type real queries, see ...

Python and Oracle Database Connectivity – Practical Programming Example | PDBC Episode 160 | Aman Codes Want to learn ...

10 query challenges. In this beginner-level lesson, "Beginner Workout: 10 Query Challenges", you type real queries, see the real ...

Oracle APEX Developers - Oracle Database Administrators (DBAs) - Oracle APEX Consultants - Enterprise application support ...

Spot repeated rows and clean them up. In this intermediate-level lesson, "Find and Remove Duplicates", you type real queries, ...

Save a query under a name. In this advanced-level lesson, "Views", you type real queries, see the real results on screen, and ...

All changes succeed, or none do. In this advanced-level lesson, "Transactions: COMMIT and ROLLBACK", you type real queries, ...

Add logic inside your queries. In this beginner-level lesson, "CASE: If-Then-Else in SQL", you type real queries, see the real ...

Keep only the groups you want. In this beginner-level lesson, "HAVING: Filtering Groups", you type real queries, see the real ...

Look at the previous and next row. In this advanced-level lesson, "LAG and LEAD", you type real queries, see the real results on ...

Walk a tree: boss, reports, reports of reports. In this advanced-level lesson, "Recursive CTEs: Org Charts", you type real queries, ...

Name a query, then use it. In this advanced-level lesson, "CTEs: The WITH Clause", you type real queries, see the real results on ...

Combine tables on matching keys. In this intermediate-level lesson, "INNER JOIN", you type real queries, see the real results on ...

The typical value, beyond the average. In this advanced-level lesson, "Median and Percentiles", you type real queries, see the ...

Pay, grades, tenure and structure. In this advanced-level lesson, "Case Study: HR Analytics", you type real queries, see the real ...