Do You Have a Running Database in Your PC?
Why to know the Oracle Database Architecture and how much to know?
Oracle Database Architecture Overview (Part 1)
Oracle Database Architecture Overview (Part 2)
Database Data Blocks in Detail
How a DML is processed and committed
Automatic Memory Management
Oracle Database Storage Architecture
Logical and Physical Database Structure
Quiz - Database Architecture
How an SQL Statement is Processed?
Why do we need the Optimizer?
Selectivity & Cardinality
What is "cost" in detail?
SQL Tuning Principles and Strategies
SQL Tuning Basics Assessment Test
Execution Plan and Explain Plan in Details
Generating Statistics (Part 1)
Generating Statistics (Part 2)
Generating Statistics (Part 3)
Generating Statistics (Code Samples)
Generating Execution Plan
Generating Execution Plan (Code Samples)
V$SQL_PLAN (Code Samples)
Reading the Execution Plans (Part 1)
Reading the Execution Plans (Part 2)
Reading the Execution Plans (Code Samples)
Analyzing the Execution Plans
Analyzing the Execution Plans (Code Samples)
Execution Plans & Statistics
What are Indexes and How They work in details?
Types of Table and Index Access Paths
Table Access Full (Code Samples)
Table Access by ROWID (Code Samples)
Index Range Scan (Code Samples)
Index Full Scan (Code Samples)
Index Fast Full Scan (Code Samples)
Index Skip Scan (Code Samples)
Index Join Scan (Code Samples)
Table & Index Access Paths
How to find a performance problem and its tuning solution?
Ways of Getting the Execution Plan and the Statistics
Using the Real-Time SQL Monitoring Tool Part 1
Using the Real-Time SQL Monitoring Tool Part 2
Using the Real-Time SQL Monitoring Tool Part 3
CODE: Using the Real-Time SQL Monitoring Tool
Using the Trace Files & TKPROF Utility - Part 1
Using the Trace Files & TKPROF Utility - Part 2
Using the Trace Files & TKPROF Utility - Part 3
CODE: Using the Trace Files & TKPROF Utility
CODE: Get What You Need Only
Using Concatenation Operator
CODE: Using Concatenation Operator
Using Arithmetic Operators
CODE: Using Arithmetic Operators
CODE: Using Like Conditions
Using Functions on the Indexed Columns
CODE: Using Functions on the Indexed Columns
Handling NULL-Based Performance Problems
CODE: Handling NULL-Based Performance Problems
Using EXISTS instead of IN Clause
Using TRUNCATE instead of DELETE command
CODE: Using TRUNCATE instead of DELETE command
CODE: Tuning Ordered Queries
Retrieving the MIN & MAX Values
CODE: Retrieving the MIN & MAX Values
UNION and UNION ALL Operators (Which one is faster?)
UNION and UNION ALL Operators (Which one is faster?)
Avoid Using the HAVING Clause!
CODE: Avoid Using the HAVING Clause!
CODE: Be Careful on Views!
Create Materialized Views
CODE: Create Materialized Views
Avoid Commit Too Much or Too Less!
CODE: Tuning the Join Order
Multitable DML Operations
CODE: Multitable DML Operations
CODE: Using Temporary Tables
CODE: Combining SQL Statements
Using Analytical Functions
CODE: Using Analytical Functions
Why Indexing is Important?
Index Selectivity & Cardinality
B-Tree Indexes in Details
CODE: B-Tree Indexes in Details
Bitmap Indexes in Details
CODE: Bitmap Indexes in Details
Composite Indexes and Order of Indexed Columns
CODE: Composite Indexes and Order of Indexed Columns
CODE: Bitmap Join Indexes
CODE: Combining Bitmap Indexes
CODE: Function-Based Indexes
CODE: Index-Organized Tables
Index Key Compression- Part 1
Index Key Compression- Part 2
CODE: Index Key Compression
CODE: Full-Text Search Indexes
CODE: Tuning Star Queries
CODE: Using Bind Variables
Beware of Bind Variable Peeking
CODE: Beware of Bind Variable Peeking
CODE: Adaptive Cursor Sharing
Dynamic Statistics (Dynamic Sampling)
CODE: Dynamic Statistics (Dynamic Sampling)
About the Database Installation
The Ways to Get a Database
Option 1: Installing VMware and VirtualBox on Windows
Option 1: How to Install the Virtual Box on Mac OS X?
Option 1: Downloading Virtual Machine Image (19c)
Option 1: Downloading Virtual Machine Image(If the previous lecture didn't work)
Option 1: Configuring the VMware Virtualization Software
Option 1: Configuring the Oracle VirtualBox Virtualization Software
Option 1: Configuring SQL Developer inside of the Virtual Machine
Option 2: What is Pluggable Database?
Option 2: Downloading and Installing the Oracle Database
Option 2: Unlocking the HR Schema
Option 2: Configuring and Using Oracle SQL Developer
Option 2: Installing Sample Schemas in Oracle Database
Option 2: How to Unlock the HR Schema in the Oracle Database 12c?
Option 2: Oracle Database 12c Installation into Your Computer
Option 2: Configuring and Using Oracle SQL Developer for Oracle Database 12c