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 locked into closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without shared storage constraints.
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 compatibility with PostgreSQL limitations.
- Understanding the cost-based optimizer and execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Configuring region and locality settings for precise data placement.
- Distinguishing between follow-the-workload strategies, regional tables, and survival 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.
- Executing incremental backups and point-in-time recovery.
- Using Changefeeds for Kafka and webhook streaming.
Security and Compliance
- Implementing TLS everywhere: node-to-node and client-to-node.
- Managing RBAC and row-level security.
- Conducting audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is beneficial.
Target Audience
- Senior database architects who are building sovereign data layers.
- Teams tasked with replacing Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring strong consistency guarantees.
21 Hours
Testimonials (2)
The training instruments provided.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
