Joe van de Bilt

Quality code and lots of coffee

Tag: SQL

SQL

April 12, 2016 / / 0 Comments

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.

Diamond Dust Server

November 21, 2015 / / 0 Comments

ddslogo The Diamond Dust Server was a small gaming community of which I was a part part of. As the technical lead I was tasked with maintaining a virtual server which hosted popular sandbox game ‘Minecraft’.

Following the success and ever increasing traffic to the server, I helped to create and design a website for the community built in PHP and hooking into a MySQL database back-end.

The website allowed for users of the server to create accounts and link to their in-game profiles which also relied on the MySQL database. Through the shared data I was able to create a platform in which users could log in online to view stats, progress and chat with other players without actually playing the game, the aim of which was to expand the community and create a space for advertising revenue.

Design North

November 14, 2015 / / 0 Comments

Design North Logo

Commissioned by the University of Sunderland Design Department I was part of a team building a website on which the University could showcase student work. The project was originally undertaken by a group of students but abandoned the project after graduating. Our job was simply to pick up where they left off.

The site was built in HTML and PHP with a MySQL database behind it. The University wanted a platform where they could upload student work for each specified course, providing a brief description of the piece and information on the student. This meant allowing users to a management window where the items could be edited and updated, while providing a public gallery and information space for guest users.

My main responsibilities were to convert the existing PHP scripting to a newer format, and add new functionality as requested by the client. This included uploading video files and producing thumbnails, an email contact page, database redesign and robust navigation linking, all to be done in time for the deadline set by the client.

The project was delivered on time in March 2015.

© 2025 Joe van de Bilt

Theme by Anders Noren — Up ↑