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 locked into closed platforms: Spanner, Aurora Global.
- CockroachDB architecture overview: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without shared storage dependencies.
Cluster Deployment
- Designing single-region and multi-region topologies with 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 PostgreSQL compatibility limitations.
- Leveraging the cost-based optimizer and analyzing execution plans.
- Utilizing 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 against regional tables and survival goals.
- Managing leaseholder placement and implementing topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3 buckets.
- Executing incremental backups and achieving point-in-time recovery.
- Utilizing Changefeeds for streaming data to Kafka and webhooks.
Security and Compliance
- Enforcing TLS across all connections: node-to-node and client-to-node.
- Implementing RBAC and row-level security policies.
- Managing 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.
- Comprehensive understanding of distributed consensus mechanisms (Raft).
- Familiarity with Go tooling and Docker is advantageous.
Audience
- Senior database architects designing sovereign data layers.
- Teams looking to replace Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare institutions requiring strict data consistency.
21 Hours
Testimonials (4)
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.
- 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
