Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Distributed SQL Sovereignty
- The limitations of global SQL confined to closed platforms like Spanner and Aurora Global.
- Core CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Configuring single-region and multi-region topologies with Docker Compose.
- Deploying via Kubernetes StatefulSets with persistent volume integration.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Optimization
- Reviewing supported SQL features and specific PostgreSQL limitations.
- Understanding the cost-based optimizer and interpreting execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and array data.
Multi-Region Configuration
- Setting region and locality parameters for precise data placement.
- Balancing follow-the-workload strategies with regional tables and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery
- Executing full cluster backups to cloud storage or on-premise S3 solutions.
- Implementing incremental backups and point-in-time recovery capabilities.
- Streaming changes to Kafka and webhooks using Changefeeds.
Security and Compliance
- Enforcing TLS across all connections, including node-to-node and client-to-node.
- Implementing RBAC and row-level security controls.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting with ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating from PostgreSQL using specialized tooling.
- Integrating Kubernetes sidecars and service mesh solutions.
Requirements
- Proficiency in SQL and relational database administration.
- A solid grasp of distributed consensus mechanisms, specifically Raft.
- Basic familiarity with Go tooling and Docker is beneficial.
Target Audience
- Senior database architects focused on building sovereign data layers.
- Teams seeking to migrate from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare sectors requiring strict data consistency standards.
21 Hours
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
