Database Administration

This course introduces the roles and responsibilities, as well as the critical knowledge and skills, needed to function as a database administrator. The course focuses on Oracle and Microsoft SQL Server RDBMSs and the Oracle NoSQL databases. Database administration covers a range of topics which are covered in this course; installation, configuration, performance tuning, maintenance, and database security. Special focus will be paid to the architecture of the RDBMS and NoSQL systems, using it as the basis of much of the work throughout the course. There will be weekly hands-on lab work that afford students opportunities to gain valuable practical experience in managing databases. This course will function as a introduction to other courses in the Database Design and Administration concentration, which will give students the occasion to study these topics in greater depth. The course will conclude with an examination of the future of the database field, discussing quantum computing, cloud computing and block-chain technology.