Operate with Database Objects

• Basic Query Syntax
• Create and Manage Tables
  • Create tables
• Insert, Update and Delete Row Data
  • Insert rows
  • Update existing rows
  • Delete rows
  • Truncate table
  • Vacuum database
• Create and Manage Views
  • Create views
  • Drop views
  • Best practices when creating views
• Create and Manage Materialized Views
  • Create materialized views
  • Refresh or deactivate materialized views
  • Drop materialized views
• Create and Manage indexes
  • Index types
  • Manage indexes
  • Index-only scan and covering index
  • Backward index scan
  • Check index usage
• BRIN Indexes
  • Maintain BRIN indexes
• Work with Transactions
  • Transaction isolation levels
• Transaction Concurrency Control
  • Multi-version concurrency control
  • Lock modes
  • Global deadlock detector
• Choose Table Storage Model
  • Heap and Append-optimized Table Storage Models
  • PAX Storage Format
  • UnionStore Storage Format
• Cross-Cluster Federated Query
  • User scenarios
  • Usages
• Use Tags to Manage Database Objects
  • What is a tag?
  • Features of tags
  • Usage scenarios
  • Use tags
  • System tables related to tags
  • Common errors and tips