Databases
Back
Course informations
| Study program level |
Undergraduate |
| Study program |
Electrical Engineering |
| Study program direction |
Telecommunications and informatics |
| Course year |
2. |
| Course semester |
III |
| Course status |
Core |
| ECTS |
6 |
| Lectures (h) |
30 |
| Excercises (h) |
30 |
| Seminars (h) |
- |
Course objectives
Since students will, no matter what, have access to databases in their future employment, it is necessary to ensure that they know how to properly define the basics of databases. Part of the students will work on the level of administration and maintenance of the database, while the other part will create new databases, models and relationships. In this case it is necessary to obtain the basics of the databases. Student should be able to:
- Develop and understand a simpler conceptual or logical model of data
- Define core SQL command statements and solve simpler program tasks in SQL language,
- Independently use Microsoft Access, MySQL, MSSQL server and Firebird,
- Understand what ODBC is and can use it practically
Course outcomes
- Based on real-world problems model your own database.
- Create a database in the MSSQL server, MySQL, MS access and firebird tools.
- Create basic database elements (table, view, stored procedure).
- Create simple scripts using SQL language.
- Create a database structure diagram.
- Manage users and their rights.
- Maintain and implement the backup / restore procedure of a database.
Course content
Introduction to the course and database. Database concept, database content - data and metadata. Model data, semantics, ANSI / SPARC architecture. Data abstractions. Conceptual modeling - ER-model. Relational model data - introduction, structure, integrity. Operations in Relational data model. Logical Data Model - Normalization, IDEF1X. SQL concept, standard, development. SQL DDL. SQL DML. Advanced use of SQL. Transactions, procedures, functions, triggers. Security and protection - authorization, privileges. Views - types, purpose. Faithfulness of DBMS with RMP and Codd rules. Distributed bases. Advanced concepts and application of databases. Unselected Databases (MONGODB).
