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 Data Sovereignty
- Evaluation of proprietary database platforms, including Google Spanner and Amazon Aurora Global Database, regarding open standards adherence.
- Overview of the CockroachDB architecture, encompassing Raft consensus ranges, leaseholder management, and multi-version concurrency control (MVCC).
- Implementation of horizontal scalability without reliance on shared storage infrastructure.
Cluster Deployment Strategies
- Configuration of single-region and multi-region topologies using Docker Compose for development and testing environments.
- Deployment via Kubernetes StatefulSets with persistent volume claims to ensure state consistency.
- Establishment of secure certificate management protocols and standardized node initialization procedures for government use cases.
SQL Compatibility and Query Optimization
- Assessment of supported SQL standard features and identified limitations relative to PostgreSQL compatibility.
- Analysis of the cost-based optimizer performance and query execution plan efficiency.
- Utilization of primary indexes, composite keys, and inverted indexes for semi-structured data types, such as JSON and arrays.
Multi-Region Data Placement
- Definition of region and locality settings to govern data residency and placement compliance.
- Determination of replication strategies, including follow-the-workload mechanisms, regional table configurations, and disaster recovery survival goals for government systems.
- Management of leaseholder allocation and topology-aware request routing to optimize latency.
Backup, Restore, and Disaster Recovery
- Execution of full cluster backups to cloud storage services or on-premise S3-compatible repositories.
- Implementation of incremental backup procedures and point-in-time recovery capabilities.
- Leverage of Changefeeds for continuous data synchronization via Apache Kafka streams or webhook endpoints.
Security and Regulatory Compliance
- Enforcement of end-to-end encryption using TLS for both node-to-node communication and client-to-node connections.
- Implementation of Role-Based Access Control (RBAC) and row-level security policies to restrict data access.
- Maintenance of comprehensive audit logs and generation of compliance reports to meet federal regulatory requirements.
System Integration Patterns
- Integration with object-relational mapping (ORM) frameworks, including SQLAlchemy, Prisma, and GORM, for application development.
- Procedures for migrating existing PostgreSQL workloads using automated tooling to minimize operational disruption.
- Configuration of Kubernetes sidecars and service mesh integration to support secure microservices architectures.
Requirements
- Required Competencies
- Proficiency in administering SQL databases and managing relational data structures.
- Demonstrated knowledge of distributed consensus mechanisms, specifically Raft protocols.
- Familiarity with Go-based development tools and Docker containerization is advantageous.
Target Beneficiaries
- Senior database architects responsible for designing secure, sovereign data infrastructures for government agencies.
- Engineering groups modernizing legacy systems by migrating away from proprietary platforms such as Spanner, Aurora Global, or Cosmos DB.
- Institutions in the financial and healthcare sectors that require rigorous data consistency to support federal compliance and operational integrity for government operations.
21 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
