Choose a Currency: USD EUR SEK TRY

Organisations depend on their databases to provide information essential for their day-to-day operations and to help them take advantage of today’s rapidly growing and maturing e-commerce opportunities. An understanding of database tools and technologies is an essential skill for designing and developing systems to support them.

Database systems continue to demand more complex data structures and interfaces, as applications get increasingly sophisticated. Most organisations collect and store large volumes of data, either on their own systems or in the cloud, and this data is used not just for the operational running of their business but also mined for other more intelligent and complex applications. Databases stand as the back-end of most systems used by organisations for their operations.

Database design and development is a fundamental and highly beneficial skill for computing students to master, regardless of their specialism. The aim of this course is to give students opportunities to develop an understanding of the concepts and issues relating to database design and development, as well as to provide the practical skills to translate that understanding into the design and creation of complex databases.

Topics included in this course are: examination of different design tools and techniques; examination of different development software options; considering the development features of a fully functional robust solution covering data integrity, data validation, data consistency, data security and advanced database querying facilities across multiple tables; appropriate user interfaces for databases and for other externally linked systems; creating complex reports/dashboards, testing the system against the user and system requirements; and elements of complete system documentation.

On successful completion of this course students will be able to use appropriate tools to design and develop a relational database system for a substantial problem. They will be able to test the system to ensure it meets user and system requirements and fully document the system by providing technical and user documentation. For practical purposes, this course covers relational databases and related tools and techniques. A brief overview of object-oriented databases will also be covered.

Students will develop skills such as communication literacy, critical thinking, analysis, reasoning and interpretation, which are crucial for gaining employment and developing academic competence.

By the end of this course a student will be able to:

  • Use an appropriate design tool to design a relational database system for a substantial problem.
  • Develop a fully functional relational database system, based on an existing system design.
  • Test the system against user and system requirements.
  • Produce technical and user documentation.

For students who have recently been in education, the entry profile is likely to include one of the following:

Students must be over 18 years of age.
A Level 3 qualification in Business or an international equivalent.

The qualification is wholly in English language. Students should demonstrate capability in English at a standard equivalent to one of the identified levels below:

Common European Framework of Reference (CEFR) level B2
PTE 51
IELTS 5.5; Reading and Writing must be at 5.5
or equivalent.

Registration process:

Based on course settings, students might be requested to fill in an application and provide us with correct information about themselves before being able to proceed with the course (the application is online).
We will contact you by email if we need more details after submitting your application.
After approval, you can proceed with payment and start the course.

Materials are organized under different lessons. The lessons consist of self-study contents including reading-texts, practical activity, assignment and quizzes in which students can engage and learn.

The course has supervisors and instructors; they are available online to support students by answering their questions or explain different topics to them. This will be managed under discussion section, forums, direct contact or by online meetings.

When student successfully completes all lessons, quizzes and pass assignment, he/she will be offered a certificate.

The course is available as an individual or under Pearson Qualifications (HNC/HND) in Computing. The price will be updated based on the selected option. The individual course fee is higher because awarding body has additional fees for individual enrollment. At the same time, a discount will be automatically added when you order HNC/HND in Computing or if you’re already enrolled under these qualifications.

Courses awarded under Next Gates have no discount, and the fee is already reduced.

* Note that prices don’t include VAT. It might be added at checkout based on your location.

Course Curriculum

Section One
What is a Database? 01:30:00
Database Storage Options 01:30:00
Basic Concepts of Database 01:30:00
DBD Progress Quiz 01/08 00:20:00
Database Design 01:30:00
Database Design Phase I (Data Model) 01:30:00
Interfaces in Database Management System 01:30:00
Use Case & User Interface Tools 01:30:00
Installing Database Management System (MySQL) 01:30:00
DBD Progress Quiz 02/08 00:25:00
Section Two
Database Design Phase II 01:30:00
Entity Relationship Examples 01:30:00
Database Design Phase III 01:30:00
DBD Progress Quiz 03/08 00:20:00
Optimizing Relational Data Model (Business Rules) 01:30:00
Optimizing Relational Data Model (Normalization) I 01:30:00
Optimizing Relational Data Model (Normalization) II 01:30:00
Normalization Examples 01:30:00
DBD Progress Quiz 04/08 00:25:00
Section Three
Database Case Study I 01:30:00
Database Case Study II 01:30:00
Database Case Study III 01:30:00
Database Case Study IV 01:30:00
Section Four
Structure Query Language (SQL) I 01:30:00
Structure Query Language (SQL) II 01:30:00
Database XYZ University Case Study (Inserting Data) 01:30:00
Structure Query Language (SQL) III 01:30:00
DBD Progress Quiz 05/08 00:15:00
Advanced SQL I 01:30:00
Advanced SQL II 01:30:00
Database Performance 01:30:00
DBD Progress Quiz 06/08 00:15:00
Section Five
SQL Administration 01:30:00
Building Reports I 01:30:00
Database Reporting II 01:30:00
Database Testing I 01:30:00
DBD Progress Quiz 07/08 00:15:00
Database Testing II 01:30:00
Database Testing III 01:30:00
Database Testing IV 01:30:00
Database Documentation I 01:30:00
Database Documentation II 01:30:00
DBD Progress Quiz 08/08 00:20:00

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • 4 months
  • Course Certificate
  • 15 Credits
  • Core
  • English
  • Self Study

    Do you have a question!

      About NG Education

      Next Gates Education offers a professional qualifications and courses in which most of them are accredited by UK’s top Awarding Bodies and internationally recognized.

      Find Certificate


      Verkstadsgatan 1B 392 39 Kalmar, Sweden

      Tel: +46 700 90 77 50

      NG Education

      Online Secured Payment

      error: Alert: Content selection is disabled!!