- Natural key and surrogate key
- Overview of PL/SQL
- PL/SQL – Basic Syntax
- PL/SQL %ROWTYPE Attribute
- Introduction to database objects
- Direct Access to Objects in Another Schema
- Data dictionary views in Oracle
- SYS and SYSTEM Users in Oracle
- Joins – An Introduction
- Equijoin in Oracle
- Band Join in Oracle
- Cartesian Product of Tables in Oracle
- inner join in Oracle
- Outer join in Oracle
- Semi-join in Oracle
- Anti-Join in Oracle
- EXISTS Condition in Oracle
- Concurrency Anomalies in Databases: Dirty Read, Non-Repeatable Read, and Phantom Read
- Isolation Levels in Databases: Read Uncommitted, Read Committed, Repeatable Read, and Serializable
- How Databases Enforce Isolation
- Understanding the 9 Types of Database Locks
- How to avoid deadlocks in database transaction?
- Database Normalization
- Views vs Materialized Views in Oracle
- Oracle Indexes
- Aggregate Functions in SQL
- COALESCE() Function
- NVL() Function
- DENSE_RANK() Function
- PARTITION BY Clause
- PIVOT Operator
- ROWNUM in Oracle
- ROW_NUMBER()
- ROWID in Oracle
SQL query questions
- How to Delete Duplicate Records from a Table in Oracle SQL
- How to Read Top 5 Records from a Table in Oracle SQL
- How to read last 5 rows?
- How to Find the Employee with Second Maximum Salary in Oracle SQL
- Find the Employee with the 3rd Highest Salary in Oracle
- Temperature is higher than the previous day’s