Description
Extract, store and verify information using database management systems based on the relational database model, which arranges data into tables of rows and columns, such as Oracle Database, Microsoft SQL Server and MySQL (Oracle Corporation).
This activity excludes programming activities, changing structure of database or designing databases.
Alternative labels
DBMS
Skill type
skill/competence
Skill reusability level
sector-specific
Relationships with occupations
Essential skill
Operate relational database management system is an essential skill of the following occupations:
Data warehouse designer: Data warehouse designers are responsible for planning, connecting, designing, scheduling, and deploying data warehouse systems. They develop, monitor and maintain ETL processes, reporting applications and data warehouse design.
Database administrator: Database administrators test, implement and administer computer databases. They use their expertise in database management systems to plan, coordinate and implement security measures to safeguard computer databases. They also use scripts and configuration files to tailor a database to users’ needs.
Database designer: Database designers specify the database’s logical structure, processes, and information flows. They design data models and databases to serve data acquisition.
Optional skill
Operate relational database management system is optional for these occupations. This means knowing this skill may be an asset for career advancement if you are in one of these occupations.
References
