FI2DEDM75 Database Management
FI2DEDM75 Database Management
- Course description
- Course CodeFI2DEDM75
- Level of Study5.2
- Program of StudyDevOps Engineering
- Credits7,5
- Study Plan CoordinatorFrederick Johannes Botha
This course teaches candidates the basics of databases both in theory and practical implementation, so that they will be able to integrate databases into any development projects. Candidates will understand the principles of how modern database systems are structured, including how to use, design, and initialize a relational database. Candidates will gain practical experience in the use of queries, stored procedures, and database calls. As well as how to administer basic SQL commands within a hosted database server. Candidates will also learn about user management, data security, and how to perform database maintenance through monitoring and regular backup or restore procedures.
The candidate…
- has knowledge of concepts, theories, models, processes, and tools used in database design, implementation, and administration.
- has knowledge of relational database principles, including schema design, data modelling, and normalisation.
- has knowledge of database types, their use cases, and the advantages and disadvantages of relational databases.
- has knowledge of SQL fundamentals, including queries, stored procedures, and database calls.
- has knowledge of user management, access control, data security, and backup/restore procedures.
- has knowledge of best practices for database optimisation, documentation, and integration into applications and services.
- can assess his/her own database design and administration work in relation to applicable norms, standards, and industry requirements.
- is familiar with the history, traditions, and role of database management in the broader field of software development and information systems.
- has insight into his/her own opportunities for development in database administration, optimisation, and security specialisation.
The candidate…
- can explain his/her vocational choices in relation to database design, implementation, and administration practices.
- can reflect over his/her own vocational practice in database management and adjust it under supervision to meet project needs and standards.
- can find and refer to information, documentation, and vocational material on databases and assess its relevance to specific database-related issues.
The candidate…
- can plan and carry out database-related tasks and projects alone or as part of a group, in accordance with ethical requirements and data protection principles.
- can exchange points of view with others in the trade/discipline and participate in discussions about the development of good database management practices.
- can contribute to organisational development by implementing efficient, secure, and well-documented database solutions that support broader business or project goals.
Digital Learning Resources
The learning management system (LMS) is the primary learning platform where students access most of their course materials. The content is presented in various formats, such as text, images, models, videos or podcasts. Each course follows a progression plan, designed to lead students through weekly modules at their own pace. Exercises and assignments (individual or in groups) are embedded throughout the courses to support continuous practice and assessment of the learning outcomes.
Campus Resources
In addition to the digital learning resources, campus students participate in physical learning activities led by teachers as part of the overall delivery.
Guidance
Guidance and feedback from teachers support students' learning journeys, and may be provided synchronously or asynchronously, individually or in groups, via text, video or in-person feedback.