SQL joins are used to combine rows from more than one table. I will be setting up a code page and will provide a link when this has been completed. The different JOINs are as follows: LEFT (or LEFT OUTER) JOIN: returns all rows from the first or left hand side table, even if there are… Continue reading SQL – Joins
Indexes are special lookup tables that the database search engine can use to speed up searches and queries. An index in a database is very similar to an index in the back of a book. It is used to efficiently find all rows matching a column in your query and then walk through that subset… Continue reading SQL – Indexes
Introduction I met a good friend for lunch today who is well-informed on most anything (I really mean abso-bloomin’-lutely everything) in the IT arena. I brought up the subject of Kaggle in conversation and he looked completely blank. I tried to explain what it is to him but I don’t think I did a very… Continue reading What (or who) is Kaggle?
This is only an introduction and is not meant to be complete in any way. I am producing my own site at the moment and know that the views expressed here will change going forward. There are many sites out there to help anyone start, but this is just a “toe in the water” article.The… Continue reading Service-oriented Websites
Here’s and excerpt from an excellent and disquieting article by Coding Horror about COBOL that may have your hair standing on end – the full article is at http://blog.codinghorror.com/cobol-everywhere-and-nowhere/: COBOL is everywhere, yet is largely unheard of among the millions of people who interact with it on a daily basis. Its reach is so pervasive… Continue reading COBOL: Everywhere and Nowhere
This past weekend I completed the Front-end Foundations course at Code School (https://www.codeschool.com/) so I must be an expert in HTML and CSS. I’ll be a web designer – hooray! No, not really, but this is a great course and well worth giving a go if you want to see if web design will float… Continue reading Web Design (or HTML and CSS)