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

Hiren Ahir

Microsoft Azure SQL Sever Developer, BI Developer

I'm a Graduate student and came into the job market and found a university degree wasn't sufficient to get a good paying job. I aimed at hottest technology in the market Big Data but the word BigData... 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

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.

The goal of this hadoop project is to apply some data engineering principles to Yelp Dataset in the areas of processing, storage, and retrieval.

In this big data project, we will talk about Apache Zeppelin. We will write code, write notes, build charts and share all in one single data analytics environment using Hive, Spark and Pig.

Curriculum For This Mini Project