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
- The limitations of global SQL within closed platforms like Spanner and Aurora Global.
- Understanding CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Constructing 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 compatibility limits compared to PostgreSQL.
- Navigating the cost-based optimizer and interpreting execution plans.
- Leveraging indexes, composite keys, and inverted indexes for JSON data and arrays.
Multi-Region Configuration
- Configuring region and locality settings to control data placement.
- Comparing '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.
- Utilizing incremental backups and point-in-time recovery capabilities.
- Implementing Changefeeds for streaming to Kafka or webhooks.
Security and Compliance
- Enforcing TLS everywhere, covering node-to-node and client-to-node communications.
- Implementing 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.
- Strategies for migrating from PostgreSQL using available tooling.
- Integrating Kubernetes sidecars and service mesh architectures.
Requirements
- Proficient skills in SQL and relational database administration.
- Solid understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker is beneficial.
Audience
- Senior database architects designing sovereign data layers.
- Teams looking to migrate from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring robust consistency guarantees.
21 Hours
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.
