Visão Geral

Objetivo

Após realizar este Curso Cassandra database Foundation você será capaz de:

• Demonstre modelos de dados.
  
• Crie e use interfaces de banco de dados Cassandra.
  
• Configure o banco de dados Cassandra.

Por que você deve aprender Cassandra?

• Nesta era da ciência de dados, todas as principais empresas multinacionais estão mudando de banco de dados tradicional para NoSQL, portanto, há uma necessidade crescente de profissionais de NoSQL

Publico Alvo

• Arquitetos de dados.
  
• Desenvolvedores da Web.
  
• Investigador.
  
• Analista.
  
• Aspirantes dispostos a construir uma carreira em ciência de dados.
• Gerentes de projeto.
• Desenvolvedores de software.
• Profissionais de teste.
• Analistas.
• Pesquisadores.

Pre-Requisitos

• Não tem pré-requisito! qualquer pessoa pode participar do Curso Cassandra database Foundation  

Informações Gerais

• Carga horaria: 24h
• Se noturno este curso e ministrado de segunda-feira a sexta-feira das 19h às 23h, total de 6 noites,
• Se aos sábados este curso e ministrado das 09h às 18h, total de 3 sábados,

Formato de entrega:

• On-line ao vivo via plataforma de vídeo conferencia. Microsoft Teams, na presença de um instrutor/consultor database mariadb.

Materiais

Conteúdo Programatico

What is Big Data

1. Technology Landscape
2. Big Data Relevance
   
3. Distributed Systems and Challenges
4. Why NoSQL Databases
5. Relational DB vs. NoSQL

Type of NoSQL Databases

1. NoSQL Landscape
   
2. CAP Theorem and Eventual Consistency
   
3. Key Characteristics of NoSQL Database systems
   
4. ACID vs BASE

Cassandra Fundamentals

1. Distributed and Decentralized
2. Elastic Scalability
   
3. High Availability and Fault Tolerance
   
4. Tunable Consistency
   
5. Row-Oriented
   
6. Schema-Free
   
7. High Performance

The Cassandra Data Model

1. The Relational Data Model
2. A Simple Introduction
   
3. Clusters
   
4. Keyspaces
   
5. Hands-on Session

Installation and Setup of Cassandra

1. Single Node Setup
2. Multi-Node Cluster Setup
   
3. Key Configurations for Cassandra
   
4. CLI and Hands-On with Cassandra

Cassandra Modeling

1. Cassandra (Column Family NoSQL DB)
2. Key Concepts – Keyspace – Column Family – Column Family Options – Wide Rows, Skinny Row – Column Sorting – Super Columns – Counter Column Family – Composite Keys and Columns – Time To Live –
   
3. Secondary Indexes in Cassandra
   
4. Difference between Custom Indexes and Secondary Indexes
   
5. Difference between Relational Modeling and Cassandra Modeling
   
6. Key Points to note while modeling a Cassandra Database
   
7. Patterns and Antipatterns in Cassandra Modeling

Cassandra Architecture & Intro to CQL

1. Anatomy of Reading operation in Cassandra
2. Anatomy of the Write operation in Cassandra
   
3. How is Deletes handled in Cassandra
   
4. System Keyspace
   
5. Peer to Peer Model Logical Data Model: Keyspace, Column Family/Table, Rows, Columns
   
6. Traditional Ring design vs. VNodes
   
7. Partitioners: Murmur3, Random (md5) and Byte Ordered
   
8. Gossip and Failure Detection
   
9. Anti-Entropy and Read Repair
   
10. Memtables, SSTables and Commit Log
    
11. Compaction fundamentals to reduce SSTable data files
    
12. Hinted Handoff
    
13. Compaction
    
14. Bloom Filters, Tombstones
    
15. Managers and Services
    
16. VNodes
    
17. Indexes and Caches
    
18. Coordinator node
    
19. Seed nodes
    
20. Write/Read consistency levels: Any, One, Two, Three, Quorum
    
21. Snitches: Dynamic snitching, Simple Snitch, Rack Inferring Snitch, Property File Snitch, Gossiping Property File Snitch
    
22. Routing Client requests
    
23. Nodetool commands: gossipinfo, cfstats, describing
    
24. YAML file fundamentals
    
25. Operations management web GUI
    
26. Stress testing Cassandra
    
27. CQL command fundamentals

Cassandra CQLSH

1. SQL over Cassandra
2. Composite Keys
   
3. Hands-on examples on CQL 3.0

Cassandra Clients

1. How to establish Client Connections
2. Thrift Client
   
3. Connection Pooling
   
4. Auto-discovery and Failover in Hector
   
5. Client with CQL

Cassandra Monitoring and Administration

1. Tuning Cassandra
2. Backup and Recovery methods
   
3. Balancing
   
4. Bootstrapping
   
5. Node Tools Commands
   
6. Upgrades
   
7. Monitoring critical metrics
   
8. Bulk Loading Data to Cassandra
   
9. Bulk Export of Data from Cassandra
   
10. Hands-on Examples for each of them

Cassandra Analytics Cluster

1. Cassandra Hadoop Integration

Cassandra Search Cluster

1. Integration of Solr with apache Cassandra
2. Search Query on Cassandra