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 constraints of global SQL within closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Horizontal scaling without reliance on shared storage.
Cluster Deployment
- 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 Optimization
- Supported SQL features and limitations compared to PostgreSQL.
- Cost-based optimizer and execution plan analysis.
- 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 patterns versus regional tables and survivability goals.
- Leaseholder placement and topology-aware routing strategies.
Backup, Restore, and Disaster Recovery
- 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 the board: node-to-node and client-to-node.
- Managing Role-Based Access Control (RBAC) and row-level security.
- Conducting audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Strategies for migrating from PostgreSQL with appropriate tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficient skills in SQL and relational database administration.
- Solid conceptual understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects designing sovereign data layers.
- Teams migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare sectors requiring robust 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.
