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
Framework for Distributed SQL Sovereignty
- Addressing the constraints of proprietary global SQL platforms, including Spanner and Aurora Global, for government.
- Examination of CockroachDB architectural components: Raft consensus ranges, leaseholder mechanisms, and multiversion concurrency control (MVCC).
- Strategies for achieving horizontal scaling without reliance on shared storage infrastructure.
Cluster Deployment Standards
- Implementation of single-region and multi-region topologies using Docker Compose configurations.
- Provisioning of Kubernetes StatefulSets utilizing persistent volume claims for data durability.
- Best practices for establishing security certificates and initializing node operations.
SQL Compatibility and Query Optimization
- Analysis of supported SQL features and identification of PostgreSQL-specific limitations.
- Utilization of the cost-based optimizer to interpret and refine execution plans.
- Implementation of indexes, composite keys, and inverted indexes to support JSON and array data structures.
Multi-Region Data Configuration
- Definition of region and locality settings to enforce precise data placement policies.
- Evaluation of follow-the-workload patterns versus regional table architectures and survival objectives.
- Management of leaseholder placement and application of topology-aware routing logic.
Backup, Restoration, and Disaster Recovery
- Execution of full cluster backups to cloud storage or on-premise S3-compatible systems.
- Configuration of incremental backups and enforcement of point-in-time recovery capabilities.
- Deployment of changefeeds to support Kafka integration and webhook streaming workflows.
Security Posture and Compliance
- Enforcement of TLS encryption for all node-to-node and client-to-node communications.
- Application of Role-Based Access Control (RBAC) and row-level security policies.
- Maintenance of audit logging systems and generation of compliance reporting for government standards.
System Integration Patterns
- Integration of Object-Relational Mapping (ORM) frameworks, including SQLAlchemy, Prisma, and GORM.
- Development of migration strategies from PostgreSQL using specialized tooling.
- Incorporation of Kubernetes sidecars and service mesh architectures for operational continuity.
Requirements
- Demonstrated proficiency in SQL syntax and relational database administration principles.
- Advanced conceptual understanding of distributed consensus mechanisms, specifically Raft.
- Familiarity with Go tooling and Docker containerization is recommended.
Target Audience
- Senior database architects tasked with building sovereign data layers for government systems.
- Technical teams migrating from Spanner, Aurora Global, or Cosmos DB to more autonomous solutions.
- Organizations in the financial and healthcare sectors requiring strong consistency guarantees for sensitive data.
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
