| | 1 | Other Topics |
| | 2 | SQL Performance |
| | 3 | |
| | 4 | Document performance analysis for each complex query that you have produced: |
| | 5 | |
| | 6 | Propose indexes that could improve the performance of the query. |
| | 7 | Document performance analysis using EXPLAIN PLAN to execute the query before the creation of the indexes, and after the creation of the indexes. |
| | 8 | Document whether the indexes were truly used in the execution plan |
| | 9 | Conclusion about the performance gains |
| | 10 | Security measures |
| | 11 | |
| | 12 | Document the security measures you have introduced in your application related to database access (prevention of SQL injection, prevention of un-authorized access to data, …) |
| | 13 | Document the security measures you have introduced in your database related to database access (prevention of SQL injection in dynamic queries, prevention of un-authorized access to data, …) |
| | 14 | Other developments |
| | 15 | |
| | 16 | … |
