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
- Addressing the constraints of global SQL locked within closed platforms such as Spanner and Aurora Global.
- Overview of CockroachDB architecture: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Achieving horizontal scaling without relying on shared storage systems.
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 Tuning
- Supported SQL features and known limitations regarding PostgreSQL compatibility.
- Understanding the cost-based optimizer and interpreting execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and array data.
Multi-Region Configuration
- Defining region and locality settings to control data placement.
- Strategies for 'follow-the-workload' routing versus regional tables and disaster recovery goals.
- Managing leaseholder placement and implementing topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3-compatible stores.
- Executing incremental backups and point-in-time recovery.
- Using Changefeeds for streaming data to Kafka and webhooks.
Security and Compliance
- Implementing TLS across all connections: 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.
- Executing migration from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service mesh architectures.
Requirements
- Proficient knowledge of SQL and relational database administration.
- A solid conceptual understanding of distributed consensus protocols, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects tasked with building sovereign data layers.
- Teams planning to replace systems like Spanner, Aurora Global, or Cosmos DB.
- Financial 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.
