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 limitations of global SQL confined within closed ecosystems: Spanner, Aurora Global.
- Core CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Horizontal scaling capabilities independent of shared storage.
Cluster Deployment
- Configuring single-region and multi-region topologies using Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Optimization
- Supported SQL features and known PostgreSQL compatibility constraints.
- Understanding the cost-based optimizer and execution plans.
- Utilizing standard indexes, composite keys, and inverted indexes for JSON or array data.
Multi-Region Configuration
- Setting regions and locality tags for strategic data placement.
- Implementing follow-the-workload strategies versus regional tables and durability goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery
- Performing full cluster backups to cloud storage or on-premise S3-compatible buckets.
- Executing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for streaming data to Kafka or webhooks.
Security and Compliance
- Enforcing TLS for all communications: node-to-node and client-to-node.
- Implementing Role-Based Access Control (RBAC) and row-level security.
- Configuring audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Strategies for migrating from PostgreSQL using available tooling.
- Integrating with Kubernetes sidecars and service meshes.
Requirements
- Proficient knowledge of SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Audience
- Senior database architects focused on building sovereign data layers.
- Teams looking to replace services like Spanner, Aurora Global, or Cosmos DB.
- Financial institutions and healthcare organizations 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.
