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.

Categories
SQL 201

All About SQL Aggregate Functions

Time for some fun with SQL aggregate functions, and Mariah Carey

Categories
SQL 201

6 Ways to Search With System Tables

Your database doesn’t just contain your data. It also contains data about your data.

Categories
SQL 201

10 Ways to Tweak Slow SQL Queries

Before you rage quit or call in your DBA, check these things aren’t slowing down your SQL query. A few tweaks could be all you need to get things working.

Categories
SQL 201

Have You VACUUMed Your Tables Lately?

A high-level overview of why your DBA needs to VACUUM your tables

Categories
SQL 201

Speed up your SQL queries with Indexes

Your query is running slow, have you checked your indexes?

Categories
SQL 201

All about SQL JOINs

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

Categories
SQL 201

Why You Should Use SQL CTEs

CTEs are persisted temporary data sets, that allow you to store a single query to go back to later in your script.