Operate with Data

• Operate with Database Objects
  • Basic Queries
  • Create and Manage indexes
  • 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
• Table Storage Format
  • Applicable scenarios
  • Usage
  • Limitations of Cloud tables
  • SQL options for the Cloud format
  • Cloud storage configuration parameters (GUC)
  • Aggregate query optimization
  • Best practices
• Perform SQL Queries
  • Table Join Queries
  • Cross-Cluster Federated Query
  • Query TpServer Data
• Advanced Data Analytics
  • Directory Tables
  • Use pgvector for Vector Similarity Search
  • Vectorization Query Computing
  • Geospatial Data Analysis with PostGIS
• Work with Transactions
  • Transaction isolation levels
• Control Transactional Concurrency
  • MVCC mechanism
  • Lock modes
• Using TpServer Nodes
  • Basic Architecture
  • Key Concepts
  • Use Cases
  • Usage Methods
  • Important Notes
  • Reference - Related System Tables