DEV Community

Cover image for What is RDBMS?
Karl Esi
Karl Esi

Posted on

What is RDBMS?

A relational database management system, or a RDBMS is just a database management system that helps you create and maintain a relational database.

Now, there are very many different relational database management systems out there. Some of the most popular ones are,

  • MySQL
  • SQL Server(By Microsoft)
  • Oracle
  • But of course, there are plenty more.

Each database management system has a different flavor of SQL. But, all these implementations are very similar and are based on the standard SQL specification. So, most of the SQL code that you will learn in this course will work with any database management system.

In this course, we will be using MySQL, which is the most popular open source database in the world.

OK, now to this diagram.

Relational Vs Non-Relational

What about non-relational databases? In non-relational databases, we don't have tables or relationships, these databases are very different from relational databases, but that's a topic for an entirely different course.

What you need to know is that non-relational database management systems don't understand SQL. They have their own query language.

So, we use SQL to work with Relational Database Management Systems.

Happy Coding!
Karl 🤛

P.S. I have a JavaScript eBook(Zero to Mastery) to help you become job-ready by understanding how JavaScript really works behind the scenes. Get it here.

Top comments (0)