155-0306/02 – Databases (DBS)

Gurantor departmentDepartment of Applied InformaticsCredits3
Subject guarantorIng. Vítězslav Novák, Ph.D.Subject version guarantorIng. Vítězslav Novák, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year2Semestersummer
Study languageCzech
Year of introduction1999/2000Year of cancellation2010/2011
Intended for the facultiesEKFIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
PRC0001 Anonymizovaná Osoba
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit 1+2

Subject aims expressed by acquired skills and competences

The aim of the subject is to acquire basic knowledge and skills in the area of design and implementation of relational database applications. The subject should familiarize students with the SQL language and with basic database objects such as table, view, stored procedure or trigger. Students will verify acquired knowledge on the DBMS Microsoft Office Access and Microsoft SQL Server.

Teaching methods

Lectures
Experimental work in labs
Project work

Summary

The aim of the subject is to acquire basic knowledge and skills in the area of design and implementation of relational database applications. The subject should familiarize students with the SQL language and with basic database objects such as table, view, stored procedure or trigger. Students will verify acquired knowledge on the DBMS Microsoft Office Access and Microsoft SQL Server.

Compulsory literature:

CORORNEL, Carlos and MORRIS, Steven. Database Systems: Design, Implementation, & Management (MindTap Course List). 14th Edition. Boston: Cengage Learning, 2022. ISBN 978-0357673034. KOROL, Judita. Access 2021 / Microsoft 365 Programming by Example. Herndon, Mercury Learning and Information, 2022. ISBN 978-1683928416. BEN-GAN, Itzik. T-SQL Fundamentals (Developer Reference. Redmont, Microsoft Press, 2023. ISBN 978-0138102104.

Recommended literature:

DEBARROS, Anthony. Practical SQL: A Beginner's Guide to Storytelling with Data. San Francisco, No Starch Press, 2022. ISBN 978-1718501065. GEORGE, Nathan. Mastering Access 365: An Easy Guide to Building Efficient Databases for Managing Your Dat. Redmond, GTech Publishing, 2022. ISBN 978-1916211391. SYVERSON, Bryan and MURACH, Joel. Murach's SQL Server 2022 for Developers. Fresno: Mike Murach and Associates, 2023. ISBN 978-1943873067.

Way of continuous check of knowledge in the course of semester

E-learning

Other requirements

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

Cvičení: 1.Datové modelování a projektování datových struktur, základní konstruktory konceptuálních a logických modelů. 2.Opakování základů Microsoft Accessu – návrh struktury tabulek, formulářů, sestav, definování dotazů. 3.Opakování základů programovacího jazyka Visual Basic for Application – deklarace proměnných, procedur, funkcí, základní struktury programovacího jazyka. 4.Knihovna objektů Microsoft Accessu (Microsoft Access Objects) s důrazem na vlastnosti a metody objektů Form, Report, Control a jejich praktické aplikace. 5.Přístup k datům pomocí programovacího jazyka AccessSQL (pouze DML). 6.Knihovna objektů určených pro přístup k datům ADO (ActiveX Data Objevte) s důrazem na vlastnosti a metody objektů Connection, Recordset, Command, Parameter. 7.Microsoft Access ve víceuživatelském prostředí, zabezpečení databáze.

Conditions for subject completion

Full-time form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)		Min. number of pointsMax. počet pokusů
Exercises evaluation Credit 85 (85) 0 3
        Project Project 85  0 3
Mandatory attendence participation:

Show history

Conditions for subject completion and attendance at the exercises within ISP:

Show history

Occurrence in study plans

Academic yearProgrammeBranch/spec.Spec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2009/2010 (B6209) Systems Engineering and Informatics (6209R014) Information and Knowledge Management (00) Informační a znalostní management P Czech Valašské Meziříčí 2 Compulsory study plan
2008/2009 (B6209) Systems Engineering and Informatics (6209R014) Information and Knowledge Management (00) Informační a znalostní management P Czech Valašské Meziříčí 2 Compulsory study plan
2007/2008 (B6209) Systems Engineering and Informatics (6209R014) Information and Knowledge Management (00) Informační a znalostní management P Czech Valašské Meziříčí 2 Compulsory study plan
2005/2006 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (00) Applied Informatics P Czech Ostrava 2 Compulsory study plan
2005/2006 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Valašské Meziříčí 2 Compulsory study plan
2005/2006 (B6209) Systems Engineering and Informatics (6209R001) Applied Informatics (01) Applied Infomatics P Czech Ostrava 2 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner

Assessment of instruction

Předmět neobsahuje žádné hodnocení.