Course Instructor: 

Syllabus:

This course introduces students to the foundations of database systems and prepares them to administer complex databases. It introduces students to the foundations of database systems, focusing on basics such as the relational algebra, data model, schema structure and database instance memory and storage structures.

The main focus is learning how to perform basic database operations on enterprise level systems. Due to the fact that database administration involves a high degree of knowledge in the fields of networking, operating system tuning and scripting, the first part of this course focuses on the practical aspects of datacenter management. The student then learns how to install and configure the different aspects of a database, such as the instance, the storage and the network access.

The last part of this course focuses on advanced topics such as database backup and recovery procedures and data migration.