Course Outline
- Section 1: Introduction to Big Data and NoSQL for Government
- NoSQL Overview
- CAP Theorem
- When NoSQL is Appropriate for Government Use Cases
- Columnar Storage Techniques
- The NoSQL Ecosystem and Its Applications in Public Sector Operations
- Section 2: Cassandra Basics for Government
- Design and Architecture of Cassandra for Efficient Data Management
- Cassandra Nodes, Clusters, and Datacenters for Scalable Deployment
- Keyspaces, Tables, Rows, and Columns in the Context of Public Sector Databases
- Partitioning, Replication, and Tokens for Ensuring Data Integrity
- Quorum and Consistency Levels to Enhance Data Reliability
- Laboratory Exercises: Interacting with Cassandra Using CQLSH for Practical Application
- Section 3: Data Modeling – Part 1 for Government
- Introduction to CQL (Cassandra Query Language) for Effective Data Manipulation
- CQL Datatypes and Their Applicability in Government Databases
- Creating Keyspaces and Tables to Organize Government Data
- Selecting Columns and Data Types for Optimal Performance
- Choosing Primary Keys to Ensure Efficient Query Execution
- Data Layout for Rows and Columns to Enhance Data Accessibility
- Time to Live (TTL) for Managing Temporary Data in Government Systems
- Querying with CQL to Retrieve and Analyze Public Sector Data
- CQL Updates for Maintaining Accurate and Current Information
- Collections (List, Map, Set) for Storing Complex Data Structures
- Laboratory Exercises: Various Data Modeling Exercises Using CQL; Experimenting with Queries and Supported Data Types
- Section 4: Data Modeling – Part 2 for Government
- Creating and Using Secondary Indexes to Improve Query Performance
- Composite Keys (Partition Keys and Clustering Keys) for Advanced Data Organization
- Time Series Data Management for Government Applications
- Best Practices for Time Series Data in Public Sector Databases
- Counters for Tracking Aggregate Information
- Lightweight Transactions (LWT) for Ensuring Data Consistency
- Laboratory Exercises: Creating and Using Indexes; Modeling Time Series Data for Government Use Cases
- Section 5: Data Modeling Laboratories: Group Design Session for Government
- Presentation of Multiple Use Cases from Various Government Domains
- Students Work in Groups to Develop Designs and Models for Public Sector Applications
- Discussion and Analysis of Various Designs, Evaluating Decision-Making Processes
- Laboratory Exercise: Implementing One of the Scenarios for a Real-World Government Application
- Section 6: Cassandra Drivers for Government
- Introduction to the Java Driver for Integrating Cassandra with Government Systems
- CRUD (Create, Read, Update, Delete) Operations Using the Java Client for Efficient Data Management
- Asynchronous Queries for Enhancing Performance in High-Volume Government Applications
- Laboratory Exercises: Using the Java API for Cassandra to Develop Government-Specific Solutions
- Section 7: Cassandra Internals for Government
- Understanding Cassandra Design and Architecture Under the Hood for Optimal Configuration in Public Sector Environments
- SSTables, Memtables, and Commit Logs for Efficient Data Storage and Retrieval
- Read Path and Write Path to Optimize Data Access and Modification
- Caching Mechanisms to Enhance Performance in Government Databases
- Vnodes for Flexible and Scalable Deployment of Cassandra Clusters in the Public Sector
- Section 8: Administration of Cassandra for Government
- Hardware Selection Guidelines for Government Deployments
- Cassandra Distributions and Their Suitability for Public Sector Use
- Cassandra Best Practices, Including Compaction and Garbage Collection Strategies
- Troubleshooting Tools and Tips to Ensure Smooth Operation in Government Environments
- Laboratory Exercise: Students Install Cassandra, Run Benchmarks, and Evaluate Performance for Government Applications
- Section 9: Bonus Laboratory (Time Permitting) for Government
- Implementing a Music Service Similar to Pandora or Spotify Using Cassandra for Government Use Cases
Requirements
- Proficient in the Java programming language for government applications.
- Experienced in a Linux environment, including navigating the command line and editing files using vi or nano for government tasks.
Testimonials (7)
The practical exercises and examples of implementing examples of real models and contexts.
Leandro Gomes
Course - Cassandra for Developers
I enjoyed the very good explanations with in depth examples.
Rui Magalhaes
Course - Cassandra for Developers
I liked all technical explanation and theoretical introduction.
Andre Santos
Course - Cassandra for Developers
I liked the amount of exercises. We could immediately apply the knowledge shared and ensure the information was on point.
Joana Pereira
Course - Cassandra for Developers
There was a lot of knowledge and material shared that will help me to do my current tasks.
Miguel Fernandes
Course - Cassandra for Developers
I already using and have an application in production with Cassandra so mostly of the topics i already know but the data modeling and advanced topics are a lot interesting.
Tiago Costa
Course - Cassandra for Developers
The last exercise was very good.