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
- Understanding the limitations of global SQL trapped in closed platforms like Spanner and Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Achieving horizontal scaling without relying on shared storage.
Cluster Deployment
- Configuring single-region and multi-region Docker Compose topologies.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and known PostgreSQL limitations.
- Navigating the cost-based optimizer and interpreting execution plans.
- Leveraging indexes, composite keys, and inverted indexes for JSON data and arrays.
Multi-Region Configuration
- Setting region and locality parameters for precise data placement.
- Comparing follow-the-workload strategies with regional tables and survival goals.
- Optimizing leaseholder placement and utilizing topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3-compatible systems.
- Implementing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for streaming data to Kafka and webhooks.
Security and Compliance
- Enforcing TLS everywhere: both node-to-node and client-to-node connections.
- Implementing RBAC (Role-Based Access Control) and row-level security.
- Managing audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Executing migrations from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Strong proficiency in 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 migrating from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring strong consistency guarantees.
21 Hours
Testimonials (4)
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.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
