460-2045/01 – Technology Database Systems II (TDS II)

Gurantor departmentDepartment of Computer ScienceCredits2
Subject guarantorIng. Radoslav Fasuga, Ph.D.Subject version guarantorIng. Radoslav Fasuga, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2013/2014Year of cancellation2020/2021
Intended for the facultiesFEIIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
FAS01 Ing. Radoslav Fasuga, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+0
Combined Graded credit 10+0

Subject aims expressed by acquired skills and competences

The aim of the course is to increse knowledge of the subject DAIS, especially structural extension DBMS Oracle SQL - PL / SQL. For successful completion of the course must be completed with 1 sub and 1 final test and project.

Teaching methods

Lectures
Project work

Summary

Course target is to increase knowledge of database courses with English terminology and their practical use in range of Oracle company products.

Compulsory literature:

E-learning course Oracle Academy Database Programmingwith PL/SQL - Student http://academy.oracle.com

Recommended literature:

List of Presentations, Sylabus, and Tasks for solving. Available on: http://dbedu.cs.vsb.cz/SubPages/Courses/Course.aspx?course=academy

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Complete all tests and submit semestral project.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Course content: 1. Programming introduciton into PL/SQL, define attributes and data types. 2. Použití SQL v PL/SQL. 3. Programm structures for program flow. 4. Cursors. 5. Composite data types, work with exceptions. 6. Managing and using procedures and functions. 7. Managing and using procedures and functions. 8. Managing and using packages. 9. Increasing performance PL/SQL. 10. Triggers. 11. Triggers. 12. Identifiing and managing dependecies. 13. Using PL/SQL with compiler.

Conditions for subject completion

Full-time form (validity from: 2013/2014 Winter semester, validity until: 2018/2019 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded exercises evaluation Graded credit 100 (100) 51
        PL/SQL Semestr 1 Mid Term Exam 1/2 Written test 5  5
        PL/SQL Semestr 1 Mid Term Exam 2/2 Written test 5  5
        PL/SQL Semestr 1 Final Exam Written test 10  10
        PL/SQL Semestr 2 Mid Term Exam Written test 10  10
        PL/SQL Semestr 2 Final Exam Written test 10  10
        Project Project 60  60
Mandatory attendence parzicipation: obligatory participation at all exercises, 3 apologies are accepted obligatory participation at midterm and final exams (tests) and project final presentation

Show history
Combined form (validity from: 2013/2014 Winter semester, validity until: 2018/2019 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded exercises evaluation Graded credit 100 (100) 51
        PL/SQL Semestr 1 Mid Term Exam 1/2 Written test 5  5
        PL/SQL Semestr 1 Mid Term Exam 2/2 Written test 5  5
        PL/SQL Semestr 1 Final Exam Written test 10  10
        PL/SQL Semestr 2 Mid Term Exam Written test 10  10
        PL/SQL Semestr 2 Final Exam Written test 10  10
        Project Project 60  60
Mandatory attendence parzicipation: obligatory participation at all exercises, 1 apologies are accepted obligatory participation at midterm and final exams (tests) and project final presentation

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2019/2020 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2018/2019 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2017/2018 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2017/2018 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2016/2017 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2016/2017 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2015/2016 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2015/2016 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2014/2015 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2014/2015 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan
2013/2014 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology P Czech Ostrava 3 Optional study plan
2013/2014 (B2647) Information and Communication Technology (2612R025) Computer Science and Technology K Czech Ostrava 3 Optional study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner