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
- Understanding global SQL limitations within closed platforms like Spanner and Aurora Global.
- Exploring CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without shared storage.
Cluster Deployment
- Configuring single-region and multi-region Docker Compose topologies.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Implementing security certificates and node initialization best practices.
SQL Compatibility and Query Tuning
- Reviewing supported SQL features and PostgreSQL compatibility limits.
- Utilizing the cost-based optimizer and interpreting execution plans.
- Employing indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Setting region and locality parameters for data placement.
- Balancing follow-the-workload strategies against regional tables and survival goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and DR
- Performing full cluster backups to cloud storage or on-premise S3.
- Executing incremental backups and point-in-time recovery.
- Utilizing 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.
- Handling audit logging and compliance reporting.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service mesh solutions.
Requirements
- Proficient knowledge of SQL and relational database administration.
- A solid understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is beneficial.
Audience
- Senior database architects developing sovereign data layers.
- Teams migrating from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring strong 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.
