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
- Challenges of global SQL constrained by closed platforms: Spanner, Aurora Global.
- Core CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without relying on shared storage.
Cluster Deployment
- Single-region and multi-region Docker Compose topologies.
- Kubernetes StatefulSet deployment utilizing persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and known PostgreSQL compatibility limits.
- Understanding the cost-based optimizer and execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Configuring region and locality settings to control data placement.
- Strategies: Follow-the-workload versus regional tables and disaster survival goals.
- Optimizing leaseholder placement and implementing topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3.
- Executing incremental backups and point-in-time recovery.
- Leveraging Changefeeds for streaming to Kafka and webhooks.
Security and Compliance
- Enforcing TLS everywhere: node-to-node and client-to-node communication.
- Implementing RBAC and row-level security.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Strategies for migrating from PostgreSQL using specific tooling.
- Utilizing Kubernetes sidecars and service mesh integration.
Requirements
- Strong proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects focused on building sovereign data layers.
- Teams migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare sectors requiring rigorous data consistency.
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.
