Database systems
Ing. Roman DANEL, Ph.D.
Office: K305
Study materials
Back
Texts and presentations
Introduction to databases, database types
Introduction to database design
Data types
Tables, CRUD, SQL
Indexes
Exercises
Municipality - CREATE TAB
Municipality - INSERT DATA
Office db - CREATE TAB
Office db - INSERT DATA
Exam
Basic knowledge of SQL (Select, update, delete, insert)
Basic knowledge of relational database (ERD, integrity, primary and foreign key)
Overview about database objects (trigger, view, stored procedure, ...)
Database security (authentication, authorization)