Course Information

B_RD Relation Database

Extent and Intensity

2/1/0. 6 credit(s). Type of Completion: zk (examination).

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is a successful completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand
- problems of stored procedures, functions and triggers
- creation of views
- indexing in databases
- transactions programming and scheduling
- basics of the non SQL databases, data warehouses, and cubes

Syllabus

• Content of lectures:
• 1. Repeating SQL
• 2. Database transactions
• 3. Transaction Schedules
• 4. Views
• 5. Advanced objects - stored procedures, functions, triggers
• 6. Indexing of
• databases 7. DCL commands
• 8. Debugging SQL statements
• 9. Rationalization of SQL statements
• 10. Introduction to Business Intelligence
• 11. Data warehouses
• 12. no-SQL database

Literature

required literature
• KROENKE, David a David J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.

recommended literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2
• HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK. Big Data a NoSQL databáze. Praha: Grada, 2015. Profesionál. ISBN 978-80-247-5466-6.

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Subject ending method:
The subject is completed with a credit based on the processing of semester assignments, possibly. a short written test (as a compensation for not processing or incorrectly processing semester assignments)

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each even Tuesday 14:00–14:44 E228, each even Tuesday 14:45–15:30 E228, V. Nulíček
B_RD/pAPH: each even Tuesday 12:15–12:59 E228, each even Tuesday 13:00–13:45 E228, V. Nulíček
B_RD/vAPH: Fri 12. 4. 17:30–19:00 E304, 19:15–20:45 E304, Fri 26. 4. 14:00–15:30 E304, 15:45–17:15 E304, Sat 27. 4. 14:00–15:30 E304, 15:45–17:15 E304, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is a successful completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand
- problems of stored procedures, functions and triggers
- creation of views
- indexing in databases
- transactions programming and scheduling
- basics of the non SQL databases, data warehouses, and cubes

Syllabus

• Content of lectures:
• 1. Repeating SQL
• 2. Database transactions
• 3. Transaction Schedules
• 4. Views
• 5. Advanced objects - stored procedures, functions, triggers
• 6. Indexing of
• databases 7. DCL commands
• 8. Debugging SQL statements
• 9. Rationalization of SQL statements
• 10. Introduction to Business Intelligence
• 11. Data warehouses
• 12. no-SQL database

Literature

required literature
• KROENKE, David a David J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.

recommended literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2
• HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK. Big Data a NoSQL databáze. Praha: Grada, 2015. Profesionál. ISBN 978-80-247-5466-6.

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Subject ending method:
The subject is completed with a credit based on the processing of semester assignments, possibly. a short written test (as a compensation for not processing or incorrectly processing semester assignments)

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Tuesday 10:30–11:14 E228, each odd Tuesday 11:15–12:00 E228, V. Nulíček
B_RD/pAPH: each even Tuesday 10:30–11:14 E228, each even Tuesday 11:15–12:00 E228, V. Nulíček
B_RD/vAPH: Sat 4. 2. 9:45–11:15 E305, 11:30–13:00 E305, Fri 17. 3. 14:00–15:30 E305, 15:45–17:15 E305, Sat 1. 4. 14:00–15:30 E305, 15:45–17:15 E305, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand problems of stored procedures, functions and triggers creation of views indexing in databases transactions and their scheduling non SQL databases, data warehouses, and cubes

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• KROENKE, David a David J. AUER. Databáze. Brno: Computer Press, 2015. ISBN 978-80-251-4352-0.
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.

recommended literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2
• HOLUBOVÁ, Irena, Jiří KOSEK, Karel MINAŘÍK a David NOVÁK. Big Data a NoSQL databáze. Praha: Grada, 2015. Profesionál. ISBN 978-80-247-5466-6.

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

The course is finished by credit on the basis of seminar problems and a short written test.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Wednesday 10:30–11:14 S16PC, each odd Wednesday 11:15–12:00 S16PC, V. Nulíček
B_RD/pAPH: each even Wednesday 10:30–11:14 S16PC, each even Wednesday 11:15–12:00 S16PC, V. Nulíček
B_RD/vAPH: Fri 18. 2. 17:30–19:00 S24, 19:15–20:45 S24, Fri 18. 3. 17:30–19:00 S24, 19:15–20:45 S24, Fri 22. 4. 17:30–19:00 S24, 19:15–20:45 S24, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand problems of stored procedures, functions and triggers creation of views indexing in databases transactions and their scheduling non SQL databases, data warehouses, and cubes

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

