Scylla Database Administration & Operations Training Course

Core Foundations and Architecture

• Scylla Introduction: Overview of its history, typical use cases, and performance benchmarks relative to Cassandra.
• Architecture Analysis: A deep dive into sharding, partitioning, and the distributed nature of the database.
• Data Modeling: Grasping the concepts of Clustering Keys, Partitions, and Data Types.
• CQL Fundamentals: An introduction to Cassandra Query Language and operations using the CQL shell.

Cluster Deployment and Management

• Installation Procedures: Deploying Scylla across various operating system platforms.
• Cluster Setup: Managing seeding, replication strategies, and node discovery.
• Advanced CQL Usage: Executing complex queries, optimizing schema design, and implementing indexing.
• Utility Tools: Familiarization with built-in utilities such as nodetool and sstableloader.
• Administrative Tasks: Handling user management, permissions, and data lifecycle operations.

Monitoring, Troubleshooting & Best Practices

• Monitoring: Configuring metrics collection and visualizing overall cluster health.
• Troubleshooting: Diagnosing performance bottlenecks, latency issues, and node failures.
• Performance Optimization: Applying configuration best practices for enhanced throughput.
• Course Summary: Comprehensive review and concluding remarks.