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 global SQL within closed platforms such as Spanner and Aurora Global.
- Understanding CockroachDB architecture: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Implementing single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Adhering to best practices for security certificates and node initialisation.
SQL Compatibility and Query Tuning
- Exploring supported SQL features and limitations compared to PostgreSQL.
- Analyzing cost-based optimizers and execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Configuring region and locality settings for precise data placement.
- Understanding 'follow-the-workload' strategies versus 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.
- Executing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka and webhook streaming.
Security and Compliance
- Implementing TLS across all layers: node-to-node and client-to-node.
- Applying RBAC (Role-Based Access Control) and row-level security.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting with ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Facilitating migration from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficient knowledge of SQL and relational database administration.
- A high-level understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is beneficial.
Target Audience
- Senior database architects developing sovereign data layers.
- Teams looking to migrate from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organisations 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.
