Course Course Course T L I C
V20UDS502 NOSQL C Professional Core
Code Name Category 5
Course Learning Rationale
The purpose of learning this course is: Learning Program Learning Outcomes (PLO)
(CLR):
CLR-1 : To understand the basic concepts of NoSQL 1 2 3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
CLR-2 : To explore the emergence requirements and benefits of NoSQL database
Level of Thinking (Bloom)
Expected Proficiency (%)
Expected Attainment (%)
Fundamental Knowledge
Application of Concepts
Analyze, Interpret Data
CLR-3 : To understand the basic architecture and data models of NoSQL database
Procedural Knowledge
Problem Solving Skills
Communication Skills
Skills in Specialization
Professional Behavior
CLR-4 : To describe about the various tools such as MongoDB, Cassandra, HBaseetc
Life Long Learning
Investigative Skills
Skills in Modeling
Link with Related
CLR-5 : To understand the basic storage architecture in a distributed environment
Analytical Skills
Ability to Utilize
CLR-6 : To develop NoSQL desktop and cloud database solutions
Knowledge
Disciplines
ICT Skills
Course Learning Outcomes
At the end of this course, learners will be able to:
(CLO):
CLO-1 : Differentiate between a relational database and a non-relational database 3 80 70 L H - H L - - - L L - H - - -
CLO-2 : Perform basic database administration tasks 3 85 75 M H L M L - - - M L - H - - -
Define the major types of NoSQL databases including a primary use case and advantages and M H M H L - - - M L - H - - -
CLO-3 : 3 75 70
disadvantages of each type
CLO-4 : Describe the NoSQL data architecture patterns 3 85 80 M H M H L - - - M L - H - - -
CLO-5 : Create wide-column, document, key/value, graph and object oriented databases 3 85 75 H H M H L - - - M L - H - - -
CLO-6 : Develop NoSQL desktop and cloud database solutions 3 80 70 L H - H L - - - L L - H - - -
Duration
18 18 18 18 18
(hour)
Introduction to Neo4j graph
SLO-1 Introduction to NoSQL Introduction to MongoDB Data types in MongoDB Introduction to Cassandra
database
S-1 MongoDB operators, Query and
Data Replication in Cassandra, Advantages of Neo4j graph
SLO-2 Features of NoSQL MongoDB evolution Projection Operator, update
Components of Cassandra database
operator
Advantages and disadvantages of
SLO-1 NoSQL Features of MongoDB MongoDB limit(),sort() MongoDB versus Cassandra Features of Neo4j graph database
S-2
Cassandra-Data Model, Cluster,
SLO-2 SQL Versus NoSQL SQL versus MongoDB Query Modifiers RDBMS Versus Graph Database
Keyspace
Column Family, Attributes of
Database Commands: Aggregation
SLO-1 NoSQL Schema modeling RDBMS versus MongoDB
Commands, Geospatial Command
Column Family, Column, Super MongoDB Versus Neo4j
column
S-3
Database Commands: Query plan
Cassandra Query Language-CQL Graph Data Model, Working with
SLO-2 Schema design MongoDB Schema Design cache Commands, Authentication
Clauses Neo4j
Commands
Database Commands: User and
SLO-1 NoSQL Database Environment Modeling data for atomic operations Cassandra Table Operations Neo4j-Cypher Query Language
Role management Commands
S-4
Database Commands: Replication,
SLO-2 How NoSQL Database works? Modeling Relationships
sharding and session commands
Cassandra CURD Operations Neo4j-CQL datatypes, operators
SLO-1 Lab 1: Query to extract fields from a
Lab 7: Query to create a new user Lab 10: Query to create, alter,
S table Lab 4: Query to map publisher and Lab 13: Simple Queries using CQL
for the database using createUser truncate and drop a table
5-6 SLO-2 Query to retrieve the records from a book relationships. command Query to create and drop index
operators
table
Query using geoSearch Command
58
The value of Relational Databases, Cassandra-Shell, Neo4j-CQL functions: String
SLO-1 Scripting for the Mongo Shell MongoDB CRUD operations
Getting at Persistent data capture, copy functions
S-7
Concurrency, Integration, Standard Aggregation, Aggregation Pipeline, Cassandra-Shell, Neo4j-CQL functions: Aggregate
SLO-2 Model CRUD using the Shell
Map-Reduce describe, expand functions
Cassandra Key Space Operations,
SLO-1 Impedance Mismatch Introduction to Data Modeling Creating and deleting a database Neo4j-CQL Creating a single node
create, alter and drop key space
S-8
Application and Integration Neo4j-CQL Creating a node with
SLO-2 Databases Data Modeling Concepts Creating and dropping collection CQL data types
single label
CRUD Documents : Insert , Delete Neo4j-CQL Creating a node with
SLO-1 Attack of the Clusters Data Model Examples and Patterns
and Update documents
CQL collections
multiple labels
S-9
CRUD Documents: Update and Neo4j-CQL Creating a relationship
SLO-2 The emergence of NoSQL Transactions, Shared Clusters CQL user defined datatype
Query Documents between existing nodes
Indexes, Single Field Indexes, Cassandra Tools: node tool, Neo4j-CQL Creating a relationship
SLO-1 Aggregate Data Models Compound Indexes
MongoDB text search
SSTable tools with label and properties
S-10
Example of Relations and Cassandra Tools: Cassandra Neo4j-CQL Creating a complete
SLO-2 Text Indexes, Wildcard Indexes SQL to MongoDB Mapping
Aggregates Stress path
SLO-1 Lab 2: Query for filtering all rows, Lab 5: Query to create Single field Lab 8: Query to modify existing
S Lab 11: Query to create a list, map Lab 14: Query to create a node
Index, Compound Index document in the collection
Query for filtering the rows based and set with single label
11- Query to create Text Index, Query to delete multiple documents
SLO-2 on conditions Wildcard Index from the collection
Query to create, alter, drop and Query to create a relationship with
12 describe user defined datatype label and properties
Key Value and Document Data Security, Authentication, Role MongoDB Shell, Shell Collection Neo4j-CQL General Clauses, limit
SLO-1 Models, Column-Family Stores Introduction to HBase
based access control Methods clause, skip clause, unwind clause
S-13
Summarizing Aggregate-Oriented Replication in MongoDB, Cursor Methods, Query Plan Cache Features of HBase, Applications of Neo4j-CQL General Clauses,
SLO-2
Databases Redundancy and Data availability Methods HBase orderby, return clause, with clause
Neo4j-CQL Read Clauses, Match,
Data Models, Relationships, Graph Replica set Oplog ,Replica set High User Management Methods, Role
SLO-1 Databases, Schemaless Databases Availability Architecture of HBase Optional Match, where clause and
Management Methods
count
S-14
Neo4j-CQL Write Clauses, Merge
Sharding, Sharded Cluster MongoDB Cloud: MongoDB stitch,
SLO-2 Modeling for Data Access Storage mechanism in HBase Command, Set Clause, Remove
Components, Shard Keys Atlas
Clause
Distribution Models, single server, Data Partitioning with chunks MongoDB Cloud: MongoDBcoud Neo4j-CQL Write Clauses, Delete
SLO-1 sharding HBase General Commands
,Create chunks in a sharded cluster manager, Ops manager Clause, for each clause
S-15 HBase Shell, Data Definition
Master-Slave Replication, Peer-to- Split chunks in a sharded cluster, MongoDB Tools: MongoDB
SLO-2 Peer Replication Commands, Database backup and recovery
Merge chunks in a sharded cluster Compass
Data Manipulation Commands
Consistency, Update Consistency,
Sharding Strategy, Hashing MongoDB Tools: MongoDB BI
SLO-1 Read Consistency, Relaxing Class HBase Configuration Creating and deleting an index
Sharding, Ranged Sharding Connector
S-16 Consistency
Zones in Sharded Clusters, Creating and dropping unique
SLO-2 CAP Theorem Collations in Sharding
Connecting to MongoDB HBase Security
constraint
Lab 6: Query to create chunks for Lab 15: Query to create and delete
SLO-1 Lab 3: Query using aggregate Lab 9: Steps to create a MongoDB
S documents in Lab 12: Query using HBase Data an index
account,
functions the [Link] collection using Definition Commands Query to read, write and remove
17- Steps to create an Atlas account
Query using orderby command the email field as the key, Query to Query using HBase Data clause
18 SLO-2 and deploy a free tier cluster
merge contiguous chunks on the Manipulation Commands Queries to create and drop unique
same shard. constraints
1. NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence
Learning
,Pramod J. Sadalage, Martin Fowler, Pearson Education. 3. Olivier Pivert. NoSQL Data Models: Trends and Challenges, 1st ed. Wiley, 2018.
Resources
2. Shashank Tiwari. Professional NoSQL, John Wiley and Sons. 4. Eric Redmond, E. & Jim R. Wilson : Seven Databases in Seven Weeks: A Guide to
59
Modern Databases and the NoSQL Movement, 1st Edition.
Course Designers
Experts from Industry Experts from Higher Technical Institutions Internal Experts
[Link].A
60