The course is finished by credit on the basis of seminar problems and a short written test.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Monday 10:30–11:14 S24, each odd Monday 11:15–12:00 S24, V. Nulíček
B_RD/pAPH: each even Monday 10:30–11:14 S24, each even Monday 11:15–12:00 S24, V. Nulíček
B_RD/vAPH: Sat 27. 3. 9:45–11:15 E303PC, 11:30–13:00 E303PC, Sat 17. 4. 14:00–15:30 E303PC, 15:45–17:15 E303PC, Fri 23. 4. 17:30–19:00 S16PC, 19:15–20:45 S16PC, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand problems of stored procedures, functions and triggers creation of views indexing in databases transactions and their scheduling non SQL databases, data warehouses, and cubes

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

The course is finished by credit on the basis of seminar problems and a short written test.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 12 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each even Tuesday 17:30–18:14 S24, each even Tuesday 18:15–19:00 S24, V. Nulíček
B_RD/pAPH: each odd Tuesday 17:30–18:14 S24, each odd Tuesday 18:15–19:00 S24, V. Nulíček
B_RD/vAPH: Sat 15. 2. 14:00–15:30 E227, Sat 14. 3. 14:00–15:30 E227, Sat 18. 4. 14:00–15:30 E222, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand problems of stored procedures, functions and triggers creation of views indexing in databases transactions and their scheduling non SQL databases, data warehouses, and cubes

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

The course is finished by credit on the basis of seminar problems and a short written test.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Tuesday 10:30–11:14 E303PC, each odd Tuesday 11:15–12:00 E303PC, V. Nulíček
B_RD/pAPH: each even Tuesday 8:45–9:29 E303PC, each even Tuesday 9:30–10:15 E303PC, except Tue 5. 3. ; and Tue 26. 3. 8:45–10:15 E303PC, V. Nulíček
B_RD/vAPH: Fri 15. 2. 15:45–17:15 E303PC, 17:30–19:00 E303PC, Fri 1. 3. 15:45–17:15 E303PC, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

Learning outcomes of the course unit The aim of the course is to build on the knowledge gained in the Introduction to DBS in terms of advanced relational database functions. Students get acquainted with the creation of views, triggers, stored procedures. We will also deal with transaction issues and their planning and scheduling. Students will also get acquainted with non-SQL databases, data warehousing, data cubes etc.

Learning outcomes

After completing the course the student will understand problems of stored procedures, functions and triggers creation of views indexing in databases transactions and their scheduling non SQL databases, data warehouses, and cubes

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

The course is finished by credit on the basis of seminar problems and a short written test.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Tuesday 12:15–12:59 E307, each odd Tuesday 13:00–13:45 E307, V. Nulíček
B_RD/pAPH: each even Tuesday 12:15–12:59 E307, each even Tuesday 13:00–13:45 E307, V. Nulíček
B_RD/vAPH: Fri 16. 3. 17:30–19:00 E307, Fri 6. 4. 15:45–17:15 E303PC, 17:30–19:00 E303PC, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

At the end of the course the student should have practical knowledge and skills in the area of relational databases. A substantial part is devoted to creation of own database project.

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design to SQL code). The test is subject to a credit and is 50% based on the semester work and 50% to written test of the theory.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

Ing. Vladimír Nulíček, CSc. (seminar tutor)

Guaranteed by

Ing. Vladimír Nulíček, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ing. Barbora Ptáčková

Timetable of Seminar Groups

B_RD/cAPH: each odd Tuesday 10:30–11:14 DELL ROOM E302PC, each odd Tuesday 11:15–12:00 DELL ROOM E302PC, V. Nulíček
B_RD/pAPH: each even Tuesday 10:30–11:14 DELL ROOM E302PC, each even Tuesday 11:15–12:00 DELL ROOM E302PC, V. Nulíček

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

At the end of the course the student should have practical knowledge and skills in the area of relational databases. A substantial part is devoted to creation of own database project.

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design to SQL code). The test is subject to a credit and is 50% based on the semester work and 50% to written test of the theory.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1/0. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)
Ing. Vladimír Nulíček, CSc. (assistant)

Guaranteed by

RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ing. Barbora Ptáčková

