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
- Overcoming the limitations of closed platforms for global SQL: Spanner, Aurora Global.
- Understanding CockroachDB architecture: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Setting up single-region and multi-region Docker Compose topologies.
- Deploying via Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and known PostgreSQL compatibility limitations.
- Working with the cost-based optimizer and interpreting execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Configuring region and locality settings to control data placement.
- Understanding follow-the-workload patterns versus regional tables and survivability goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and DR (Disaster Recovery)
- Performing full cluster backups to cloud storage or on-premise S3-compatible systems.
- Implementing incremental backups and point-in-time recovery strategies.
- Leveraging Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- Enforcing TLS everywhere: node-to-node communication and client-to-node connections.
- Managing RBAC (Role-Based Access Control) and row-level security.
- Utilizing audit logging for compliance reporting.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Strategies for migrating from PostgreSQL using relevant tooling.
- Integrating Kubernetes sidecars and service meshes.
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 beneficial.
Audience
- Senior database architects designing sovereign data layers.
- Teams seeking to replace services such as Spanner, Aurora Global, and Cosmos DB.
- Financial and healthcare organizations requiring strong consistency guarantees.
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
