Degree Plans - Databases and Web
Specialization Databases and Web offers a number of courses on database and web management methods and technologies, data analysis, database administration, programming and development of traditional, web, database and data-intensive applications. Emphasis is put on relational and non-relational databases, social network analysis, web and multimedia search engines, methods of feature extraction. This specialization also gives a solid background in computer science preparing the graduate for subsequent master studies in computer science.
Common obligatory courses in Computer Science
Common obligatory courses for all specializations are listed above in the section giving general information.
3.1 Obligatory Courses
| Code | Subject | Credits | Winter | Summer | |
| NSWI142 | Web Applications Programming | 5 | 2/2 C+Ex | — | |
| NDBI026 | Database Applications | 4 | — | 1/2 MC | |
| NDBI007 | Database Access Methods | 4 | 2/1 C+Ex | — | |
| NDBI040 | Modern Database Systems | 5 | — | 2/2 C+Ex | |
| NSWI153 | Advanced Programming of Web Applications | 5 | — | 2/2 C+Ex | |
| NPRG036 | Data Formats | 5 | — | 2/2 C+Ex | |
| NDBI046 | Data Management | 5 | — | 2/2 C+Ex | |
| NDBI038 | Searching the Web | 4 | — | 2/1 C+Ex | |
3.2 Elective Courses
Elective courses – group 1
A prerequisite for taking either part of the State Final Exam is to have obtained at least 15 credits from courses in this group.
| Code | Subject | Credits | Winter | Summer | |
| NPRG041 | Programming in C++ | 5 | 2/2 C+Ex | — | |
| NPRG013 | Programming in Java Language | 5 | 2/2 C+Ex | — | |
| NPRG035 | Programming in C# Language | 5 | 2/2 C+Ex | — | |
| NPRG051 | Advanced C++ Programming | 5 | — | 2/2 C+Ex | |
| NPRG021 | Advanced Java Programming | 5 | — | 2/2 C+Ex | |
| NPRG038 | Advanced C# Programming | 5 | — | 2/2 C+Ex | |
| NPRG005 | Non-procedural Programming | 5 | — | 2/2 C+Ex | |
Elective courses – group 2
A prerequisite for taking either part of the State Final Exam is to have obtained at least 6 credits from courses in this group.
| Code | Subject | Credits | Winter | Summer | |
| NSWI004 | Operating Systems | 4 | 2/1 MC | — | |
| NPFL054 | Introduction to Machine Learning with R | 5 | — | 2/2 C+Ex | |
| NPFL129 | Introduction to Machine Learning with Python | 5 | 2/2 C+Ex | — | |
| NDBI045 | Video Retrieval | 5 | — | 2/2 C+Ex | |
| NDBI037 | Information Models with Ordering | 0 | 2/1 C+Ex | — | |
| NSWI166 | Introduction to recommender systems and user preferences | 4 | 2/1 C+Ex | — | |
| NDBI013 | Oracle Administration | 2 | — | 0/2 C | |
Elective courses – group 3
A prerequisite for taking either part of the State Final Exam is to have obtained at least 3 credits from courses in this group.
| Code | Subject | Credits | Winter | Summer | |
| NMAI055 | Mathematical Analysis 2 | 5 | 2/2 C+Ex | — | |
| NPRG056 | Mobile Devices Programming | 3 | 0/2 C | — | |
| NAIL120 | Introduction to Artificial Intelligence | 5 | — | 2/2 C+Ex | |
| NSWI130 | Software System Architectures | 5 | 2/2 C+Ex | — | |
| NSWI090 | Computer Networks | 3 | — | 2/0 Ex | |
| NPGR036 | Computer Vision | 5 | — | 2/2 C+Ex | |
| NPGR002 | Digital Image Processing | 4 | 3/0 Ex | — | |
| NAIL121 | Seminar on Data Mining | 4 | — | 1/2 MC | |
| NPGR035 | Machine Learning in Computer Vision | 5 | 2/2 C+Ex | — | |
3.3 Recommended Course of Study
The recommended course of study gives all the obligatory courses, while only some elective courses and optional courses are listed. Students need to choose other such courses themselves. Obligatory courses are printed in boldface, elective courses in roman, and optional courses in italics.
First year
Common to all specializations – see under general information above.Second year
| Code | Subject | Credits | Winter | Summer | |
| Programming in Java/C++/C# | 5 | 2/2 C+Ex | — | ||
| NDBI025 | Database Systems | 5 | 2/2 C+Ex | — | |
| NSWI142 | Web Applications Programming | 5 | 2/2 C+Ex | — | |
| NTIN061 | Algorithms and Data Structures 2 | 5 | 2/2 C+Ex | — | |
| NAIL062 | Propositional and Predicate Logic | 5 | 2/2 C+Ex | — | |
| NDMI011 | Combinatorics and Graph Theory 1 | 1 | 5 | 2/2 C+Ex | — |
| NSWI153 | Advanced Programming of Web Applications | 5 | — | 2/2 C+Ex | |
| NTIN071 | Automata and Grammars | 5 | — | 2/2 C+Ex | |
| NMAI059 | Probability and Statistics 1 | 5 | — | 2/2 C+Ex | |
| NPRG045 | Individual Software Project | 4 | — | 0/1 C | |
| Elective courses | |||||
| Optional courses | |||||
Third year
| Code | Subject | Credits | Winter | Summer | |
| NDBI026 | Database Applications | 4 | — | 1/2 MC | |
| NDBI007 | Database Access Methods | 4 | 2/1 C+Ex | — | |
| NDBI040 | Modern Database Systems | 5 | — | 2/2 C+Ex | |
| NPRG036 | Data Formats | 5 | — | 2/2 C+Ex | |
| NDBI046 | Data Management | 5 | — | 2/2 C+Ex | |
| NDBI038 | Searching the Web | 4 | — | 2/1 C+Ex | |
| NSZZ031 | Bachelor Thesis | 6 | — | 0/4 C | |
| Elective courses | |||||
| Optional courses | |||||
3.4 State Final Exam
The State Final Exam knowledge requirements common to all specializations are described in the first section of this chapter (General Information on Computer Science bachelor's degree plans). Students of the Databases and Web specialization will be further tested according to the list below.1. Databases
Database systems architectures. Conceptual, logical and physical view of data. Relational schema design algorithms, normal forms, referential integrity. Transaction processing. Conceptual modelling. SQL overview. Core SQL queries. Data grouping and aggregation. Joining tables. Nested queries. Stored procedures, triggers, functions. Big Data. Modern database systems. MapReduce. NoSQL databases. Graph databases. Multi-model databases.
Relevant courses
- –
Database Systems (NDBI025)
- – Database Applications (NDBI026)
- – Modern Database Systems (NDBI040)
- – Database Applications (NDBI026)
2. Data Management
Data formats. Data models for structured data, use-cases. Graph, hierarchical, tabular, and geodata data formats. Data schemas and data transformation languages. Basics of graphics, multimedia and print formats. Data vocabulary, data semantics. Data transformation, catalogization and metadata. Basics of data encryption and compression. Basics of indexing. File organization techniques, direct/indirect indexing, primary/secondary index. Hashing in external memory. Hierarchical indexing, indexing for spatial databases, spatial join, spatial query.
Relevant courses
- –
Data Formats (NPRG036)
- – Data Management (NDBI046)
- – Database Access Methods (NDBI007)
- – Data Management (NDBI046)
3. Web
Basic principles of www, HTML, XHTML, HTML5, and CSS. Architecture, principles and design pattern of web applications. Client side development, JavaScript, standard Web APIS. Web application's API and web services. Single-page applications, state management and user sessions. Server side development, CGI and CGI-like applications. Basics of web applications security. Web search. Boolean and vector models, word2vec. Hypertex search, raking, PageRank, SEO. Recommender systems. Similarity search in multimedia databases. Metric similarity indexing.
Relevant courses
- –
Web Applications Programming (NSWI142)
- – Advanced Programming of Web Applications (NSWI153)
- – Searching the Web (NDBI038)
- – Introduction to recommender systems and user preferences (NSWI166)
- – Advanced Programming of Web Applications (NSWI153)
