NoSQL Database Tutorial for Beginners

Published: 23 May 2016
on channel: edutechional
27,514
227

Learn how NoSQL databases work and learn when NoSQL is a better option than standard relational databases, and just as importantly when it’s not. We will also walk through some of the popular forms of NoSQL databases and how you can access them for your applications in this NoSQL Tutorial for Beginners.

So first and foremost: what are NoSQL databases and why should I care about them? The easiest way to understand the definition is that NoSQL databases are not SQL databases. Standard relational SQL databases such as Oracle’s SQL server or MySQL have a tabular structure, similar to what you’d see in an Excel spreadsheet. Whereas NoSQL databases have various types of formats and can therefore be more flexible.

For example, imagine that you had to build an application where users were able to define their own fields, such as a survey application where one user may create a survey with two fields and another may create a survey with a hundred fields, and they need to have the ability to be named on the fly. Technically it would be possible to implement this with a relational database, however it would be very clunky. However NoSQL databases could handle this easily, by allowing the fields to be created dynamically and then each record would could be stored with its unique characteristics.

It’s important to note that one of the greatest strengths of NoSQL, it’s flexibility, also presents its greatest challenge. Imagine that you are building out an inventory application that has fields that need to connect to other tables, such as a user table for the employee entering the information, a vendor table, and a tax table to calculate depreciation. If you were to attempt to implement a NoSQL database for this inventory option you’d end up having to work very hard to map the values between the models and it would also make for a very difficult application to maintain. In this case study a relational database (rdms) would work perfectly.

So when you’re trying to decide on NoSQL database design, it really comes down to what the requirements of the application are. If you wanted to chop a tree down you wouldn’t use hammer, you’d use an axe because it’s basic common sense to utilize the right tool for the right job. And it’s the same way with software development, I don’t believe in the SQL vs NoSQL debate, they are both tools and they are the most effective when used in an application that works well with their strengths.

A good rule of thumb is to simply follow the guidelines given by the names themselves:

If you have data that relies heavily on relationships then it’s probably the best fit to utilized a relational SQL database.

If you have an unstructured data set that needs flexibility, than it may be the best option to go with a database that is Not SQL, such as a NoSQL database.

Link to show notes:
https://www.crondose.com/2016/05/nosq...

Follow me:

Twitter:   / jordanhudgens  
Instagram:   / jordanhudgens  
GitHub: http://github.com/jordanhudgens


On this page of the site you can watch the video online NoSQL Database Tutorial for Beginners with a duration of hours minute second in good quality, which was uploaded by the user edutechional 23 May 2016, share the link with friends and acquaintances, this video has already been watched 27,514 times on youtube and it was liked by 227 viewers. Enjoy your viewing!