Timetable of Seminar Groups

B_RD/cAPH: each even Thursday 10:30–11:14 E303PC, each even Thursday 11:15–12:00 E303PC, J. Lokoč
B_RD/pAPH: each even Thursday 8:45–9:29 E303PC, each even Thursday 9:30–10:15 E303PC, J. Lokoč
B_RD/vAPH: Fri 12. 2. 15:30–17:00 E303PC, 17:15–18:45 E303PC, Fri 26. 2. 15:30–17:00 E303PC, J. Lokoč

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

At the end of the course the student should have practical knowledge and skills in the area of relational databases. A substantial part is devoted to creation of own database project.

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures:
• 1. Basic operations with tables, data definition (149-202)
• 2. Views (243 - 262)
• 3. Indexes (203 - 222)
• 4. Control of flow in T-SQL (313 - 332)
• 5. Functions in SQL server (263 - 312)
• 6. Data modification (95 - 120)
• 7. Transactions (121 - 148)
• 8. Data aggregation, pivot tables (67 - 78)
• 9. Fulltext search (223 - 242)
• 10. Stored procedures (333 - 352)
• 11. User-defined functions and types (353 - 380)
• 12. Triggers (381 - 410)
• Source - Velká kniha T-SQL SQL server 2005, Joseph Sack, 2005

Literature

required literature
• Joseph Sack: Velká kniha T-SQL SQL server 2005, 864 stran, Zoner Press, ISBN 978-80-806815-57-2

not specified
• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design to SQL code). The test is subject to a credit and is 50% based on the semester work and 50% to written test of the theory.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)

Guaranteed by

RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Tamara Urbánková

Timetable of Seminar Groups

B_RD/cAPH: each even Thursday 10:30–11:14 E303PC, each even Thursday 11:15–12:00 E303PC, J. Lokoč
B_RD/pAPH: each odd Thursday 10:30–11:14 E303PC, each odd Thursday 11:15–12:00 E303PC, J. Lokoč
B_RD/vAPH: Sat 28. 3. 9:45–11:15 E303PC, 11:30–13:00 E303PC, Fri 24. 4. 13:45–15:15 E303PC, J. Lokoč

Prerequisites

B_UDS Introduction to Database Sys.
The requirement for the completion of this course is completion of the course B_UDS.

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

The goal is that at the end of the course the student practical knowledge and skills in the area of ​​  relational databases, as well as to get acquainted with new trends in     object-relational and object databases. A substantial part is devoted to creating your own database project.

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures: First Data Definition Language, Indexes Second integrity constraints Third Data manipulation language 4th Triggers, stored procedures 5th transaction 6th SQL and application programs, cursors 7th Rights and safety 8th IS architecture: three-tier, centralization / decentralization, replication, integration 9th data Warehousing 10th Advantages and shortcomings of the relational model, object-oriented approach 11th Object databases, Object-relational features of modern databases 12th Current trends and future vision. Summary practical approach to creating applications.

Literature

• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura
• Další zdroje

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design through SQL DDL code, one input / output form). The test is subject to a credit and is   50% based on the semester work and   50% to   written test of the theory.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)

Guaranteed by

RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.

Timetable of Seminar Groups

B_RD/cAPH: each odd Wednesday 12:15–12:59 E303PC, each odd Wednesday 13:00–13:45 E303PC, J. Lokoč
B_RD/pAPH: each even Wednesday 12:15–12:59 E303PC, each even Wednesday 13:00–13:45 E303PC, J. Lokoč

Prerequisites

It is expected the successful completion of the course Introduction to Databases

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

The goal is that at the end of the course the student practical knowledge and skills in the area of ​​  relational databases, as well as to get acquainted with new trends in     object-relational and object databases. A substantial part is devoted to creating your own database project.

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures: First Data Definition Language, Indexes Second integrity constraints Third Data manipulation language 4th Triggers, stored procedures 5th transaction 6th SQL and application programs, cursors 7th Rights and safety 8th IS architecture: three-tier, centralization / decentralization, replication, integration 9th data Warehousing 10th Advantages and shortcomings of the relational model, object-oriented approach 11th Object databases, Object-relational features of modern databases 12th Current trends and future vision. Summary practical approach to creating applications.

Literature

• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura
• Další zdroje

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design through SQL DDL code, one input / output form). The test is subject to a credit and is   50% based on the semester work and   50% to   written test of the theory.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
General note: Bb3.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)

Guaranteed by

RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Dagmar Medová, DiS.

Timetable of Seminar Groups

B_RD/cAPH: each odd Wednesday 12:15–12:59 E303PC, each odd Wednesday 13:00–13:45 E303PC, J. Lokoč
B_RD/pAPH: each even Wednesday 12:15–12:59 E303PC, each even Wednesday 13:00–13:45 E303PC, J. Lokoč
B_RD/vAPH: Sat 23. 3. 9:45–11:15 E303PC, 11:30–13:00 E303PC, Fri 12. 4. 15:30–17:00 E303PC, J. Lokoč

Prerequisites

It is expected the successful completion of the course Introduction to Databases

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives

The goal is that at the end of the course the student practical knowledge and skills in the area of ​​  relational databases, as well as to get acquainted with new trends in     object-relational and object databases. A substantial part is devoted to creating your own database project.

Syllabus

• This curriculum is designed for full-time study, course of instruction for part-time study is presented in a methodological study materials list (ML). Contents of lectures: First Data Definition Language, Indexes Second integrity constraints Third Data manipulation language 4th Triggers, stored procedures 5th transaction 6th SQL and application programs, cursors 7th Rights and safety 8th IS architecture: three-tier, centralization / decentralization, replication, integration 9th data Warehousing 10th Advantages and shortcomings of the relational model, object-oriented approach 11th Object databases, Object-relational features of modern databases 12th Current trends and future vision. Summary practical approach to creating applications.

Literature

• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura
• Další zdroje

Teaching methods

Type of teaching: Teaching consists of lectures and exercises The scope of compulsory participation in education: Minimum mandatory participation in exercises in full-time is   75%, the controlled group consultations in   50% of the combined studies. Students who fail to meet mandatory scope of participation, may be given during the semester   additional study obligations (to the extent that will demonstrate academic achievement and acquired competencies necessary for successful completion of the subject

Assessment methods

Course completion: Credit is awarded on the basis of semester work: own database project (from conceptual design through SQL DDL code, one input / output form). The test is subject to a credit and is   50% based on the semester work and   50% to   written test of the theory.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
General note: Bb3.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

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.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)

Guaranteed by

RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Wednesday 15:45–16:29 E303PC, each odd Wednesday 16:30–17:15 E303PC, J. Lokoč
B_RD/pAPH: each odd Wednesday 14:00–14:44 E303PC, each odd Wednesday 14:45–15:30 E303PC, J. Lokoč
B_RD/vAPH: Fri 10. 2. 12:00–13:30 E303PC, 13:45–15:15 E303PC, Fri 24. 2. 12:00–13:30 E303PC, J. Lokoč

Prerequisites (in Czech)

Předpokládá se úspěšné ukončení předmětu Úvod do databází

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives (in Czech)

Cílem předmětu je získat praktické znalosti a dovednosti v oblasti relačních databází, jakož i seznámit se s novými trendy v objektově relačních a objektových databázích. Podstatná část je věnována tvorbě vlastního databázového projektu.

Syllabus (in Czech)

• Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu (ML). Obsah přednášek: 1. Jazyk definice dat, indexy 2. Integritní omezení 3. Jazyk manipulace dat 4. Triggery, uložené procedury 5. Transakce 6. SQL a aplikační programy, kurzory 7. Práva a bezpečnost 8. Architektura IS: třívrstvá, centralizace/decentralizace, replikace, integrace 9. Datové sklady 10. Přednosti a nedostatky relačního modelu, objektový přístup 11. Objektové databáze 12. Objektově-relační rysy moderních databází 13. Současné trendy a vize budoucnosti. Shrnutí praktického přístupu ke tvorbě aplikací.

Literature

• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura
• Další zdroje

Assessment methods (in Czech)

Typ výuky:Výuka probíhá formou přednášek a cvičení Rozsah povinné účasti ve výuce: Minimální povinná účast na cvičení v prezenčním studiu je 75%, na řízených skupinových konzultacích v kombinovaném studiu 50%. Studentům, kteří nesplní povinný rozsah účasti, mohou být v průběhu semestru zadány dodatečné studijní povinnosti (v míře, která umožní prokázat studijní výsledky a získané kompetence nezbytné pro úspěšné zakončení předmětu Způsob zakončení předmětu: Zápočet se udílí na základě semestrální práce: vlastní databázový projekt (od návrhu konceptuálního po SQL kód DDL, jeden vstupní/výstupní formulář). Zkouška je podmíněna zápočtem a je z 50% založena na semestrální práci a z 50% na písemném testu z teorie.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin KS/semestr.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)

