Introduction to Database Technology
- To introduce the basics of relational database design using the Open Source Relational Database Management System MySQL.
- To introduce a range of data retrieval methods using MySQL.
- To apply these techniques to a small business case study.
- To develop a range of professional IT skills enabling students to apply relational database open source technology in the workplace.
- Relational databases: uses; advantages/disadvantages; comparison with flat-file databases.
- Relational Database Management Systems: MySQL and benefits of open source software.
- Basic database concepts: Entities and attributes; tables and relationships; primary and foreign keys; data types.
- Gain experience in the use of the SQL query language for data definition and data manipulation. This module provides a practical grounding for further study of information systems.
- Database design: Use of entity-relationship diagrams to model user requirements; database documentation.
- Data manipulation: Enter, update and delete data; define criteria to retrieve specified data; use JOIN to retrieve data from multiple tables.
- Good IT skills.
- Use of file compression tools (compress files, extract compressed files using WinZip).
- Folder and file management (create, rename and organise folders, recognise filetypes from their file extension, change folder options).
- Web searching using a browser (save a web page, view a page source, open local files, adding to favourites, change browser settings, use History menu, download resources).
Timetables, locations and term dates
Programme specific timetables are listed in the handbooks available for each programme. Please consult the relevant programme page.
- Term dates and holiday closing
- Timetable listing modules by term and day of the week
- Timetable and venue information for the week ahead
Enrolled students can find their personal teaching timetable and the location of classes on their My Birkbeck profile.