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.
Duration 21 hours
Course Outline
Distributed SQL Sovereignty
- The limitations of global SQL constrained by closed platforms like Spanner and Aurora Global.
- Deep dive into CockroachDB architecture, including Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Configuring single-region and multi-region topologies via Docker Compose.
- Deploying Kubernetes StatefulSets with persistent volume management.
- Best practices for security certificate generation and node initialization.
SQL Compatibility and Query Optimization
- An overview of supported SQL features and specific PostgreSQL limitations.
- Leveraging the cost-based optimizer and analyzing execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and array data types.
Multi-Region Configuration
- Defining region and locality settings for precise data placement.
- Comparing follow-the-workload strategies with regional table definitions and survival goals.
- Managing leaseholder placement and implementing topology-aware routing.
Backup, Restore, and Disaster Recovery
- Executing full cluster backups to cloud storage or on-premise S3-compatible systems.
- Implementing incremental backups and point-in-time recovery capabilities.
- Setting up Changefeeds for integration with Kafka and webhook streaming.
Security and Compliance
- Enforcing TLS encryption for all node-to-node and client-to-node communications.
- Configuring Role-Based Access Control (RBAC) and row-level security policies.
- Implementing audit logging and generating compliance reports.
Integration Patterns
- Integrating with popular ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Facilitating smooth migrations from PostgreSQL using specialized tooling.
- Incorporating Kubernetes sidecars and service mesh integration strategies.
Requirements
- Proficiency in SQL and relational database administration.
- A solid conceptual understanding of distributed consensus protocols, specifically Raft.
- Familiarity with Go tooling and Docker is advantageous.
Target Audience
- Senior database architects focused on establishing sovereign data layers.
- Engineering teams seeking to migrate from Spanner, Aurora Global, or Cosmos DB.
- Organizations in the financial and healthcare sectors that require strict consistency guarantees.
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.
