NO SQL DB Training Chennai

May 10, 2016

NO SQL DB Training Chennai

NOSQL (Not Only SQL) really is a very wide category for a group of persistence solutions.

Definition from http://nosql-database.org/: Next Generation Databases mostly addressing some of the points: being non-relational, distributed, open-source and horizontally scalable.

Or we can say that,

schema-free,
easy replication support,
simple API,
eventually consistent / BASE (not ACID),
a huge data amount,
and more.

MongoDB Training Chennai

Module 1

Getting started with NoSQL, MongoDB and their Installation

Database type description

What is NoSQL Database?

NoSQL Database ‘s Types

Challenges with RDBMS

Why we require NoSQL data?

What is MONGODB

JSON/BSON Introduction

JSON Data Types

Example of JSON

Installation of MONGODB

Module 2

NoSQL and its iMportance

Database Type

OLTP

OLAP

NOSQL

Type of NOSQL Database

Challenges with RDBMS

Why NOSQL

ACID property

CAP Theorem

Base property

Introduction to Json/ Bson

Json Data types

Database collection & document

MongoDB use cases

Unacknowledged

Acknowledged

Juurnaled

Fsynced

Repica Acknowledged

Module 3

CRUD Operations

MongoDB crud Tutorial

Installation Rent

used ppt

json its syntax

CRUD Introduction,

Read and Write Operations

Write Operation Concern Levels

MongoDB CRUD Tutorials

MongoDB CRUD Reference

Hands on with CRUD Operations

Module 4

Understanding Schema Design, Backup strategies, Data Modeling and Monitoring

Data Modeling in MongoDB

RDBMS vs. Data models

Data Modeling tools

Data modeling example & patterns

Model TREE structure

Operational strategies

Backup strategies

Monitoring

Monitoring Commands

Monitoring of performance issues

Run time configuration

Export & import of data

Relationship between Document

Model Specific Application Contexts

Data Model Reference

Hands on with MongoDB Data Modeling

Module 5

Data Administration and Management

Data Management

Introduction to replica

Election of new primary

Replica set

Type of Replica

Hidden Replica

Arbiter Replica

Sharding

Concepts around Replication

Setting up replicated cluster

Setting up Sharded Cluster

Sharding Database, Collections

Hands on Exercise

Module 6

Indexes and Aggregation

Introduction to Indexes

Concepts around Indexes

Type of Indexes

Index Property

Introduction to Aggregation

Type of Aggregation

Use cases of Aggregation

Hands on Exercise

Module 7

Security in MongoDB

Security Risks to Databases

MongoDB Security Approach

MongoDB Security Concept

Access Control

Integration with MongoDB with Robomongo

Integration with MongoDB with Java

Module 8

Load and Manage Unstructured Data (Videos, Images, Logs, Resumes etc.)

Additional Concept (GridFS à mongo files)

Loading and Managing Unstructured Data (Videos, Images, Logs, Resumes etc.)

Hands-on

Java MongoDB Integration

Problem Statement

It creates a table to insert the video file using the java program. For this it performs following actions:

Installation of Java

Adding MongoDB Java Connector and some simple steps.

Cassandra Training Chennai

Cassandra Training Chennai

Module 1

Advantages and Usage of Cassandra.

Brief Introduction of the course.

Advantages and Usage of Cassandra.

Module 2

CAP Theorem and No SQL DataBase.

Why No SQL DataBase.

Replication in RDBMS.

Key Challenges with RDBMS.

Schema.

No SQL(Not only SQL).

No SQL Category.

Advantage &Limitation.

Key Characteristics of No SQL Data Base.

CAP Theorem.

Consistency.

Module 3

Cassandra fundamentals, Data model, Installation and setup.

What is Cassandra?.

Non relational.

Key deployment concept.

What is column oriented database.

Data Model – column.

What is column family.

Installation.

Module 4

Steps in Configuration.

Token calculation.

Configuration overview.

Node tool.

Validators.

Comparators.

Expiring column.

QA.

Module 5

Summarization, node tool commands, cluster, Indexes, Cassandra & Mapreduce, Installing Ops-center.

Difference between Relational modeling & Cassandra modeling.

Steps in Cassandra modeling.

Time series modeling in Cassandra.

Column family.

Data modeling in Cassandra.

Column family vs. Super column family.

Counter column family.

Partitioners.

Partitioners strategies.

Replication.

Gossip protocols.

Read operation.

Consistency.

Comparison.

Module 6

Multi Cluster setup.

Node settings.

Setup of Multinode cluster.

Row cache and Key cache.

Read operation.

System keyspace.

Commands overview.

Column family.

VNodes.

Module 7

Thrift/AVRO/JSON/Hector Client.

Thrift.

AVRO.

JSON.

Hector client.

How to write a JAVA code.

Hector tag.

Module 8

Secondary index.

Node tool commands.

Management of Cassandra.

Secondary index.

Cassandra & map reduce.

Module 9

Cassandra API and Summarization and Thrift.

API.

Internals of connection pool.

Client connectivity to cassandra.

Hector client key features.

Hector client key concepts.

Java code.

Summarization.

Thrift.