• A
  • A
  • A
  • АБВ
  • АБВ
  • АБВ
  • А
  • А
  • А
  • А
  • А
Обычная версия сайта

Introduction to Databases

2019/2020
Учебный год
ENG
Обучение ведется на английском языке
5
Кредиты
Статус:
Курс по выбору
Когда читается:
4-й курс, 2, 3 модуль

Преподаватели


Ожегов Евгений Максимович

Course Syllabus

Abstract

The purpose of mastering the discipline “Introduction to Databases” is to familiarize students with the theoretical foundations of modern relational databases and the principles of using the SQL query language to manipulate data stored in relational tables. This discipline belongs to the cycle “Variable part of the profile”, specialization “Business analytics and applied economics”. Type of a course: with online course.
Learning Objectives

Learning Objectives

  • Know the basics of relational algebra.
  • Be able to use the SQL language to write queries.
  • To have skills in building relationships between relational tables.
Expected Learning Outcomes

Expected Learning Outcomes

  • Able to check the normalization of tables, bring the database to normal form. Able to formulate the result of query execution in the language of relational algebra.
  • Able to form relationships between tables. Able to select the required fields in the final report. Able to use filters, sorting, aggregation and window functions. Selects a time-efficient way to write a query.
Course Contents

Course Contents

  • Relational algebra
    Theme 1. Data types. The keys. The integrity of tables and data. Theme 2. Normalization of tables. Theme 3. Relations between tables.
  • SQL
    Theme 4. Basic SQL syntax. Theme 5. Data aggregation and aggregation functions. Theme 6. Window functions. Theme 7. Subqueries and submissions.
Assessment Elements

Assessment Elements

  • non-blocking Оnline course
  • non-blocking Homework
  • non-blocking Exam
Interim Assessment

Interim Assessment

  • Interim assessment (3 module)
    0.51 * Exam + 0.19 * Homework + 0.3 * Оnline course
Bibliography

Bibliography

Recommended Core Bibliography

  • Batra, R. (2018). SQL Primer : An Accelerated Introduction to SQL Basics. New York: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1833706
  • Rockoff, L. (2017). The Language of SQL (Vol. Second edition). Hoboken, NJ: Addison-Wesley Professional. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1601663

Recommended Additional Bibliography

  • Harrison, G. (2015). Next Generation Databases : NoSQLand Big Data. [Berkeley, California]: Apress. Retrieved from http://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=1170316