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
- Global SQL trapped in closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, MVCC.
- Horizontal scaling without shared storage.
Cluster Deployment
- Single-region and multi-region Docker Compose topologies.
- Kubernetes StatefulSet deployment with persistent volumes.
- Security certificates and node initialization best practices.
SQL Compatibility and Query Tuning
- Supported SQL features and PostgreSQL limitations.
- Cost-based optimizer and execution plans.
- Indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Region and locality settings for data placement.
- Follow-the-workload vs regional tables and survival goals.
- Leaseholder placement and topology-aware routing.
Backup, Restore, and DR
- Full cluster backups to cloud storage or on-premise S3.
- Incremental backups and point-in-time recovery.
- Changefeeds for Kafka and webhook streaming.
Security and Compliance
- TLS everywhere: node-to-node and client-to-node.
- RBAC and row-level security.
- Audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks: SQLAlchemy, Prisma, GORM.
- Migration from PostgreSQL with tooling.
- Kubernetes sidecars and service mesh integration.
Requirements
- Strong SQL and relational database administration.
- High-level understanding of distributed consensus (Raft).
- Go tooling and Docker familiarity helpful.
Audience
- Senior database architects building sovereign data layers.
- Teams replacing Spanner, Aurora Global, Cosmos DB.
- Financial and healthcare organizations needing strong consistency.
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
