PV226 Seminar LaSArIS

Faculty of Informatics
Spring 2013
Extent and Intensity
0/2. 2 credit(s) (plus extra credits for completion). Type of Completion: z (credit).
Teacher(s)
prof. RNDr. Tomáš Pitner, Ph.D. (lecturer)
doc. Ing. RNDr. Barbora Bühnová, Ph.D. (lecturer)
doc. RNDr. Radek Ošlejšek, Ph.D. (lecturer)
RNDr. David Gešvindr, Ph.D. (lecturer)
Guaranteed by
doc. RNDr. Vlastislav Dohnal, Ph.D.
Department of Computer Systems and Communications – Faculty of Informatics
Contact Person: prof. RNDr. Tomáš Pitner, Ph.D.
Supplier department: Department of Computer Systems and Communications – Faculty of Informatics
Timetable of Seminar Groups
PV226/LaSArIS: Thu 10:00–11:50 G107, B. Bühnová, R. Ošlejšek, T. Pitner
PV226/MSSQL: each even Monday 14:00–17:50 B116, D. Gešvindr
Prerequisites
SOUHLAS
Basic experience with implementation of non-trivial program systems. Interest in working in the Lab.
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 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
Course objectives
Students understand current trends in software architectures and technologies for building large program systems in a broader context not limited to a concrete platform. In contrast to specialized courses such as Development of Program Systems in Java (PA165) 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 including Web 2.0 applications, Cloud Computing, hosted development and deployment, modern business models will be presented.

In the spring 2013 semester, PV226 hosts an autonomous specialized seminar on Microsoft SQL Server (MSSQL). 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.
Syllabus
  • In case of LaSArIS (basic seminary):
  • Area Software architectures
  • Area Technology
  • Area Information systems and management
  • Area Applications
  • In the case of MSSQL:
  • Introduction to the Microsoft SQL Server 2012 platform
  • Installation of the MSSQL in server environment
  • Basics of the database maintenance
  • Planning database backup strategy
  • Understanding security model
  • Tools for effective database development
  • Working with T-SQL querying language
  • Working with native XML in the database
  • Storing and querying geographical data in database
  • Storing and querying hierarchical data in database
  • Programming database objects in C#
  • Storing binary data using FILESTREAM and FileTable technology
  • Using Full-text Search and Semantic Search
  • Optimizing database performance
Literature
  • Ian Gorton: Essential Software Architecture
  • 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
Teaching methods
In the case of LaSArIS overview lectures on new topics in the lab and relevant topics not covered by specific subjects at FI. Individual- or team- work on tasks and projects agreed with one of the lecturers (e.g. a R&D project, publication, real application, or learning objects).
In the case of MSSQL block lectures (4 hours) biweekly, consisting of theoretical and practical part at computers.
Assessment methods
In the case of LaSArIS presentation of the results of the individual work specified by a lecturer.
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, Autumn 2013, Spring 2014, Autumn 2014, Spring 2015, Autumn 2015, Spring 2016, Autumn 2016, Spring 2017, Autumn 2017, Spring 2018, 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 2013, recent)
  • Permalink: https://is.muni.cz/course/fi/spring2013/PV226