Databases: Beginner

set of modern cables and connectors on shelf


On this module you would learn how to modernise, improve and optimise how you use your data. Data issues can appear because data is not effectively stored or properly managed. You may have too much data in spreadsheets that are used by different people. This module will allow you to analyse and document your data and help identify weaknesses while specifying how improvements could be made.  


In this module you will learn about the principles of databases and, how to interrogate a database. This will include what the differences between a spreadsheet and a database, how to build your own dataset and structuring a select, update, and insert statements. Additionally, cross table queries (joins) and entity relationship modelling.  

Core topics:

  • What is a database? 
    • Discussion and demonstration of what data is, how it is represented and stored 
    • Practical identification of databases, their types and format, and their benefits 
  • Tables Fields and Records
    • Concept discussion and demonstration of tables, columns, rows and data in different formats 
    • Which format is right for you? 
    • Smart structure and design 
  • CRUD – Creating, Reading, Updating & Deleting
    • Creating data using insert statements and its variations 
    • Reading data using select statements and joining multiple tables 
    • Updating data in a safe way 
    • Deleting data, the correct way 
  • Entity Relationship Diagrams and modelling
    • Discussion and application of modelling data and relationships 
    • Primary keys 
    • Foreign keys 
    • Referential integrity 

To qualify for this module, you must be employed in South Yorkshire.

Who should attend?

  • Anyone who wants to learn database querying fundamentals 
  • Anyone transitioning from one profession to another

Contact Us
Should you have any questions about taking this module, please get in touch via email:


We are currently offering bespoke modules to companies!