Category: Data Analysis & SQL

SQL joins without Venn diagrams

November 17, 2018

Joining tables is the first big learning curve after getting your head around SQL basics.

Excel VLOOKUP

September 29, 2018

VLOOKUP lets Excel do the hard work of matching up a value from one spreadsheet to another. It saves time and is an essential Excel tool.

How to customise SQL Server Management Studio (SSMS)

August 4, 2018

SSMS is highly customisable, here’s 10 ways to make it work best for you.