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 limitations within closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, MVCC.
- Horizontal scaling without shared storage dependencies.
Cluster Deployment
- Single-region and multi-region Docker Compose topologies.
- Kubernetes StatefulSet deployment utilising persistent volumes.
- Best practices for security certificates and node initialisation.
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 versus 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 connectivity.
- RBAC and row-level security.
- Audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks: SQLAlchemy, Prisma, GORM.
- Migration from PostgreSQL using relevant tooling.
- Kubernetes sidecars and service mesh integration.
Requirements
- Proficiency in SQL and relational database administration.
- A high-level understanding of distributed consensus (Raft).
- Familiarity with Go tooling and Docker is beneficial.
Audience
- Senior database architects constructing sovereign data layers.
- Teams seeking to replace Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organisations requiring strong consistency guarantees.
21 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
