Bachelor
2019/2020
Introduction to Databases
Category 'Best Course for Career Development'
Category 'Best Course for Broadening Horizons and Diversity of Knowledge and Skills'
Category 'Best Course for New Knowledge and Skills'
Type:
Elective course (Economics)
Area of studies:
Economics
Delivered by:
School of Economics and Finance
When:
4 year, 2, 3 module
Mode of studies:
distance learning
Language:
English
ECTS credits:
5
Contact hours:
4
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
- 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
- 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
- Relational algebraTheme 1. Data types. The keys. The integrity of tables and data. Theme 2. Normalization of tables. Theme 3. Relations between tables.
- SQLTheme 4. Basic SQL syntax. Theme 5. Data aggregation and aggregation functions. Theme 6. Window functions. Theme 7. Subqueries and submissions.
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