Oracle 19c SQL

• 1 Oracle SQL Basics
  • 1.1 Introduction to Oracle SQL
  • 1.2 Types of Commands in SQL
  • 1.3 Building Blocks of Oracle SQL
  • 1.3.1 Schema Objects
  • 1.3.2 Data Types
  • 1.3.3 Operators
  • 1.3.4 Literals
  • 1.3.5 Variables
  • 1.3.6 Constants
  • 1.3.7 Substitution Variables
  • 1.3.8 NULL in Oracle
• 2 Parts of Oracle SQL Query
  • 2.1 FROM Clause
  • 2.2 DUAL Table
  • 2.3 Starting with SELECT
  • 2.4 WHERE Clause
  • 2.5 ORDER BY Clause
  • 2.6 GROUP BY Clause
  • 2.7 HAVING Clause
  • 2.8 Query Execution Order
• 3 Oracle Functions
  • 3.1 Functions Overview
  • 3.1.1 Single Row Functions
  • 3.1.1.1 Character Functions
  • Character Functions: UPPER, LOWER, INITCAP
  • Character Functions: LENGTH, CONCAT
  • Character Functions: SUBSTR, INSTR
  • Character Functions: LPAD, RPAD
  • Character Functions: REPLACE, TRANSLATE
  • Character Functions: CHR, ASCII, SOUNDEX
  • 3.1.1.2 Number Functions
  • 3.1.1.3 DATE and TIME FUNCTION
  • 3.1.1.4 CONVERSION FUNCTION
  • 3.1.2 Multiple Row Functions
  • 3.1.3 Hierarchical Functions
  • 3.1.4 Analytical Functions
• 4 Joins in Oracle
  • 4.1 Understanding Joins
  • 4.2 Cartesian Product
  • 4.3 Types of Join in Oracle
  • 4.4 Equi Join
  • 4.5 Non-equi Join
  • 4.6 Self Join
  • 4.7 Outer Join
  • 4.8 ANSI Join
  • 4.9 SQL Joins Deep Dive – Part1
  • 4.10 SQL Joins Deep Dive – Part2
• 5 Subqueries In Oracle
  • 5.1 Working with Subqueries
  • 5.1 Nested Subquery
  • Inline Subquery
  • 5.3 Subselect Subquery
  • Correlated Subquery
• 6 SET Operators
  • 6.1 What are SET operators?
  • 6.2 UNION
  • 6.3 UNION ALL
  • 6.4 INTERSECT
  • 6.5 MINUS
• 7 Pseudo Columns
  • 7.1 What are Pseudo Columns in Oracle
  • 7.2 ROWNUM
  • 7.3 ROWID
• 8 Hierarchical Query
  • 8.1 Working with hierarchical queries
  • 8.2 Hierarchical Functions
  • 8.3 Pseudo Columns in hierarchical queries
  • 8.4 ORDER SIBLINGS BY Clause
  • 8.5 Some more hierarchical queries
• 9 Constraints
  • 9.1 Understanding Data Integrity
• 10 Sequences
  • 10.1 Create and drop Sequences in Oracle
  • 10.2 Working with Sequences
  • 10.3 Sequence in DML
• 11 Views
  • 11.1 Views Overview
  • 11.2 Creating Views in Oracle
  • 11.3 DML operation in Views
  • 11.4 Types of Views
• 12 Indexes in Oracle
  • 12.1 Understanding Indexes
• SQL Functions
  • UPPER
  • LOWER
  • INITCAP
  • LENGTH
  • CONCAT
  • SUBSTR
  • INSTR
  • LTRIM
  • RTRIM
  • TRIM
  • LPAD and RPAD
  • REPLACE
  • TRANSLATE