PV226 Seminar LaSArIS

Faculty of Informatics
Spring 2018
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
doc. RNDr. Radek Ošlejšek, Ph.D. (lecturer)
doc. Ing. RNDr. Barbora Bühnová, Ph.D. (lecturer)
prof. RNDr. Tomáš Pitner, Ph.D. (lecturer)
Bruno Rossi, PhD (lecturer)
RNDr. David Gešvindr, Ph.D. (seminar tutor)
Guaranteed by
doc. RNDr. Eva Hladká, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: doc. RNDr. Radek Ošlejšek, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable
Thu 10:00–11:50 A218
Prerequisites
SOUHLAS
Basic experience with implementation of nontrivial program systems. Interest in Lasaris activities.
In the case of MSSQL: Basic knowledge of relational databases.
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
The capacity limit for the course is 60 student(s).
Current registration and enrolment status: enrolled: 0/60, only registered: 0/60, only registered with preference (fields directly associated with the programme): 0/60
fields of study / plans the course is directly associated with
there are 33 fields of study the course is directly associated with, display
Course objectives
Learning outcomes of the course unit The aim of the course is to support the activities of the Laboratory of Software Architectures and Information Systems (Lasaris) in research, development and teaching of theoretical topics and practical problems in building large software systems and deployment of modern information technologies in practice. It deals with the design and development of reliable and secure information systems, process and data modeling, system implementation management, and software technologies for their construction. The seminar makes acquainted with interesting research and development projects solved in Lasaris, particularly in the area of designing large IT and critical infrastructures, for example, to support smart grids. Additionally, external specialists, especially from the IT industry or from abroad, are regularly invited to talk.

In the spring 2018 semester, PV226 hosts an autonomous specialized seminar on Microsoft SQL Server (MSSQL). The seminar has been prepared by David Gešvindr (one of the leading professionals on Microsoft SQL Server in the Czech Republic) for students with deeper interest in database technologies. The seminar focuses on the administration of this database solution and on the development of effective database applications, which are capable of utilising advanced Microsoft SQL Server features. Students will practice their knowledge of MSSQL in the practical part of the seminars, where they will manage and develop sample database solutions. The seminar will also cover advanced T-SQL language constructions for advanced data querying.

Learning outcomes
Student will be able to:
- actively participate in the activities of the Software Architecture and Information Systems Laboratory (Lasaris), i.e. in research and development in the area of theoretical and practical problems in building large software systems and the deployment of modern information technology in practice; and/or in the area of designing large and critical infrastructures, for example, to support smart grids.
- apply the chosen knowledge of the design and development of reliable and secure information systems, process and data modeling, system implementation management, and software technologies for their construction.
Syllabus
  • In case of Lasaris (basic seminar):
  • Area Software architectures
  • Area Technology
  • Area Information systems and management
  • Area Applications
  • In the case of MSSQL:
  • Introduction to the Microsoft SQL Server 2017 platform
  • Installation of the MSSQL in server environment
  • Basics of the database maintenance
  • Planning database backup strategy
  • Understanding security model
  • Design and implementation of database objects
  • Advanced queries in T-SQL
  • Working with XML in the database, working with geographic data, database objects in C#
  • Locks, transactions and isolation layers
  • Index Internals and practical optimisation of queries performance
Literature
  • Toby Segaran: Programming Collective Intelligence: Building Smart Web 2.0 Applications
  • John Cheesman and John Daniels: UML Components
  • Clemenss Szyperski: Component software : beyond object-oriented programming
  • Paul Clements et al: Documenting Software Architectures: Views and Beyond
  • Ian Gorton: Essential Software Architecture
  • LUCKHAM, David C. The power of events : an introduction to complex event processing in distributed enterprise systems. Boston: Addison-Wesley, 2002, xix, 376. ISBN 0201727897. info
Teaching methods
In the case of Lasaris overview lectures on new topics in the lab and relevant topics not covered by specific courses at FI. Individual- or team- work on tasks and projects agreed with the main lecturer (e.g. a R&D project, real application development, cooperation with industry, or study material preparation).
In the case of MSSQL block seminars biweekly, consisting of theoretical and practical part at computers.
Assessment methods
In the case of LaSArIS attendance at the seminars and assessment of the results of the individual work.
In the case of MSSQL active participation at the seminars.
Language of instruction
Czech
Further Comments
Study Materials
The course is taught each semester.
Teacher's information
http://lasaris.fi.muni.cz/teaching
The course is also listed under the following terms Autumn 2009, Spring 2010, Autumn 2010, Spring 2011, Autumn 2011, Spring 2012, Autumn 2012, Spring 2013, Autumn 2013, Spring 2014, Autumn 2014, Spring 2015, Autumn 2015, Spring 2016, Autumn 2016, Spring 2017, Autumn 2017, Autumn 2018, Spring 2019, Autumn 2019, Spring 2020, Autumn 2020, Spring 2021, Autumn 2021, Spring 2022, Autumn 2022, Spring 2023, Autumn 2023, Spring 2024, Autumn 2024, Spring 2025.
  • Enrolment Statistics (Spring 2018, recent)
  • Permalink: https://is.muni.cz/course/fi/spring2018/PV226