NoSQL Database is a practical training program designed to help IT professionals understand modern non-relational database technologies and their applications in large-scale data environments. The course covers essential NoSQL concepts, data models, database architecture, scalability, availability, distributed data storage, and real-world use cases. Participants will explore popular NoSQL technologies such as MongoDB, Cassandra, and HBase, gaining practical knowledge of how NoSQL databases can support high-volume, flexible, and distributed data workloads for modern applications, Big Data platforms, and cloud-based systems.
Course Overview:
NoSQL Database is a comprehensive, hands-on training program designed to help database and IT professionals understand, evaluate, and work with modern NoSQL database technologies. The course introduces the fundamental principles of NoSQL databases, including distributed and decentralized architectures, elastic scalability, high availability, fault tolerance, data models, and the advantages and limitations of different NoSQL database types.
Participants will gain practical experience with three widely used NoSQL technologies: HBase, Apache Cassandra, and MongoDB. The HBase module covers architecture, data modeling, schema design, HBase Shell and API operations, services, monitoring, and database management. The Cassandra module explores distributed architecture, data modeling, compound keys, clustering, indexing, querying, administration, monitoring, and large-scale deployment scenarios. Participants will also compare HBase and Cassandra to understand when each technology is most appropriate.
The MongoDB module introduces document-oriented database concepts, architecture, CRUD operations, data import and export, schema design, indexing, replica sets, sharding, and monitoring. Through practical exercises, participants will develop a better understanding of how different NoSQL technologies handle data storage, scalability, availability, and high-volume workloads.
By the end of the course, participants will be able to compare NoSQL database technologies, select appropriate solutions for different use cases, perform essential database operations, design effective data models, and apply administration and management techniques for modern distributed data environments.
Course Objectives:
By the end of this course, participants will be able to:
- Understand the fundamentals, architecture, and principles of NoSQL databases.
- Explain distributed, decentralized, scalable, highly available, and fault-tolerant database architectures.
- Identify the major types of NoSQL databases and their appropriate use cases.
- Compare the features, advantages, limitations, and operational requirements of different NoSQL technologies.
- Work with HBase architecture, data models, schemas, Shell, APIs, and database operations.
- Design and manage HBase schemas and perform basic and advanced data operations.
- Monitor and administer HBase databases in distributed environments.
- Understand Apache Cassandra architecture, data modeling, keyspaces, tables, compound keys, and clustering.
- Perform Cassandra data operations, queries, indexing, and schema modifications.
- Apply Cassandra monitoring and administration techniques.
- Compare HBase and Cassandra as wide-column NoSQL database technologies.
- Understand MongoDB architecture, document-based data modeling, and CRUD operations.
- Create appropriate MongoDB indexes and understand replica sets and sharding.
- Monitor MongoDB environments and apply basic database management practices.
- Evaluate NoSQL technologies and select an appropriate database based on application and data requirements.
Pre-requisites:
- Web and Java Application developer
Target Audience:
- A Basic knowledge of core java
- Experience with any other web framework will be helpful.
Course Duration:
- 28 hours – 4 days
Course Content:
Module 1: Introduction to NoSQL Database
- What Is Meant By NoSQL?
- Distributed and Decentralized
- Elastic Scalability
- High Availability and Fault Tolerance
- Major types of NoSQL databases •Primary use case Advantages/disadvantages of each type
Module 2: Hbase NoSQL Database
- Use cases and usage occasions for HBase
- HDFS vs.HBase, HBase Use Cases, Data Modeling HBase
- Identify architectural components and core concepts of HBase
- HBase functionality
- HBase schema design
- HBase services and data operations
- HBase Shell, HBase API, Primary Operations, Advanced Operations
- Monitor and Manage HBase database
Module 3: Cassandra NoSQL Database
- Describe Apache Cassandra
- Common use cases – large deployments
- Cassandra architecture
- Cassandra Data Model
- Cassandra Data Access and Operation
- Data Modeling
- Compound keys and clustering
- Expiring columns
- Using natural or surrogate primary keys
- Indexing About indexing (When to use an index and when not to use an index)
- Using multiple indexes
- Using the database
- Querying Cassandra
- Creating a table
- Using a compound primary key
- Inserting data into a table
- Using the keyspace qualifier
- Determining time-to-live for a column
- Determing the date/time of a write
- Adding columns to a table
- Altering the data type of a column
- Removing data
- Expiring columns
- Dropping a table or keyspace
- Deleting columns and rows
- Cassandra Monitoring and Administration
- Compare HBASE vs Cassandra NoSQL wide column store database
Module 4 : MongoDB NoSQL Database
- MongoDB Overview and Use cases
- MongoDB Architecture and concepts
- MongoDB CRUD operation
- Data In and Data Out
- Schema Design and Modelling
- Indexing, Replica set, Sharding and Monitoring
Lab Details:
- Windows 7 or Higher
- 16 GB RAM
- VMWare Player
- Oracle virtual box
- 100 gb Hard Disk Space
- Internet Connection
