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
- Overcoming limitations of closed platforms for global SQL, such as Spanner and Aurora Global.
- Understanding CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without relying on shared storage.
Cluster Deployment
- Setting up single-region and multi-region topologies with Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Exploring supported SQL features and PostgreSQL-compatible limitations.
- Leveraging the cost-based optimizer and analyzing execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Configuring region and locality settings to manage data placement.
- Understanding follow-the-workload patterns versus regional tables and survival goals.
- Optimizing leaseholder placement and implementing 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.
- Using Changefeeds for streaming to Kafka and webhooks.
Security and Compliance
- Implementing TLS across all layers: node-to-node and client-to-node.
- Enforcing Role-Based Access Control (RBAC) and row-level security.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Executing migrations from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service mesh technologies.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus, specifically the Raft algorithm.
- Familiarity with Go tooling and Docker is beneficial.
Target Audience
- Senior database architects designing sovereign data layers.
- Teams migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare sectors requiring strict data consistency.
21 Hours
Testimonials (2)
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
The adjustment made in the lecture/lessons by the trainer once he understood the current SSIS application that we are bound to maintain. The topics became more suitable/usable to us.
