FI1BDDB05 Databases

FI1BDDB05 Databases

  • Course description
    • Course Code
      FI1BDDB05
    • Level of Study
      5.1
    • Program of Study
      Back-End Development 1
    • Credits
      5
    • Study Plan Coordinator
      Frederick Johannes Botha, Joshua Wiggill
Teaching Term(s)
2026 Spring
About the Course

The course provides knowledge of techniques, principles and tools used to build, maintain and utilise a relational database. Candidates will learn the basic operations to interact with a relational database (create, read, update, and delete). They will also be taught how to use normalization to improve their database designs. The candidates will be taught the principles and skills to include these databases in their server-based solutions.

In previous courses, candidates have used external data sources. By learning to use databases effectively, they can create and manage their own data storage. The most common means of doing so is using a relational SQL database, which is covered in this course.

SQL is a separate language from JavaScript, but it is a simple language by comparison, and developers learning it will find many uses for it throughout their careers.

Course Learning Outcomes
Knowledge

The candidate:

  • has knowledge of the concepts of relational databases and non-relational databases
  • has knowledge of standard SQL and the elements that make up SQL statements
  • has knowledge of the principles of CRUD (create, read, update, and delete)
  • has insight into the impact of normalization on database efficiency
  • has knowledge of the process of normalization up to 3rd normal form
  • has knowledge of the steps necessary to integrate a database into a server-based solution
  • has knowledge of the techniques, principles and tools used to provide basic security to a database
Skills

The candidate:

  • can apply vocational knowledge of normalization (up to 3rd normal form) to create or improve the design of a relational database
  • masters writing simple SQL statements for use with a relational database
  • can apply SQL language knowledge to create and maintain SQL statements that can create, read, update, and delete data
  • can find information and material needed to integrate SQL database access into a server-based solution
  • can apply vocational knowledge of database security to design or asses databases access systems
General Competence

The candidate:

  • can carry our work as an SQL programmer and maintainer
Learning Activities

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.

Assessments
Form of assessmentGrading scaleGroupingDuration of assessment
Course Assignment
Pass / Fail
Individual
1 Week(s)
Reading List

Teaching materials, reading lists, and essential resources will be shared in the learning platform and software user manuals where applicable.