SQL vs NoSQL-Choosing the right DBMS for your Project

SQL vs NoSQL-Choosing the right DBMS for your Project

In this project, we will walk through all the various classes of NoSQL database and try to establish where they are the best fit.

Videos

Each project comes with 2-5 hours of micro-videos explaining the solution.

Code & Dataset

Get access to 50+ solved projects with iPython notebooks and datasets.

Project Experience

Add project experience to your Linkedin/Github profiles.

What will you learn

Review of designing in RDBMS
Using Key-Value Store (Redis)
Using Columnar Store (HBase)
Using Document-Oriented Store (MongoDB)
Using Graph Database (Neo4J)
Using Search Engine (ElasticSearch)
How to make data platform decision on which to use

Project Description

Data engineering involves a lot of decisions. And with the dozens of database solutions that we have currently, choosing a database or data storage platform is certainly one decision to make with the right knowledge and competence. 
NoSQL databases offer different paradigm and capability totally different from what we know in traditional relational database management systems (RDBMS). Also, data decision are made usually during application development until when getting the value of the data it becomes an issue.

In this Hackerday, we want to go through all the classes of NoSQL that is and pick an example of the lot. This Hackerday is not an intensive review into each of them but we will do well to mention what can be offered in each example.

We will begin with the traditional or popular RDBMS, discuss the features, functionalities, and limitations. In the light of that, we will walk through all the various classes of NoSQL database and try to establish where they are the best fit.

At the end of this Hackerday, students will be able to adequately make a choice of database type given a required business specification and non-functional requirement. Also, students will be able to take on any interview to show their wide knowledge of the different database solutions in the market.

Similar Projects

In this hadoop project, we are going to be continuing the series on data engineering by discussing and implementing various ways to solve the hadoop small file problem.

In this big data project, we will look at how to mine and make sense of connections in a simple way by building a Spark GraphX Algorithm and a Network Crawler.

In this big data project, we will continue from a previous hive project "Data engineering on Yelp Datasets using Hadoop tools" and do the entire data processing using spark.

Curriculum For This Mini Project