Categories
AWS

Passing the AWS Cloud Practitioner Exam Online

I sat my AWS Cloud Practitioner exam using the new online option at work on my own laptop. Here’s what happened.

Categories
AWS

AWS Cost Optimisation

Cost optimisation can be made easier by tracking usage through tags and using AWS tools to review what can be switched off or scaled down.

Categories
AWS

AWS Security

This post will take you through the security services AWS offers and best practices they recommend to keep what’s in the Cloud safe.

Categories
AWS

Free AWS Services

Getting your head around costs is part of studying for AWS Certifications. But did you know there are services which have no cost at all?

Categories
AWS

CloudWatch or CloudTrail?

CloudTrail and CloudWatch sound similar, but there are some key differences to what they do, how they monitor services, and when you might need them in isolation or in combination.

Categories
Excel

Excel Tools

In this post I’ll be introducing three Excel tools I use for data cleansing that take only a few clicks.

Categories
Excel

Excel Logical Functions

Here are six more useful functions to use in Excel. This time, logical functions that return a result based on the conditions.

Categories
Excel

Excel VLOOKUP

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.

Categories
SQL 201

Conditional logic With the CASE expression

CASE is SQLs answer to other programming languages IF-ELSE statement. If you need to test a condition and return a value CASE is the expression you need.