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 trapped within closed platforms: Spanner, Aurora Global.
- CockroachDB architecture overview: Raft ranges, leaseholders, and MVCC.
- Horizontal scaling without shared storage dependencies.
Cluster Deployment
- Single-region and multi-region topologies using Docker Compose.
- Kubernetes StatefulSet deployment utilizing persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and known PostgreSQL limitations.
- Cost-based optimizer behavior and execution plan analysis.
- Leveraging indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Defining region and locality settings for precise data placement.
- Evaluating 'follow-the-workload' strategies versus regional tables and disaster recovery goals.
- Leaseholder placement and topology-aware routing techniques.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3.
- Implementing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- Comprehensive TLS enforcement: node-to-node and client-to-node communication.
- Role-Based Access Control (RBAC) and row-level security mechanisms.
- Audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks including SQLAlchemy, Prisma, and GORM.
- Strategies for migrating from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficient SQL skills and experience in relational database administration.
- A solid understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Audience
- Senior database architects designing independent data layers.
- Teams migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare institutions requiring strict consistency guarantees.
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.
