Learning Outcomes

Upon successful completion of this course, you should be able to:

• Define a ‘database’
• Perform the three primary responsibilities of a database administrator
• Summarize the foundational concepts that guarantee database reliability
• Explain the installation process of a MySQL Community Server
• Outline how locks can establish data consistency
• Recognise the four isolation levels of MySQL
• State how MySQL implements a specific founding principle
• Compare and contrast a clustered and non-clustered index
• Evaluate the impact of creating an index on a database
• Understand MySQL database maintenance tasks