B_RD Relation Database

University of Finance and Administration
Winter 2012
Extent and Intensity
1/1. 3 credit(s). Type of Completion: z (credit).
Guaranteed by
RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
At the end of the course students should be able to: Use MS SQL server express edition, create database, tables, stored procedures, triggers, etc.
Syllabus
  • Installation and basic commands in MS SQL server express edition and SQL server management studio.
  • Creation of the database, tables, attributes, primary and foreign keys.
  • Advanced SELECT queries and their performance analysis.
  • Basics of T-SQL, variables, IF conditions, WHILE loops.
  • T-SQL functions for strings, dates, type conversions, math operations.
  • Stored procedures and functions, reference and value parameters.
  • Rand() function and its application for test database generation.
  • Cursors and their variants.
  • Triggers after and instead of.
  • Transactions and their impact on performance.
  • Data warehouses, functions CUBE and ROLLUP.
Teaching methods
seminar
Assessment methods
presentation of own database application
Language of instruction
Czech
Further comments (probably available only in Czech)
Information on completion of the course: ISP
The course can also be completed outside the examination period.
General note: 0.
Information on the extent and intensity of the course: 6 hodin KS/semestr.
The course is also listed under the following terms Summer 2008, Summer 2009, Summer 2010, Summer 2011, summer 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2017, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022, Summer 2023, Summer 2024, Summer 2025.
  • Enrolment Statistics (Winter 2012, recent)
  • Permalink: https://is.vsfs.cz/course/vsfs/winter2012/B_RD