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 challenges of global SQL confined within closed platforms like Spanner and Aurora Global.
- Core CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without relying on shared storage.
Cluster Deployment
- Implementing single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Overview of supported SQL features and known PostgreSQL limitations.
- Utilizing the cost-based optimizer and interpreting execution plans.
- Leveraging indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Configuring region and locality settings for strategic data placement.
- Comparing follow-the-workload strategies with regional tables and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Executing full cluster backups to cloud storage or on-premise S3.
- Performing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- Implementing TLS across all channels: node-to-node and client-to-node.
- Enforcing Role-Based Access Control (RBAC) and row-level security.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Executing migrations from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service mesh components.
Requirements
- 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 designing sovereign data layers.
- Teams seeking alternatives to Spanner, Aurora Global, and Cosmos DB.
- Financial and healthcare enterprises 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.
