Category: SQL 101

database-danceclass

Why a Database is like a Dance Class

This week I got to thinking, a ballet class is a good way to describe database concepts.

resources-sql

SQL concepts: from A to Z

Jargon busting the terms and concepts that pop up during training.

user-guide-pgadmin

The SSMS Users Guide to pgAdmin

Things to know about pgAdmin if you are an analyst migrating from SQL Server Management Studio

resources-data-analysts

Resources for Beginner Data Analysts

Everything you need to get started with SQL and becoming a great data analyst.

sql-joins

All about SQL JOINs

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

relational-databases

Relational Database Fundamentals

When working with data in relational databases there are some key concepts to understand

ssms-tips

10 ways to make the most of SSMS

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

sql-tips

Five Quick SQL Tips

Five quick tips to improve your SQL query performance and simplify your schemas.

 
Bitnami