Databases: Intermediate

Introduction

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.  

Summary

In this module you will learn about database creation, use, automation and cleaning. This will include database and table creation, stored procedures, schemas and user-defined types. Additionally, roles, access levels, and managing backups will be discussed and 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  

Pre-Requisites:

• Access to a laptop or desktop with an internet connection
• Able to install Microsoft or data query programs
  • If unable to, please state during registration as there can be a virtual solution available (pending numbers) 
• Must have experience in querying, creating, updating, deleting data on a database 
• Must understand basic database functionality (e.g. has used a tool such as SQL Server Management Studio, MySQL, SQL Lite, MongoDBCompass, Access, Oracle etc) 

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

Who should attend?

• Tech engineers looking to store data 
• Web developers looking to learn databases 
• Data analysts (SAAS, Excel, C# etc) 

Contact Us
Should you have any questions about taking this module, please get in touch via email: advancingdigital@shu.ac.uk