Week 11
Database Administration - Download PowerPoint
Topics include:
Data Authorization: Download PowerPoint
Assignment 7: Create a user in MySQL for the Student Database created as part of assignment 5 in MySQL. Assign it privileges to be able to Select data from all tables, that is, view all the data. Ensure that the user is not able to delete or update any data. Submit a screen shot displaying the user with their authorizations.
Database Administration - Download PowerPoint
Topics include:
- List functions and roles of data/database administration
- Describe role of data dictionaries and information repositories
- Compare optimistic and pessimistic concurrency control
- Describe problems and techniques for data security
- Understand role of databases in Sarbanes-Oxley compliance
- Describe problems and facilities for data recovery
- Describe database tuning issues and list areas where changes can be done to tune the database
- Describe importance and measures of data availability
Data Authorization: Download PowerPoint
Assignment 7: Create a user in MySQL for the Student Database created as part of assignment 5 in MySQL. Assign it privileges to be able to Select data from all tables, that is, view all the data. Ensure that the user is not able to delete or update any data. Submit a screen shot displaying the user with their authorizations.