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 the limitations of global SQL within closed platforms: Spanner, Aurora Global.
- CockroachDB architecture fundamentals: Raft ranges, leaseholders, and MVCC (Multi-Version Concurrency Control).
- Achieving horizontal scaling without relying on shared storage.
Cluster Deployment
- Configuring single-region and multi-region topologies using Docker Compose.
- Deploying via Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Optimization
- Overview of supported SQL features and constraints relative to PostgreSQL.
- Navigating the cost-based optimizer and interpreting execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON/arrays.
Multi-Region Configuration
- Setting region and locality parameters to control data placement.
- Evaluating Follow-the-Workload strategies versus regional tables and survival goals.
- Managing leaseholder placement and implementing topology-aware routing.
Backup, Restore, and Disaster Recovery
- Performing full cluster backups to cloud storage or on-premise S3 environments.
- Implementing incremental backups and point-in-time recovery.
- Leveraging Changefeeds for streaming data to Kafka and webhooks.
Security and Compliance
- Enforcing TLS everywhere: node-to-node and client-to-node connections.
- Implementing RBAC (Role-Based Access Control) and row-level security.
- Setting up audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks: SQLAlchemy, Prisma, GORM.
- Utilizing tooling for migration from PostgreSQL.
- Integrating Kubernetes sidecars and service meshes.
Requirements
- Proficient knowledge of SQL and relational database administration.
- A solid conceptual understanding of distributed consensus mechanisms (such as Raft).
- Familiarity with Go tooling and Docker is beneficial.
Target Audience
- Senior database architects focused on building sovereign data layers.
- Teams looking to migrate from Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring strict data consistency.
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.
