Scylla Database Administration & Operations Training Course

Core Foundations and System Architecture

• Scylla Overview: Examining its history, ideal use cases, and performance benchmarks relative to Cassandra.
• Architectural Analysis: A detailed look at sharding, partitioning, and the inherent distributed characteristics of the database.
• Data Modeling: Grasping the concepts of Clustering Keys, Partitions, and supported Data Types.
• Query Language Fundamentals: An introduction to Cassandra Query Language (CQL) and utilizing the CQL shell.

Cluster Deployment and Administrative Tasks

• Installation Procedures: Deploying Scylla across various operating system platforms.
• Cluster Configuration: Managing seeding, replication strategies, and node discovery mechanisms.
• Advanced CQL Usage: Crafting complex queries, designing schemas, and implementing indexing strategies.
• Utility Tools: Familiarizing with built-in management utilities such as nodetool and sstableloader.
• Administrative Governance: Handling user management, access permissions, and data lifecycle policies.

Monitoring, Diagnostic Troubleshooting & Operational Best Practices

• Performance Monitoring: Establishing metrics collection and visualizing overall cluster health.
• Diagnostic Troubleshooting: Pinpointing performance bottlenecks, latency spikes, and node failures.
• Optimization Strategies: Implementing configuration best practices for peak performance.
• Course Conclusion: A comprehensive summary of key takeaways and final thoughts.