Competency information
Details
Implement a disaster recovery strategy, including resilience security backup and production of both Disaster Recovery (DR) and Business Continuity (BC) plans
Considerations
Database management and data mining
- The relational model of data
- Implementation of relational databases
- Advanced SQL programming
- Query optimisation
- Concurrency control and transaction management
- Database performance tuning
- Distributed relational systems and data replication
- Column store/data warehousing database engines
- Document oriented databases (eg Lucene)
- Security considerations
- Data mining
- Large data set methodologies
- Database standards and standards for interoperability and integration
- Data analysis and presentation
- The use of commonly available databases, spreadsheets and statistics packages (eg MS SQL, mySQL, SPSS, Excel, Minitab, SAS, R)
Relevant learning outcomes
| # | Outcome |
|---|---|
| # 1 | Outcome Develop a database structure to meet a clinical need |