Database Administration Tutorials
This page is intended to add coverage to the material
presented in the lectures, lecture slides and material otherwise available on this
website. It IS NOT intended as a substitute for attending class.
NOTE: Topics available for the Tutorial Assignments
are those which DO NOT have links to them.
Please Choose from the Topics below:
| |
Database Administration |
|
8.00100 |
What did a typical IS organization look like, and why? |
|
8.00200 |
What does a typical IS organization look like now, and why? |
|
8.00300 |
What is the difference between a DA, DBA and Data Steward? |
|
8.00400 |
What are Data Policies, Procedures and Standards? |
|
8.00500 |
What is involved in Data Planning? |
|
8.00600 |
What other Data Administrator functions are there? |
|
8.00700 |
What are the functions of the Database Administrator? |
|
8.00900 |
What functions are shared between the DA and the DBA? |
|
8.01100 |
What are Data Dictionaries and Repositories? |
|
8.01200 |
How can we improve database performance? |
|
8.01300 |
What is database security, and what threats are there to it? |
|
8.01400 |
How can we manage database security? (2 people
may work together on this) |
|
8.01500 |
What are statistical database and how do they work? |
|
8.01600 |
What is encryption and how does it work? |
|
8.01700 |
What are the basic facilities and components in database recovery? |
|
8.01800 |
What are the ongoing and periodic back-up facilities and how do they
work? |
|
8.01900 |
What are the basic back-up concerns and approaches? |
|
8.02000 |
What are journalizing facilities and how do they work? |
|
8.02100 |
What are checkpont facilties and how do they work? |
|
8.02200 |
What is a recovery manager and for what types of failures is it applied? |
|
8.02300 |
What are the basic recovery-restar procedures?
(2 people may work together on this) |
|
8.02400 |
What strategies can be applied to database recovery? |
|
8.02500 |
What is a transaction and what properties does it have? |
|
8.02600 |
What is an example of a transaction and how would it work? |
|
8.02700 |
What are transaction logs and how do they work? |
|
8.02800 |
What is concurrency control and what are some issues involved?
(2 people may work together on this) |
|
8.02900 |
What is transaction scheduling and how does it work? |
|
8.03000 |
What is database locking and on what levels can it be applied?
(2 people may work together on this) |
|
8.03100 |
What types of locks are there and how do they work? |
|
8.03200 |
What is deadlock and what is an example of how it can occur? |
|
8.03300 |
How can we manage deadlock? |
|
8.03400 |
What is versioning and how does it work? |
|
8.05000 |
What Questions should I be able to answer? |
