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 locked into closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Achieving horizontal scaling without shared storage bottlenecks.
Cluster Deployment
- Configuring single-region and multi-region topologies with Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and limitations compared to PostgreSQL.
- Navigating the cost-based optimizer and interpreting execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Defining region and locality settings to control data placement.
- Understanding follow-the-workload strategies versus regional tables and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3-compatible systems.
- Implementing incremental backups and point-in-time recovery.
- Leveraging Changefeeds for streaming data to Kafka or webhooks.
Security and Compliance
- Enforcing TLS everywhere: between nodes and from client to node.
- Implementing RBAC (Role-Based Access Control) and row-level security.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks: SQLAlchemy, Prisma, GORM.
- Executing migrations from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Strong proficiency in SQL and relational database administration.
- A high-level understanding of distributed consensus mechanisms (specifically Raft).
- Familiarity with Go tooling and Docker is beneficial.
Audience
- Senior database architects focused on building sovereign data layers.
- Teams tasked with replacing Google Spanner, Amazon Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring robust 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.
