Skill: Database management
Competency pathway
Technical ability to select, operate and use systems for storing, organising, retrieving and managing data.
Related skills
Computational tools
| Name | Description |
|---|---|
| Azure Data Studio | A retired cross-platform desktop IDE for managing SQL databases (Azure SQL, SQL Server, PostgreSQL). |
| DB2 | A family of data management products including database servers developed by IBM. |
| DBeaver | A free multi-platform database tool for developers and database administrators. |
| Excel | A spreadsheet developed by Microsoft featuring calculation graphing tools and pivot tables. |
| Globus | A research data management service for secure reliable file transfer and sharing. |
| Google Sheets | A web-based spreadsheet application included as part of the Google Docs Editors suite. |
| MongoDB | A source-available cross-platform document-oriented database program. |
| MySQL | An open-source relational database management system. |
| Oracle | A multi-model database management system produced and marketed by Oracle Corporation. |
| PostgreSQL | A free and open-source relational database management system emphasising extensibility and SQL compliance. |
| Redis | An in-memory data structure store used as a distributed cache and message broker. |
| Spreadsheets | A spreadsheet is a computer application for entry, organisation, analysis and storage of data in tabular form. |
| SQL Server | A relational database management system developed by Microsoft. |
| SQLite | A small, fast, self-contained, high-reliability, full-featured, SQL database engine. |
| Toad | A database management toolset from Quest used for application development and administration. |
| Triple stores | A purpose-built database for the storage and retrieval of triples through semantic queries. |
| XML databases | Systems that allow data to be stored in XML format and queried. |
Methodologies
| Name | Description |
|---|---|
| NoSQL | A mechanism for storage and retrieval of data that is modeled in means other than tabular relations. |
| OPeNDAP | A data architectural framework and network protocol for structured data systems. |
| RDF | The Resource Description Framework a standard for model data interchange on the web. |