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 challenges of global SQL trapped in closed platforms like Spanner and Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Setting up 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 limitations relative to PostgreSQL.
- 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 for optimal data placement.
- Comparing follow-the-workload versus regional tables and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and DR
- Performing full cluster backups to cloud storage or on-premise S3.
- Implementing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka and webhook streaming.
Security and Compliance
- Enforcing TLS everywhere: node-to-node and client-to-node communication.
- Implementing RBAC and row-level security.
- Managing audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating from PostgreSQL using standard tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficiency in SQL and relational database administration.
- High-level understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is beneficial.
Target Audience
- Senior database architects establishing sovereign data layers.
- Teams in the process of migrating from Spanner, Aurora Global, or Cosmos DB.
- Organizations in financial and healthcare sectors requiring strong consistency guarantees.
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.
