From the course: MySQL Database Administration

Unlock this course with a free trial

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

Relational database management systems

Relational database management systems - MySQL Tutorial

From the course: MySQL Database Administration

Relational database management systems

- [Instructor] All right, let's talk a little bit about relational database management systems. Within a database, we have multiple tables which are grouped together and relate to one another, and collectively, we talk about those as the database or the schema. Then, we have a relational database management system. In this case, we're going to be using MySQL Workbench as that RDBMS, and that's going to be what we use as the interface to access and to manage the relational database using SQL or using some user interface tools that are provided within the RDBMS. Using the relational database management system, administrators are able to grant access to users and they can set specific roles and permissions so that we can see who's able to access data, who has rights to read only, who has rights to actually manipulate the tables, and all of this is done through the relational database management system. Again, the one that we're going to be using is MySQL Workbench. Throughout your…

Contents