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.
Duration 21 hours
Course Outline
Distributed SQL Sovereignty
- The limitations of global SQL trapped within closed platforms such as Spanner and Aurora Global.
- Understanding CockroachDB architecture, including Raft ranges, leaseholders, and Multi-Version Concurrency Control (MVCC).
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Constructing single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Implementing best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- An overview of supported SQL features and PostgreSQL compatibility constraints.
- Navigating the cost-based optimizer and interpreting execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and array data types.
Multi-Region Configuration
- Configuring region and locality settings to optimize data placement.
- Comparing follow-the-workload strategies against regional tables and durability goals.
- Managing leaseholder placement and implementing topology-aware routing.
Backup, Restore, and Disaster Recovery
- Performing full cluster backups to cloud storage or on-premise S3-compatible systems.
- Executing incremental backups and achieving point-in-time recovery.
- Utilizing Changefeeds for streaming data to Kafka and webhooks.
Security and Compliance
- Enforcing TLS across all connections: node-to-node and client-to-node.
- Implementing Role-Based Access Control (RBAC) and row-level security.
- Conducting audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating existing PostgreSQL environments using appropriate tooling.
- Integrating Kubernetes sidecars and service mesh architectures.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects developing sovereign data layers.
- Teams looking to migrate from platforms like Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare sectors requiring strong data consistency guarantees.
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
