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
- The constraints of global SQL confined within closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Horizontal scaling without reliance on shared storage.
Cluster Deployment
- Docker Compose topologies for single-region and multi-region setups.
- Kubernetes StatefulSet deployment utilizing persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and known limitations compared to PostgreSQL.
- Cost-based optimizer analysis and execution plans.
- Indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Region and locality settings for strategic data placement.
- Distinguishing between follow-the-workload patterns, regional tables, and survival goals.
- Leaseholder placement and topology-aware routing strategies.
Backup, Restore, and Disaster Recovery (DR)
- Full cluster backups to cloud storage or on-premise S3-compatible systems.
- Incremental backups and point-in-time recovery capabilities.
- Utilizing Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- TLS implementation everywhere: covering node-to-node and client-to-node communication.
- Role-Based Access Control (RBAC) and row-level security.
- Audit logging and compliance reporting mechanisms.
Integration Patterns
- Connecting with ORM frameworks: SQLAlchemy, Prisma, GORM.
- Migration strategies from PostgreSQL using specialized tooling.
- Kubernetes sidecars and service mesh integration techniques.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects focused on building sovereign data layers.
- Teams migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare institutions requiring strong 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.
