Data Analyst and Technical Consultant

Tag: sql

How is Amazon Redshift so fast?

How is Amazon Redshift so fast?

Redshift is a solution for big data from Amazon.  Once you’ve created a data warehouse, called a cluster, you can use SQL tools to perform analysis fast.  Really fast.

5 Tips for better SQL

5 Tips for better SQL

Here are 5 quick tips to improve your query performance and simplify your schemas.

Database Fundamentals: SQL Views

Database Fundamentals: SQL Views

Database views are searchable objects in a relational database defined by a query. The view doesn’t store data but you can query a view like you can a table.

SQL Dates, Time and Strings

SQL Dates, Time and Strings

Here are some code snippets to help you get your head around how dates and times work in SQL.

SQL Starter Kit

SQL Starter Kit

This SQL starter kit of code snippets goes beyond the basic SELECT statement.  Select distinct, filtering, aggregate functions and joins

Database Fundamentals: Relational Databases

Database Fundamentals: Relational Databases

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