From the course: Data Management Essential Training

Unlock this course with a free trial

Join today to access over 24,400 courses taught by industry experts.

Database management systems (DBMS)

Database management systems (DBMS)

From the course: Data Management Essential Training

Start my 1-month free trial Buy for my team

Database management systems (DBMS)

“

- [Narrator] Now, as I mentioned, I started my IT career as a database administrator, so obviously, my favorite storage option is a database management system or DBMS, but it's not always the right option. Let's talk about what a DBMS is and when it's the right option for storing the data. There are two main flavors of DBMS, relational and non-relational. Depending on the type of data we have will determine which is the best option for our use case. Some examples of relational databases are Microsoft SQL Server, Oracle, or MySQL. There are differences between these systems, such as licensing requirements, price points, and features, but they're all good at storing structured data in tables with columns and rows. On the other hand, non-relational databases are good for storing semi-structured or unstructured data. These databases can be further broken up into the kind of data they store. Some examples will be document databases such as MongoDB or CouchDB, key value stores such as…

Contents