Competency information
Details
Creation of a relational database in 3rd normal form, including appropriate data typing, precision
and the use of structured coding schemes
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 |
| # 2 | Outcome Implement SQL and data mining strategies on a large data set |