Guaranteed by

RNDr. Jakub Lokoč, Ph.D.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Ivana Plačková

Timetable of Seminar Groups

B_RD/cAPH: each odd Wednesday 10:30–11:14 E303PC, each odd Wednesday 11:15–12:00 E303PC, J. Lokoč
B_RD/pAPH: each even Wednesday 10:30–11:14 E303PC, each even Wednesday 11:15–12:00 E303PC, J. Lokoč
B_RD/vA21PH: Fri 1. 4. 12:00–13:30 E303PC, Sat 9. 4. 12:00–13:30 E303PC, 13:45–15:15 E303PC, J. Lokoč
B_RD/vA22PH: Fri 1. 4. 13:45–15:15 E303PC, Fri 8. 4. 12:00–13:30 E303PC, 13:45–15:15 E303PC, J. Lokoč

Prerequisites (in Czech)

Předpokládá se úspěšné ukončení předmětu Úvod do databází

Course Enrolment Limitations

The course is offered to students of any study field.

Course objectives (in Czech)

Cílem předmětu je získat praktické znalosti a dovednosti v oblasti relačních databází, jakož i seznámit se s novými trendy v objektově relačních a objektových databázích. Podstatná část je věnována tvorbě vlastního databázového projektu.

Syllabus (in Czech)

• Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu (ML). Obsah přednášek: 1. Jazyk definice dat, indexy 2. Integritní omezení 3. Jazyk manipulace dat 4. Triggery, uložené procedury 5. Transakce 6. SQL a aplikační programy, kurzory 7. Práva a bezpečnost 8. Architektura IS: třívrstvá, centralizace/decentralizace, replikace, integrace 9. Datové sklady 10. Přednosti a nedostatky relačního modelu, objektový přístup 11. Objektové databáze 12. Objektově-relační rysy moderních databází 13. Současné trendy a vize budoucnosti. Shrnutí praktického přístupu ke tvorbě aplikací.

Literature

• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura
• Další zdroje

Assessment methods (in Czech)

