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
- Limitations of global SQL locked within closed platforms like Spanner and Aurora Global.
- CockroachDB architecture: understanding Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Configuring 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 Optimization
- Supported SQL features and known limitations compared to PostgreSQL.
- Utilizing the cost-based optimizer and interpreting execution plans.
- Implementing indexes, composite keys, and inverted indexes for JSON or arrays.
Multi-Region Configuration
- Configuring region and locality settings to control data placement.
- Comparing 'follow-the-workload' strategies with regional tables and resilience goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery
- Performing full cluster backups to cloud storage or on-premise S3 buckets.
- Executing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka integration and webhook streaming.
Security and Compliance
- Implementing TLS across all connections: node-to-node and client-to-node.
- Configuring RBAC and row-level security policies.
- Managing 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 Kubernetes sidecars and service mesh components.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects developing sovereign data layers.
- Engineering 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.
