Database Management Systems

Course outline

Course Code:Ε5Υ
Semester:Elective courses – Winter semester
Μονάδες ECTS:3
Weekly Teaching Hours:3
Course Page:
Instructors:VAVATSIKOS ATHANASIOS

Course Description

Data analysts and scientists work with data daily. Data resides in databases, and to be able to access data, data engineers and analysts need to communicate with databases to proceed with analysis. Relational databases provide a way for data analysts to perform critical data functions such as extract, transform, load (ETL).This course is designed to introduce the general concepts of Data Science with a focus on Relational Database Management System. By the end of this course, participants will be able to house a huge structural dataset within a day-to-day RDBMS tool like MS Access.

Purpose of the course

Upon completion of the course, students will have acquired the basic knowledge and skills necessary for the design and implementation of a DB. In particular, they will have acquired the skills to:

  • Perform the deployment role for a junior data scientist and / or a data engineering role
  • Understand the types of data and databases
  • Appreciate the use of data dictionary and harness the potential metadata for data science
  • Acquire organizational dataset from data lakes and other democratized data sources for data enrichment purposes
  • Create a RDBMS to support Data Science pipeline
  • Familiar with common RDBMS tools in particular MS Access and MySQL for ETL process
  • Deconstruct complex relational tables with MS Access and MySQL
Skip to content