Software EngineeringEngineeringFrançais

Database Administration

SWE 205 · Semester 4

5 credits · 21 learning units

Lessons

21 of 21 learning units provide interactive tutorials with worked examples, diagrams, knowledge checks and subject mastery questions. Each check draws five questions from the available bank; question counts vary by unit. The remaining units provide preparation, guided practice or an independent project.

Subunit titles retain the curriculum’s original language.

Shared learning sequence · NWS 246 / SWE 205. Combines complementary topics from both curricula.

Start here

  1. Lesson 1Database services, transactions and administrative boundariesInteractive tutorial

Curriculum topics

  1. Lesson 2Introduction and presentation of MySQLInteractive tutorial
  2. Lesson 3Database Administration and Relational FoundationsInteractive tutorial
  3. Lesson 4MySQL Architecture and Server CoreInteractive tutorial
  4. Lesson 5Server Operations and ConfigurationInteractive tutorial
  5. Lesson 6Data Types and Metadata ManagementInteractive tutorial
  6. Lesson 7MySQL Storage EnginesInteractive tutorial
  7. Lesson 8Presentation of data types; metadata; storage enginesInteractive tutorial
  8. Lesson 9Table Partitioning StrategiesInteractive tutorial
  9. Lesson 10ACID Transactions and Concurrency ManagementInteractive tutorial
  10. Lesson 11Database Security Threats and CountermeasuresInteractive tutorial
  11. Lesson 12User Accounts and Privilege ManagementInteractive tutorial
  12. Lesson 13Management of users and securityInteractive tutorial
  13. Lesson 14Client Access Control and Secure ConnectionsInteractive tutorial
  14. Lesson 15MySQL Client and Administrative UtilitiesInteractive tutorial
  15. Lesson 16Table Maintenance and OptimizationInteractive tutorial
  16. Lesson 17Maintenance of tablesInteractive tutorial
  17. Lesson 18Data Import, Export, and Backup OperationsInteractive tutorial
  18. Lesson 19Practical Administration, Recovery, and Examination PreparationInteractive tutorial

Put it into practice

  1. Lesson 20Guided laboratory: accounts, a slow query and a backupInteractive tutorial

Work independently

  1. Lesson 21Independent project: a tested operations planInteractive tutorial
Curriculum source

HND CURRICULUM-NETWORK AND SECURITY.pdf · NWS 246 · Course table: p. 11 · Outline pages: 201, 202, 203, 204

HND Computer Engineering Software Engineering Curriculum.pdf · SWE 205 · Course table: p. 11 · Outline pages: 46, 47