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.

Customer Love

Read All Reviews

Prasanna Lakshmi T

Advisory System Analyst at IBM

Initially, I was unaware of how this would cater to my career needs. But when I stumbled through the reviews given on the website. I went through many of them and found them all positive. I would... Read More

Nathan Elbert

Senior Data Scientist at Tiger Analytics

This was great. The use of Jupyter was great. Prior to learning Python I was a self taught SQL user with advanced skills. I hold a Bachelors in Finance and have 5 years of business experience.. I... Read More

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

Explore hive usage efficiently in this hadoop hive project using various file formats such as JSON, CSV, ORC, AVRO and compare their relative performances

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 NoSQL project, we will use two NoSQL databases(HBase and MongoDB) to store Yelp business attributes and learn how to retrieve this data for processing or query.

Curriculum For This Mini Project