545-0087/01 – Database Query Languages (DDJ)

Gurantor departmentDepartment of Economics and Control SystemsCredits5
Subject guarantorIng. Filip Beneš, Ph.D.Subject version guarantorIng. Filip Beneš, Ph.D.
Study levelundergraduate or graduate
Study languageCzech
Year of introduction2015/2016Year of cancellation
Intended for the facultiesHGFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
BEN170 Ing. Filip Beneš, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Graded credit 2+2
Combined Graded credit 3+9

Subject aims expressed by acquired skills and competences

The course introduces students to the basics of working with relational databases through SQL structured and develops their skills in analysis, design, construction and subsequent management of relational database applications. In practice lessons students learn the practices of working with relational databases in MySQL and Microsoft SQL Server via SQL. At the end of the semester students elaborate projects aimed at implementing a simple relational databases and manipulate data using SQL.

Teaching methods

Lectures
Individual consultations
Tutorials

Summary

Compulsory literature:

SCHNEIDER, R. D.: MySQL: oficiální průvodce tvorbou, správou a laděním databází, 2006, Praha: Grada Publishing, 372 s. ISBN 80-247-1516-3. HERNANDEZ, M. J.; VIESCAS, J.: Myslíme v jazyku SQL: Tvorba dotazů, 2004, Praha: Grada Publishing, 378 s. ISBN 80-247-0899-X. GRUBER, M.: Mistrovství v SQL. 1. a 2. díl, 2002, SoftPress. ISBN 80-86497-62-3

Recommended literature:

MySQL 5.0 - Certification Study Guide

Way of continuous check of knowledge in the course of semester

E-learning

Další požadavky na studenta

Student has to elaborate individual programs.

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1. Introduction, relational databases 2. SQL language commands 3. SELECT, agregation, sorting 4. Data manipulation language - INSERT, UPDATE, DELETE 5. Transaction 6. Advaced query 7. DDL – – DROP, ALTER, CREATE, GRANT, database administration 8. VIEW 9. Triggers 10. Integrity – indexes, constraints, rules… 11. Stored procedures - basic programing concepts 12. Data access method – ODBC, ADO, RDO, … 13. Export/import from SQL server

Conditions for subject completion

Full-time form (validity from: 2015/2016 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded credit Graded credit 100  51
Mandatory attendence parzicipation:

Show history
Combined form (validity from: 2015/2016 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Graded credit Graded credit 100  51
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2019/2020 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 2 Compulsory study plan
2019/2020 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 2 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 2 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 2 Compulsory study plan
2018/2019 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 2 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 2 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 2 Compulsory study plan
2017/2018 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 2 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 2 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 2 Compulsory study plan
2016/2017 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 2 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry P Czech Ostrava 2 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Ostrava 2 Compulsory study plan
2015/2016 (B2102) Mineral Raw Materials (3902R064) System Engineering in Industry K Czech Most 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner
ECTS - FMG 2018/2019 Full-time English Optional 501 - Study Office stu. block
ECTS - FMG 2017/2018 Full-time English Optional 501 - Study Office stu. block
ECTS - FMG 2016/2017 Full-time English Optional 501 - Study Office stu. block