VSFS:B_RD Relation Database - Course Information
B_RD Relation Database
University of Finance and AdministrationWinter 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.
- Enrolment Statistics (Winter 2012, recent)
- Permalink: https://is.vsfs.cz/course/vsfs/winter2012/B_RD