Course Outline
Distributed SQL Sovereignty
- The challenges of global SQL confined to closed platforms: Spanner, Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without shared storage dependencies.
Cluster Deployment
- 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 distinctions from PostgreSQL limitations.
- Utilizing the cost-based optimizer and interpreting execution plans.
- Leveraging indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Configuring region and locality settings for precise data placement.
- Balancing 'follow-the-workload' strategies with regional tables and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3.
- Implementing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for Kafka and webhook streaming.
Security and Compliance
- Enforcing TLS everywhere: both node-to-node and client-to-node.
- Implementing RBAC and row-level security.
- Configuring audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Facilitating migration from PostgreSQL using dedicated 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 advantageous.
Target Audience
- Senior database architects focused on building independent data layers.
- Teams migrating away from solutions like Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare institutions requiring stringent data consistency.
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 (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.
