Operate with Data

• Operate with Database Objects
  • Basic Queries
  • Create and Manage Warehouses
  • Create and Manage Tables
  • Create and Manage Views
  • Create and Manage Materialized Views
  • Insert, Update, and Delete Row Data
  • Use Tags to Manage Database Objects
  • Data Branching
• Choose Table Storage Model
  • Heap and Append-optimized Table Storage Formats
• Perform SQL Queries
  • Table Join Queries
  • Cross-Cluster Federated Query
• Advanced Data Analytics
  • Directory Tables
  • Use pgvector for Vector Similarity Search
  • Vectorization Query Computing
• Work with Transactions
  • Transaction isolation levels
• Control Transactional Concurrency
  • MVCC mechanism
  • Lock modes
  • Global Deadlock Detector