Databases play a vital role in any backend system; from the early stages of my A levels, throughout my degree and now in my current employment I have been using SQL based systyems; and through both professional and personal interests my SQL knowledge has grown from simple web interfaces, to managing entire SQL databases in various formats, including Microsoft SQL Server, MySQL and Oracle.

I have worked with SQL Server  in a professional capacity since 2013 when I first started my professional development career. Working for a company with a tech stack ranging from 2005 to present I was became familiar with a range of SQL Server products from SQL Enterprise 2000, SQL Profiler and SQL Server 2005 – 2016. Working with Tables, Views, Stored Procedures and functions – as well as more meta datbase objects such as logins, schemas and SQL Agent Jobs. Working with large quantities of data at a time I am proficient in indexing, query optimisation and common table expressions. As well as tracking SQL through source control in DDL formats, as well as Microsoft’s inbuilt SSDT.

MySQL has been used in both my personal and freelance work – as an open source and free option it is a very powerful and cost effective database platform. Used in both Command Line and GUI capacities I have set up multiple databases, tables, functions, stored procedures and users – even the database this blog is operating on.

My degree focused on Oracle 11g, creating tables and stored procedures as well as focusing on relational algebra.