PV226/LaSArIS: No timetable has been entered into IS.B. Bühnová, R. Ošlejšek, T. Pitner, B. Rossi
PV226/MSSQL: Thu 16:00–19:50 A320, D. Gešvindr
Basic experience with implementation of nontrivial program systems. Interest in Lab activities. In the case of MSSQL (see Course objectives) also (PB154 Database Systems) || (PB155 Database systems and their applications) || (PB168 Introduction to DB and IS)
Course Enrollment 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 enrollment status: enrolled: 27/60, only registered: 0/60, only registered with preference (fields directly associated with the programme): 0/60
Fields of study the course is directly associated with
there are 33 fields of study the course is directly associated with, display
Students will understand current trends in software architecture and technologies for building large program systems in a broader context not limited to a specific platform. In contrast to specialized courses such as Development of Program Systems in Java (PA165) this course does not give a complete view of all layers of one platform but instead a wider spectrum of dynamically growing technologies, methods, and tools for software development in enterprise area. External experts particularly from IT industry and/or from abroad are regularly invited.
In the spring 2016 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.
In case of LaSArIS (basic seminar):
Area Software architectures
Area Information systems and management
In the case of MSSQL:
Introduction to the Microsoft SQL Server 2014 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
John Cheesman and John Daniels: UML Components
Paul Clements et al: Documenting Software Architectures: Views and Beyond
Ian Gorton: Essential Software Architecture
Toby Segaran: Programming Collective Intelligence: Building Smart Web 2.0 Applications
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
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.
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.