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 on closed platforms like Spanner and Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Horizontal scaling without reliance on shared storage.
Cluster Deployment
- Single-region and multi-region topologies using Docker Compose.
- Kubernetes StatefulSet deployment with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Supported SQL features and PostgreSQL limitations.
- Understanding the cost-based optimizer and execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Configuring region and locality settings for data placement.
- Follow-the-workload strategies versus regional tables and resilience goals.
- Leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery
- Performing full cluster backups to cloud storage or on-premise S3.
- Incremental backups and point-in-time recovery capabilities.
- Using Changefeeds for Kafka and webhook streaming.
Security and Compliance
- Implementing TLS everywhere for node-to-node and client-to-node communication.
- Role-Based Access Control (RBAC) and row-level security.
- Audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Strong 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.
Audience
- Senior database architects developing independent data layers.
- Teams migrating away from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations 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.
