SQL Concepts

Database Concepts

• Relational Data Modeling
  • Relational Model
  • Normalization
• Types of Keys
• Row vs. Column Store
• Types of Partitioning

SQL Concepts

• SQL Statement Order
• Query Processing Order
• Truncate, Delete & Drop Command
• Count Command
• Multiple Row Subquery Operator
• Types of Joins

SQL Objects

• Types of Indexes
• Views
• Materialized View

Having Clause: Filter records based on Aggregate Functions
Qualify Clause: Filter records based on Analytical Functions