Course Outline

  • Section 1: Introduction to Big Data / NoSQL for Government
    • NoSQL Overview
    • CAP Theorem
    • When is NoSQL Appropriate for Government
    • Columnar Storage
    • NoSQL Ecosystem for Government Applications
  • Section 2: Cassandra Basics for Government Operations
    • Design and Architecture of Cassandra
    • Cassandra Nodes, Clusters, and Data Centers
    • Keyspaces, Tables, Rows, and Columns
    • Partitioning, Replication, and Tokens
    • Quorum and Consistency Levels
    • Labs: Interacting with Cassandra Using CQLSH for Government Users
  • Section 3: Data Modeling – Part 1 for Government Applications
    • Introduction to CQL (Cassandra Query Language)
    • CQL Datatypes for Government Datasets
    • Creating Keyspaces and Tables for Government Use
    • Choosing Columns and Types for Government Data
    • Choosing Primary Keys for Government Records
    • Data Layout for Rows and Columns in Government Databases
    • Time to Live (TTL) for Government Data Management
    • Querying with CQL for Government Analysts
    • CQL Updates for Government Data Maintenance
    • Collections (List, Map, Set) in Government Databases
    • Labs: Various Data Modeling Exercises Using CQL; Experimenting with Queries and Supported Data Types for Government Use
  • Section 4: Data Modeling – Part 2 for Government Applications
    • Creating and Using Secondary Indexes for Government Databases
    • Composite Keys (Partition Keys and Clustering Keys) for Government Data
    • Time Series Data for Government Tracking
    • Best Practices for Time Series Data in Government Applications
    • Counters for Government Metrics
    • Lightweight Transactions (LWT) for Government Operations
    • Labs: Creating and Using Indexes; Modeling Time Series Data for Government Use
  • Section 5: Cassandra Internals for Government IT Professionals
    • Understanding Cassandra Design Under the Hood for Government Systems
    • SSTables, Memtables, and Commit Log in Government Databases
  • Section 6: Administration of Cassandra for Government IT Teams
    • Hardware Selection for Government Data Centers
    • Cassandra Distributions for Government Use
    • Cassandra Nodes Communication in Government Networks
    • Writing and Reading Data to/from the Storage Engine for Government Operations
    • Data Directories for Government Data Management
    • Anti-Entropy Operations for Government Data Integrity
    • Cassandra Compaction for Government Databases
    • Choosing and Implementing Compaction Strategies for Government Use
    • Cassandra Best Practices (Compaction, Garbage Collection) for Government IT Teams
    • Creating a Test Cassandra Instance with Low Memory Footprint for Government Testing
    • Troubleshooting Tools and Tips for Government IT Staff
    • Labs: Students Install Cassandra, Run Benchmarks for Government Use

Requirements

  • Proficient in a Linux environment (navigating the command line, editing files with vi or nano)
  • For on-site courses, participants should bring a laptop or desktop equipped with 8 GB of RAM
  • For remote courses, a functional Cassandra lab will be provided for government use, requiring only a web browser
 14 Hours

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories