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
- Challenges of global SQL constrained within closed platforms like Spanner and Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Horizontal scaling capabilities without shared storage dependencies.
Cluster Deployment
- Configuring 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
- Overview of supported SQL features and known PostgreSQL limitations.
- Utilizing the cost-based optimizer and interpreting execution plans.
- Implementing standard indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Setting up regions and locality tags to dictate 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-compatible storage.
- Executing incremental backups and achieving point-in-time recovery.
- Utilizing Changefeeds for streaming to Kafka and webhooks.
Security and Compliance
- Implementing TLS across all nodes and between clients and nodes.
- Managing Role-Based Access Control (RBAC) and row-level security.
- Conducting audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Executing migrations from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service mesh components.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus protocols (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects who are establishing sovereign data layers.
- Teams looking to replace Google Spanner, Amazon Aurora Global, or Azure Cosmos DB.
- Financial and healthcare institutions requiring stringent data 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.
