感謝您提交詢問！我們的一位團隊成員將在短時間內與您聯繫。
感謝您提交預訂！我們的一位團隊成員將在短時間內與您聯繫。
課程簡介
Distributed SQL Sovereignty
- Challenges of global SQL trapped within closed platforms like Spanner and Aurora Global.
- CockroachDB architecture: Raft ranges, leaseholders, and MVCC.
- Achieving horizontal scaling without reliance on shared storage.
Cluster Deployment
- Implementing single-region and multi-region Docker Compose topologies.
- Deploying Kubernetes StatefulSets with persistent volumes.
- Best practices for security certificates and node initialization.
SQL Compatibility and Query Tuning
- Overview of supported SQL features and limitations compared to PostgreSQL.
- Understanding the cost-based optimizer and execution plans.
- Utilizing indexes, composite keys, and inverted indexes for JSON and arrays.
Multi-Region Configuration
- Configuring region and locality settings for precise data placement.
- Balancing follow-the-workload strategies with regional tables and durability goals.
- Managing leaseholder placement and topology-aware routing.
Backup, Restore, and Disaster Recovery (DR)
- Performing full cluster backups to cloud storage or on-premise S3.
- Executing incremental backups and point-in-time recovery.
- Utilizing Changefeeds for streaming to Kafka and webhooks.
Security and Compliance
- Enforcing TLS everywhere: between nodes and from client to node.
- Implementing Role-Based Access Control (RBAC) and row-level security.
- Managing audit logging and generating compliance reports.
Integration Patterns
- Connecting ORM frameworks such as SQLAlchemy, Prisma, and GORM.
- Migrating from PostgreSQL using appropriate tooling.
- Integrating Kubernetes sidecars and service meshes.
最低要求
- Strong proficiency in SQL and relational database administration.
- A high-level 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 replace Spanner, Aurora Global, or Cosmos DB.
- Financial and healthcare organizations requiring strong consistency guarantees.
21 小時
客戶評論 (2)
提供的培訓工具。
- UNIFI
課程 - NoSQL Database with Microsoft Azure Cosmos DB
機器翻譯
培訓師在瞭解了我們當前需要維護的SSIS應用後，對課程內容進行了調整。調整後的主題更符合我們的需求，更具實用性。
Angelito Aguilar - Metrobank
課程 - Introduction to SQL Server 2012 Integration Services (SSIS)
機器翻譯
