Scylla Database Training Course

System Foundations and Architecture

• Scylla Overview: Historical context, applicable use cases, and performance benchmarks relative to Apache Cassandra.
• Architectural Components: Analysis of data sharding, partitioning mechanisms, and distributed database infrastructure.
• Data Schema Model: Examination of clustering keys, partition structures, and supported data types.
• CQL Fundamentals: Overview of the Cassandra Query Language and operational procedures for the CQL shell.

Cluster Deployment and Administration

• Software Installation: Procedures for deploying Scylla across supported operating systems.
• Cluster Configuration: Configuration of seed nodes, replication policies, and peer discovery protocols.
• Advanced CQL Operations: Execution of complex queries, schema design principles, and indexing strategies.
• Administrative Utilities: Overview of native system tools, including nodetool and sstableloader.
• Administrative Governance: Management of user accounts, access controls, and data lifecycle processes for government

Monitoring, Troubleshooting, and Operational Best Practices

• Monitoring Infrastructure: Establishment of performance metrics and visualization of cluster health status.
• Diagnostic Procedures: Identification of performance bottlenecks, latency anomalies, and node failures.
• Optimization Strategies: Implementation of configuration best practices for enhanced performance.
• Course Conclusion: Summary of key concepts and final review.