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
- Addressing the constraints of closed platforms for global SQL: Spanner, Aurora Global.
- Understanding CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Configuring single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Implementing best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Reviewing supported SQL features and PostgreSQL compatibility limitations.
- Analyzing cost-based optimizer strategies and execution plans.
- Leveraging indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Setting region and locality parameters for precise data placement.
- Choosing between follow-the-workload strategies, 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 buckets.
- Executing incremental backups and point-in-time recovery procedures.
- Utilizing Changefeeds for streaming to Kafka and webhooks.
Security and Compliance
- Enforcing TLS everywhere: between nodes and from clients to nodes.
- Implementing Role-Based Access Control (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 appropriate tooling.
- Integrating Kubernetes sidecars and service mesh architectures.
Requirements
- Proficient knowledge of 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 developing sovereign data layers.
- Teams looking to migrate away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare institutions requiring strong 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.
