|
Download competency document
Unit Elements (and matched outcomes)
| 1. Choose server application | 1 | | 2. Choose network operating system | 1 | | 3. Select server components | 1 | | 4. Design server | 2 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Determine database functionality | 2 | | 2. Identify scalability and functionality requirements | 2 | | 3. Prepare database functionality and scalability report | |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Undertake database management system modelling | 1 | | 2. Monitor database performance | 3, 6 | | 3. Seek client feedback and signoff | |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Write a simple SQL statement to retrieve and sort data | | | 2. Write an SQL statement that selectively retrieves data | | | 3. Write SQL statements that use functions | | | 4. Write SQL statements that use aggregation and filtering | | | 5. Write SQL statements that retrieve data from multiple tables | | | 6. Write and execute SQL subqueries | | | 7. Create and manipulate tables | 2 | | 8. Create and use views | 2, 3 | | 9. Create and use stored procedures | 3 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Confirm server specification | 1 | | 2. Build server | | | 3. Configure and test server | 6 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Prepare database | 4 | | 2. Create database logons | 5 | | 3. Create data source names | 2, 3 | | 4. Test database connectivity | 3 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Determine function of operating systems | | | 2. Obtain operating system | | | 3. Install, configure and optimise operating system | 1 | | 4. Provide instruction to meet new software requirements | |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Develop installation plan | 1 | | 2. Install server | 1 | | 3. Monitor server operation | 3, 6 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Review database architecture | 1 | | 2. Determine backup methods appropriate to database requirements | 3 | | 3. Establish recovery points and disaster recovery procedures | 3 | | 4. Create and deploy standby database | |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Diagnose problems | 2, 3, 5 | | 2. Configure database | 2, 3, 5 | | 3. Tune database | 3, 5 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Ensure user accounts are controlled | 5 | | 2. Secure file and resource access | 5 | | 3. Monitor threats to the network | |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Start up a database | 6 | | 2. Manage database | 3, 6 | | 3. Manage database access | 6 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Identify threats to system | | | 2. Determine risk category | | | 3. Identify appropriate controls | 3 | | 4. Include controls in the system | 5, 6 | | 5. Monitor system tools and procedures | 3, 6 |
|
|
Download competency document
Unit Elements (and matched outcomes)
| 1. Maintain business website and contents | 5 | | 2. Maintain business security of the website | 5 | | 3. Monitor business website performance | 5 | | 4. Undertake capacity planning | |
|
