Course Introduction
  • Introduction
  • UDEMY 101: How to Use Udemy? +Some Useful Tips
Software Installation
  • About the Database Installation
  • Which Option to Choose to Have a Database?
  • Option 1: Having the Database with the Oracle Virtual Box
  • Option 1: How to Install the Virtual Box on Mac OS X?
  • What is Pluggable Database (Multitenant Architecture)?
  • Option 2: Downloading And Installing the Oracle Database
  • Option 2: Unlocking the HR Schema
  • Option 2: Configuring and Using the SQL Developer
  • Option 3: Using Oracle Live SQL
  • Option 3: About Oracle Live SQL Restrictions
  • The Sample (HR) Schema Used in This Course
Introducing Database Objects
  • Introducing Database Objects and Reaching Another User's Objects
  • Reaching Another User's Objects
  • The Working Document
  • Don't Forget to Leave a Rating!
  • Code Samples
  • Quiz 1
Data Dictionary Views
  • What Are Data Dictionary Views?
  • What Is There In Data Dictionary Views?
  • Dictionary Table
  • Differences Between USER, ALL, DBA, V$ Prefixes
  • USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views
  • USER_TABLES View
  • USER_TAB_COLUMNS View
  • User Constraints View
  • USER_CONS_COLUMNS View
  • USER_TAB_COMMENTS & USER_COL_COMMENTS Views
  • Quiz 2
Creating, Using and Managing Sequences
  • What is a Sequence and Why is It Used For?
  • Creating Sequences
  • Modifying Sequences
  • Dropping Sequences
  • Using Sequences
  • Using Sequences As a Default Value
  • Sequence Caching
  • User Sequences
  • Quiz 3
Creating, Using and Analyzing Synonyms
  • What Is a Synonym and Why Is It Used For?
  • Creating & Dropping Synonyms
  • Using Synonyms
  • Analyzing USER_SYNONYMS
  • Quiz 4
Understanding Indexes
  • What is an Index and Why is It Used For?
  • Types of Indexes
  • Creating Indexes
  • Creating Index on Table Creation
  • Function Based Indexes
  • Multiple Indexes With Same Columns
  • Dropping Indexes
  • USER_INDEXES and USER_IND_COLUMNS Views
  • Quiz 5
Managing Views
  • What is a View and Why Is It Used For?
  • Types Of Views
  • Creating Simple Views
  • Creating Complex Views
  • Modifying Views
  • Analyzing User Views
  • Performing DML Operations with Views
  • Using WITH CHECK OPTION Clause
  • Preventing DML Operations on A View
  • Dropping Views
  • Quiz 6
Materialized Views
  • What is a Materialized View and Why is it Used For?
  • Creating Materialized Views Part 1
  • Creating Materialized Views Part 2
  • Complex Materialized Views
  • Types of Refreshing Materialized Views
  • Refreshing Materialized Views Manually
  • Scheduling Periodic Refresh of Materialized Views
  • Quiz 7
Using Advanced Subqueries
  • Using Subqueries as a Source
  • Scalar Subqueries
  • Multiple Column Subqueries
  • Correlated Subqueries
  • EXISTS Operator
  • NOT EXISTS Operator
  • Using WITH Clause
  • Using Recursive WITH Clause
  • Inserting Data By Using a Subquery as a Target
  • Manipulating Data by Using "WITH CHECK OPTION" Keyword
  • Correlated Update
  • Correlated Delete
  • Quiz 8
Advanced Data Manipulations
  • Using DEFAULT Keyword on Insert And Update Statements
  • Multitable Insert Statements
  • Unconditional Insert Statements
  • Conditional Insert Statements