Operate with Data

• Operate with Database Objects
  • Basic Query Syntax
  • Create and Manage Tables
  • Insert, Update and Delete Row Data
  • Create and Manage Views
  • Create and Manage Materialized Views
  • Create and Manage indexes
  • BRIN Indexes
  • Work with Transactions
  • Transaction Concurrency Control
  • Choose Table Storage Model
  • Cross-Cluster Federated Query
  • Use Tags to Manage Database Objects
• SQL Queries
  • Join Queries
• Advanced Analytics
  • Use pgvector for Vector Similarity Search
  • Vectorization Query Computing
  • Use MADlib for Machine Learning and Deep Learning
  • Directory Tables
  • Use RoaringBitMap Bitmap Operations
• Auto-Execute SQL commands
  • Syntax description
  • View Create Task metadata
  • Parameter tuning description
  • Usage examples
• Use Oracle Compatibility SQL via Orafce
  • Install and remove Orafce
  • SynxDB considerations
  • Using Orafce