Understanding
Understanding database analytics in a practical SQL manner
(8%)
Understanding
Understand basic concepts of data streaming systems
(8%)
Understanding
Understanding different optimization techniques
(8%)
Understanding
Understanding indexing and partitioning techniques
(8%)
Applying
Applying different optimization techniques in complex database applications
(8%)
Applying
Temporal data management
(8%)
Analysing
Analyze conflicts in active databases
(8%)
Creating
Implement a basic data streaming system using a given data streaming system
(8%)
Creating
Creating database analysis using a specific data model
(8%)
Creating
Implement an active database using a given database management system
(8%)
Data Streaming
The unit will cover data streaming managements systems and provide examples of usage.
Acquisition
1Introduction
Introductory lecture on data streaming system and applications.
1h 30min
Practice
2Environment setup
Students will install the appropriate data streaming system (for example Kafka) and setup the necessary environment.
30 min
Practice
3Examples
Students will go trough prepared examples and test each example on their environment.
30 min
Discussion
4Question & Answer Session
Students will be able to ask questions about the installation, examples, exercises.
30 min
Assessment
5Exercise
Students will solve a preprared exercise that builds upon the given theory and examples.
2h 0min
5
Database Optimization Techniques
Applying different optimization techniques. Indices. Horizontal and vertical partitioning.
Acquisition
1Logical optimization techniques
Learning about different optimization techniques and how to apply them.
45 min
Acquisition
2Overview of PL/SQL
Lite overview of PL/SQL concepts
35 min
Practice
3Optimization techniques practice
Optimization techniques practice
60 min
Discussion
4Optimization techniques discussion
Optimization techniques discussion
30 min
Assessment
5Mini test
Mini test about covered topics in lectures
10 min
5
Indexing and partitioning
Indexing and partitioning
Acquisition
1Indexing
Getting to know different types of indices.
45 min
Acquisition
2Partitioning
Horizontal and vertical partitioning.
35 min
Practice
3Indexing and partitioning practice
Indexing and partitioning practice
60 min
Discussion
4Indexing and partitioning discussion
Discussion about indexing and partitioning
30 min
Assessment
5Mini test - Copy
Mini test about covered topics in lectures
10 min
5
Temporal databases
Date and Time management
Acquisition
1Data type specification
Date, Timestamp, Interval
+ variants across database systems
20 min
Acquisition
2Functions related to the date management
Functions and packages dealing with the Date and Time management, focusing on the SYSDATE, SYSTIMESTAMP and client perspective
30 min
Acquisition
3Duration management + interval
Modeling duration using Interval, explicit definition, transformations and relationships
20 min
Discussion
4Time zone reflection + cloud
Cloud management, migrations with emphasis on the time zone reflection, region management
40 min
Discussion
5Question & Answer Session
Students will be able to ask questions about the Date and Time management
10 min
Practice
6Date and time management lab
Implementation (lab)
40 min
Assessment
7NLS parameter impacts
National Language Support parameters - language, formats, territorial parameters
30 min
Investigation
8Own study and implementation
2h 0min
Assessment
9Mini test
Mini test about covered topics in lectures
10 min
5
Active Databasess
Acquisition
1Introduction to active databases
10 min
Acquisition
2Events, actions and transactions
30 min
Acquisition
3Production rules and triggers
30 min
Acquisition
4Conflicts in active databases
20 min
Practice
5Implementing active databases in SQL
45 min
Assessment
6Exercise
Students will solve a preprared exercise that builds upon the given theory and examples.
2h 0min
5
Database analytics
Acquisition
1Data warehouses, analytical databases
Principles of data warehousing, ETL
40 min
Acquisition
2Database analytics - analytical functions + dynamic windows
Aggregate and analytical functions, principles, dynamic windows
60 min
Practice
3Practical examples of database analytics
Practical examples - race results, house building, managing markets
60 min
Discussion
4Database analytics - discussions
Q&A
20 min
Practice
5Processing and analysing data from the student source