Typ výuky:Výuka probíhá formou přednášek a cvičení Rozsah povinné účasti ve výuce: Minimální povinná účast na cvičení v prezenčním studiu je 80%, na řízených skupinových konzultacích v kombinovaném studiu 50%. Studentům, kteří nesplní povinný rozsah účasti, mohou být v průběhu semestru zadány dodatečné studijní povinnosti (v míře, která umožní prokázat studijní výsledky a získané kompetence nezbytné pro úspěšné zakončení předmětu Způsob zakončení předmětu: Zápočet se udílí na základě semestrální práce: vlastní databázový projekt (od návrhu konceptuálního po SQL kód DDL, jeden vstupní/výstupní formulář). Zkouška je podmíněna zápočtem a je z 50% založena na semestrální práci a z 50% na písemném testu z teorie.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hodin/semestr.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: z (credit).

Teacher(s)

RNDr. Jakub Lokoč, Ph.D. (seminar tutor)

Guaranteed by

prof. Ing. Petr Berka, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Timetable of Seminar Groups

B_RD/cAPH: each odd Thursday 8:45–9:29 DELL ROOM E302PC, each odd Thursday 9:30–10:15 DELL ROOM E302PC, J. Lokoč
B_RD/pAPH: each even Thursday 8:45–9:29 DELL ROOM E302PC, each even Thursday 9:30–10:15 DELL ROOM E302PC, J. Lokoč
B_RD/vA21PH: Sat 6. 3. 9:45–11:15 DELL ROOM E302PC, 11:30–13:00 DELL ROOM E302PC, Sat 20. 3. 8:00–9:30 DELL ROOM E302PC, J. Lokoč
B_RD/vA22PH: Sat 6. 2. 14:00–15:30 DELL ROOM E302PC, Sat 20. 2. 11:30–13:00 DELL ROOM E302PC, 14:00–15:30 DELL ROOM E302PC, J. Lokoč

Prerequisites (in Czech)

Předpokládá se úspěšné ukončení předmětu Úvod do databází

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

• Applied Informatics (programme VSFS, B-INF) (2)

Course objectives (in Czech)

Cílem předmětu je získat praktické znalosti a dovednosti v oblasti relačních databází, jakož i seznámit se s novými trendy v objektově relačních a objektových databázích. Podstatná část je věnována tvorbě vlastního databázového projektu.

Syllabus (in Czech)

• Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu (ML). Obsah přednášek: 1. Jazyk definice dat, indexy 2. Integritní omezení 3. Jazyk manipulace dat 4. Triggery, uložené procedury 5. Transakce 6. SQL a aplikační programy, kurzory 7. Práva a bezpečnost 8. Architektura IS: třívrstvá, centralizace/decentralizace, replikace, integrace 9. Datové sklady 10. Přednosti a nedostatky relačního modelu, objektový přístup 11. Objektové databáze 12. Objektově-relační rysy moderních databází 13. Současné trendy a vize budoucnosti. Shrnutí praktického přístupu ke tvorbě aplikací.

Literature

• Povinná literatura
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• Doporučená literatura
• Další zdroje

Assessment methods (in Czech)

Typ výuky:Výuka probíhá formou přednášek a cvičení Rozsah povinné účasti ve výuce: Minimální povinná účast na cvičení v prezenčním studiu je 80%, na řízených skupinových konzultacích v kombinovaném studiu 50%. Studentům, kteří nesplní povinný rozsah účasti, mohou být v průběhu semestru zadány dodatečné studijní povinnosti (v míře, která umožní prokázat studijní výsledky a získané kompetence nezbytné pro úspěšné zakončení předmětu Způsob zakončení předmětu: Zápočet se udílí na základě semestrální práce: vlastní databázový projekt (od návrhu konceptuálního po SQL kód DDL, jeden vstupní/výstupní formulář). Zkouška je podmíněna zápočtem a je z 50% založena na semestrální práci a z 50% na písemném testu z teorie.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 6 hod. za semestr.

B_RD Relation Database

Extent and Intensity

1/1. 3 credit(s). Type of Completion: zk (examination).

Teacher(s)

RNDr. Helena Palovská, Ph.D. (seminar tutor)

Guaranteed by

prof. Ing. Petr Berka, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Timetable of Seminar Groups

B_RD/cAPH: each even Thursday 16:30–17:15 DELL ROOM E302PC, each even Thursday 17:30–18:14 DELL ROOM E302PC, H. Palovská
B_RD/pAPH: each odd Thursday 16:30–17:15 DELL ROOM E302PC, each odd Thursday 17:30–18:14 DELL ROOM E302PC, H. Palovská
B_RD/vA21PH: Sat 4. 4. 8:00–9:30 DELL ROOM E302PC, Sat 18. 4. 9:45–11:15 DELL ROOM E302PC, 11:30–13:00 DELL ROOM E302PC, H. Palovská
B_RD/vA22PH: Sat 4. 4. 9:45–11:15 DELL ROOM E302PC, Sat 18. 4. 14:00–15:30 DELL ROOM E302PC, 15:45–17:15 DELL ROOM E302PC, H. Palovská

Prerequisites (in Czech)

Předpokládá se úspěšné ukončení předmětu Úvod do databází

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

• Applied Informatics (programme VSFS, B-INF) (2)

Course objectives (in Czech)

Anotace je stejná pro všechny formy studia Cíl kursu Cílem předmětu je získat praktické znalosti a dovednosti v oblasti relačních databází, jakož i seznámit se s novými trendy v objektově relačních a objektových databázích. Podstatná část je věnována tvorbě vlastního databázového projektu.

Syllabus (in Czech)

• Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu (ML). Obsah přednášek: 1. Jazyk definice dat, indexy 2. Integritní omezení 3. Jazyk manipulace dat 4. Triggery, uložené procedury 5. Transakce 6. SQL a aplikační programy, kurzory 7. Práva a bezpečnost 8. Architektura IS: třívrstvá, centralizace/decentralizace, replikace, integrace 9. Datové sklady 10. Přednosti a nedostatky relačního modelu, objektový přístup 11. Objektové databáze 12. Objektově-relační rysy moderních databází 13. Současné trendy a vize budoucnosti. Shrnutí praktického přístupu ke tvorbě aplikací.

Literature

• http://nb.vse.cz/~palovska/uds/tskripta.zip
• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997

Assessment methods (in Czech)

Vyučující metody Metody hodnocení Způsob zakončení: Zápočet se udílí na základě semestrální práce: vlastní databázový projekt (od návrhu konceptuálního po SQL kód DDL, jeden vstupní/výstupní formulář). Zkouška je podmíněna zápočtem a je z 50% založena na semestrální práci a z 50% na písemném testu z teorie.

Language of instruction

Czech

Further comments (probably available only in Czech)

The course can also be completed outside the examination period.
Information on the extent and intensity of the course: 8 hod. za semestr.

B_RD Relation Database

Extent and Intensity

2/1. 4 credit(s). Type of Completion: zk (examination).

Teacher(s)

RNDr. Helena Palovská, Ph.D. (seminar tutor)

Guaranteed by

prof. Ing. Petr Berka, CSc.
Department of Computer Science and Mathematics – Departments – University of Finance and Administration
Contact Person: Lenka Bažantová

Timetable of Seminar Groups

B_RD/cAPH: each odd Monday 15:45–16:29 DELL ROOM E302PC and each even Monday 15:45–16:29 DELL ROOM E302PC, H. Palovská
B_RD/pAPH: Mon 14:00–14:44 DELL ROOM E302PC, Mon 14:45–15:30 DELL ROOM E302PC, H. Palovská
B_RD/vA21PH: Sat 19. 4. 9:45–11:15 DELL ROOM E302PC, 11:30–13:00 DELL ROOM E302PC, Sat 3. 5. 9:45–11:15 DELL ROOM E302PC, 11:30–13:00 DELL ROOM E302PC, H. Palovská
B_RD/vA22PH: Sat 19. 4. 14:00–15:30 E303PC, 15:45–17:15 E303PC, Sat 3. 5. 14:00–15:30 E303PC, 15:45–17:15 E303PC, H. Palovská

Prerequisites (in Czech)

Předpokládá se úspěšné ukončení předmětu Úvod do databází

Course Enrolment Limitations

The course is also offered to the students of the fields other than those the course is directly associated with.

fields of study / plans the course is directly associated with

• Applied Informatics (programme VSFS, B-INF) (2)

Course objectives (in Czech)

Anotace je stejná pro všechny formy studia Cíl kursu Cílem předmětu je získat praktické znalosti a dovednosti v oblasti relačních databází, jakož i seznámit se s novými trendy v objektově relačních a objektových databázích. Podstatná část je věnována tvorbě vlastního databázového projektu.

Syllabus (in Czech)

• Tato osnova je určena pro prezenční studium, průběh výuky pro kombinované studium je uveden ve studijních materiálech formou metodického listu (ML). Obsah přednášek: 1. Jazyk definice dat, indexy 2. Integritní omezení 3. Jazyk manipulace dat 4. Triggery, uložené procedury 5. Transakce 6. SQL a aplikační programy, kurzory 7. Práva a bezpečnost 8. Architektura IS: třívrstvá, centralizace/decentralizace, replikace, integrace 9. Datové sklady 10. Přednosti a nedostatky relačního modelu, objektový přístup 11. Objektové databáze 12. Objektově-relační rysy moderních databází 13. Současné trendy a vize budoucnosti. Shrnutí praktického přístupu ke tvorbě aplikací.

Literature

• Milan Šimůnek: SQL - kompletní kapesní průvodce. Grada 1999, 248 stran, ISBN 80-7169-629-7.
• Pokorný J., Halaška I.: Databázové systémy, Cvičení (Jazyk SQL a systém ORACLE), skripta ČVUT, Fakulta elektrotechnická, Praha 1997
• http://nb.vse.cz/~palovska/uds/tskripta.zip

Assessment methods (in Czech)

Vyučující metody Metody hodnocení Způsob zakončení: Zápočet se udílí na základě semestrální práce: vlastní databázový projekt (od návrhu konceptuálního po SQL kód DDL, jeden vstupní/výstupní formulář). Zkouška je podmíněna zápočtem a je z 50% založena na semestrální práci a z 50% na písemném testu z teorie.

Language of instruction

Czech

Further comments (probably available only in Czech)

Information on the extent and intensity of the course: 8 hod. za semestr.

• Enrolment Statistics (recent)