Database II

At the end of this course, the successful student will be able to:

1. Explain the purpose of indexing;
2. List different types of indexes;
3. Evaluate and explain when to use an index on a column;
4. Describe how a SQL query is processed by the DB engine;
5. Generate a more efficient query which reduces resource consumption but provides same data results;
6. Explain situations when DB transactions should be used;
7. Plan a set of queries which could be executed as part of a transaction - including both the success and failure scenarios;
8. Describe why and when denormalization is beneficial for a DB system;
9. Execute the denormalization process;
10. Design a star schema;
11. Use a DW/OLAP cube to extract information from data;
12. Use a noSQL DB to perform CRUD (Create, Retrieve, Update, Delete) operations;
13. Demonstrate application of MapReduce functions;
14. Describe common DB security issues and their solutions.