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 locked into closed ecosystems like Spanner and Aurora Global.
- CockroachDB core architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without the complexity of shared storage.
Cluster Deployment
- Constructing single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volume management.
- Best practices for security certificate management and node initialization.
SQL Compatibility and Query Tuning
- Review of supported SQL features and specific PostgreSQL compatibility nuances.
- Understanding the cost-based optimizer and analyzing execution plans.
- Leveraging indexes, composite keys, and inverted indexes for efficient JSON/array querying.
Multi-Region Configuration
- Configuring region and locality settings for optimal data placement.
- Choosing between follow-the-workload patterns and regional tables based on survival goals.
- Strategic leaseholder placement and topology-aware request routing.
Backup, Restore, and Disaster Recovery
- Executing full cluster backups to cloud storage or on-premise S3 endpoints.
- Managing incremental backups and implementing point-in-time recovery.
- Setting up Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- Implementing comprehensive TLS encryption for both node-to-node and client-to-node communication.
- Applying RBAC policies and row-level security measures.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Integrating with popular ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Streamlining migrations from PostgreSQL using appropriate tooling.
- Incorporating Kubernetes sidecars and service mesh integrations.
Requirements
- Advanced proficiency in SQL and relational database administration.
- A solid conceptual grasp of distributed consensus mechanisms, specifically Raft.
- Working knowledge of Go tooling and Docker is advantageous.
Target Audience
- Lead database architects developing sovereign data infrastructure.
- Engineering teams migrating from Spanner, Aurora Global, or Cosmos DB.
- Organizations in financial services 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.
