Award in Introduction to Databases
The "Introduction to Databases" module offers students a foundational understanding of database management systems (DBMS) and their applications in various fields. Throughout the module, students will explore fundamental concepts such as data modelling, relational database design, SQL (Structured Query Language) querying, and database administration.
They will learn about different types of databases, including relational, NoSQL, and NewSQL databases, and understand their advantages, limitations, and use cases.
Key topics covered in the module include database architecture, entity-relationship modelling, normalisation, indexing, transactions, and concurrency control. Students will gain hands-on experience with popular database systems such as MySQL, PostgreSQL, or SQLite, learning how to create and manipulate databases, tables, and queries to retrieve, update, and delete data efficiently.
