Upon completion of the course, students will be able to apply various data models and database design
\ntechniques, as well as database scheme implementation techniques, in practice. Also, students will be
\nable to use the query language to access data, as well as to optimise databases, to manage transactions
\nand concurrency, and to understand the importance and concepts of data security.<\/p>\n
Database concept. Database systems and models. Database life cycle. Database design (ER model,
\nrelational model, mapping of ER into relational model, data normalisation). SQL query language
\n(language basics, statements for data manipulation, statements for control and management functions,
\nstatements for defining objects in the database). Advanced database concepts (data integrity, indexes
\nand query optimisation; transaction and concurrency management; triggers; database performance and
\nsettings; query processing and execution plans; data security; backup and database recovery; distributed
\ndatabase systems).<\/p>\n
Requirements specification and analysis. Implementation of ER model. Mapping the ER model into a
\nrelational model. Data normalisation to the fourth normal form. Implementing commands for creating,
\nmodifying, and deleting databases and tables. Implementation of statements for data manipulation
\n(search of one or more tables, data filtering, data sorting, independent and correlative subqueries,
\ngrouping of data, combining the resulting data sets). Creating views, user functions and procedures.
\nCreating constraints and indexes. Transaction and trigger management. Providing and denying access
\nto databases and objects within the database. Creating different types of data backups and using them
\nto recover the database.<\/p>\n","protected":false},"excerpt":{"rendered":"
Objectives and outcomes Upon completion of the course, students will be able to apply various data models and database design techniques, as well as database scheme implementation techniques, in practice. Also, students will be able … Read more<\/a><\/p>\n Read more<\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[199],"tags":[],"class_list":["post-13994","post","type-post","status-publish","format-standard","hentry","category-subjects"],"acf":[],"yoast_head":"\n