CockroachDB Training by Experts

Module 1: Introduction to CockroachDB (2 hours)

• Overview of Distributed SQL Databases
• What is CockroachDB and why use it?
• Key features: Scalability, Consistency, Resilience
• Comparison with PostgreSQL, MySQL, Google Spanner
• Use Cases and real-world applications

Hands-on Lab:

• Install CockroachDB (Docker, Local, Cloud)
• Set up a single-node cluster

Module 2: Core Architecture and Internals(3 hours)

• How CockroachDB Works(Sharding, Replication, Consensus)
• Raft Protocol and Transaction Consistency
• Data distribution and multi-region architecture
• Survivability and Failover Mechanisms

Hands-on Lab:

• Deploy a multi-node cluster
• Test node failure recovery

Module 3: SQL Basics with CockroachDB(3 hours)

• SQL compatibility with PostgreSQL
• Creating and managing databases
• Tables, indexes, and data types
• Transactions and ACID Compliance

Hands-on Lab:

• Create a database and tables
• Insert, update, and query data

Module 4: Advanced SQL and Performance Optimization(3 hours)

• Indexing and Query Optimization
• Joins, Views, Stored Procedures
• EXPLAIN ANALYZE for query performance
• Row-level locking and isolation levels

Hands-on Lab:

• Use EXPLAIN ANALYZE for performance tuning
• Optimize queries with indexes

Module 5: Multi-Region Deployment (3 hours)

• Geo-partitioning data for global applications
• Managing latency and high availability
• Using Follow-the-Workload (FTW) for optimal performance
• CockroachDB in Kubernetes & cloud environments

Hands-on Lab:

• Deploy a multi-region cluster
• Geo-partition a table

Module 6: Security and Access Control (2.5 hours)

• Authentication & role-based access control (RBAC)
• TLS encryption & data security best practices
• Audit logging & monitoring

Hands-on Lab:

• Set up RBAC and TLS encryption
• Implement security policies