Structured Query Language

You are here:

I have a good working knowledge of SQL and have worked with Oracle, SQL Server, Access/Jet and MySQL databases.

I was probably first introduced to relational databases and SQL at Polymer Laboratories when a database was introduced into the company for handling sales and orders, but really only started seriously programing using SQL when I joined Consort Securities Systems which used an Access/Jet database and later SQL Server to store data imported from the stock exchange's Crest system. I worked extensively with Oracle at Parallax and Keane.

When Triton Technology introduced the identiPol QA instrument my knowledge of database design and programming came in extremely useful. Previous instruments typically ran separate individual experiments each storing their data in a simple file. However the identiPol relies on comparing data from multiple experiments, and requires coordination and grouping of data according to various properties of the individual experiments and samples under test. This therefore lent itself to a database approach to data storage.

If you are wanting any programming work doing, either debugging and fixing old systems or developing new software, please do get in touch.

Oracle Databases

I worked with Oracle databases at Parallax and Keane and have developed a good working knowledge of database programming and relational database design.

Microsoft SQL Server

I worked with SQL Server at Consort Securities Systems which used a database to store data imported from the stock exchange's Crest system. Here I developed a good working knowledge of SQL and relational database concepts.

Access / Jet database

I worked programming for an Access/Jet database at Consort Securities Systems which used a database to store data imported from the stock exchange's Crest system. Here I developed a good working knowledge of SQL and relational database concepts.

MySQL is the database system commonly used to store data used by website servers. It is a free to use system and is easily interfaced with the common Apache web server system. It is therefore much more common for use in general purpose website design and development, but still has the power and complexity if necessary that larger database system such as SQL Server and Oracle can provide.

Polymer Laboratories Ltd

I worked for Polymer Laboratories in Loughborough from around 1988 to 1995. Initially as a computer programmer and latterly as software manager in charge of the department.

Consort Securities Systems Ltd.

I worked at Consort Securities Systems Limited from 1995 to 1998.

Parallax Solutions Ltd.

I worked at Parallax Solutions Ltd. in Coventry from 1998 to 2001 working mainly in Centura Team Developer (Gupta SQL Windows) and Oracle.

I was working at Parallax Solutions Ltd. when the company was taken over by the UK division of Keane Inc., a large American software company.

Triton Technology Ltd.

I worked for Triton Technology Ltd. as software and IT manager for many years and continued to work for Lacerta Technology Ltd. which was formed from what remained after the company was sold to Mettler Toledo.

Phil Preen Contact Details

Click to send Phil a message

Computer programming

My main career for over thirty years has been as a computer programmer and software engineer. I am currently available to work part time on small projects, so please get in touch to discuss any programming or website design jobs you may have.

Oracle Databases

I worked with Oracle databases at Parallax and Keane and have developed a good working knowledge of database programming and relational database design.

Microsoft SQL Server

I worked with SQL Server at Consort Securities Systems which used a database to store data imported from the stock exchange's Crest system. Here I developed a good working knowledge of SQL and relational database concepts.

Access / Jet database

I worked programming for an Access/Jet database at Consort Securities Systems which used a database to store data imported from the stock exchange's Crest system. Here I developed a good working knowledge of SQL and relational database concepts.

MySQL is the database system commonly used to store data used by website servers. It is a free to use system and is easily interfaced with the common Apache web server system. It is therefore much more common for use in general purpose website design and development, but still has the power and complexity if necessary that larger database system such as SQL Server and Oracle can provide.

Polymer Laboratories Ltd

I worked for Polymer Laboratories in Loughborough from around 1988 to 1995. Initially as a computer programmer and latterly as software manager in charge of the department.

Consort Securities Systems Ltd.

I worked at Consort Securities Systems Limited from 1995 to 1998.

Parallax Solutions Ltd.

I worked at Parallax Solutions Ltd. in Coventry from 1998 to 2001 working mainly in Centura Team Developer (Gupta SQL Windows) and Oracle.

I was working at Parallax Solutions Ltd. when the company was taken over by the UK division of Keane Inc., a large American software company.

Triton Technology Ltd.

I worked for Triton Technology Ltd. as software and IT manager for many years and continued to work for Lacerta Technology Ltd. which was formed from what remained after the company was sold to Mettler Toledo.

Phil Preen Contact Details

Click to send Phil a message

Microsoft Excel

I have used Microsoft Excel for many years, both as a general purpose spreadsheet, and for the analysis and prentation of scientific data. I also have experience developing applications using VBA in Excel.