Advancing Digital South Yorkshire


Databases: Intermediate

Alternatively you might be interested in Databases: Beginner



On this short course 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 short course will allow you to analyse and document your data and help identify weaknesses while specifying how improvements could be made. You will learn about database creation, automation and cleaning. This includes database and table creation, stored procedures, schemas and user-defined types. Additionally, roles, access levels, and managing backups will be demonstrated.

Core topics:

  • Creating a database 
    • Fresh database creation 
    • From a backup file 
    • From an import file 
  • Database Automation 
    • Stored procedures 
    • Triggers 
    • Schemas 
    • User-defined types 
  • Database interaction management  
    • Roles 
    • Access levels 
    • Backups and restore  

Who should attend?

  • Tech engineers looking to manage data 
  • Those developing their databases skills
  • Data analysts  

Register your place

Pick a date from the list above and you will be taken to a registration form.

Alternatively you might be interested in Databases: Beginner

Contact Us

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

Living or working in South Yorkshire: Register your interest