SEARCH

CONTACT

email: lich@vscht.cz address:
ICT Prague
Technická 5
166 28 Prague 6
map: how to find us

ICT Prague

Logo VŠCHT

Facebook

Facebook

Bioinformatika

Bioinformatika

ENBIK

ENBIK

« one step back EDUCATION

Databases (N409049SIS)

Lecture Exercise Laboratory Examination Credits
1 2 0 Z+Zk 4
   
Guarantor Hoksza David
Teacher Hoksza David

Annotation:

Within the lecture, the student gets introduced to the fundamental methodology of correct relational database design, efficient access to data and transactional processing. The SQL language will be introduced for the students to be able to build databases and query them. All the acquired knowledge will be practiced on a chosen database platform (Microsoft SQL Server).

Syllabus:

  1. Introduction, motivation, conceptual modeling.
  2. Relations, correct relational database system design, normalization.
  3. SQL language – DDL + basics of DQL.
  4. SQL language – joins I.
  5. SQL language – joins II.
  6. SQL language – aggregation I.
  7. SQL language – aggregation II.
  8. Efficient data access – indexing.
  9. Optimization in SQL.
  10. T-SQL language – fundamentals.
  11. T-SQL language – procedures I.
  12. T-SQL language – procedures II.
  13. T-SQL language – triggers.
  14. Database-application interface.

Notes:

  • During the term students will be given three credit tests. The written exam will take place at the end of the term.