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 - 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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.