Tag: postgresql

Strategy and Business in Data Science and Analytics

A 10-minute crash course on Google Data Studio

This is a guest post from Ben Collins – freelance data analyst and developer, and founder of The Collins School of Data. What is Google Data Studio? Data…

coding in data science and analytics

SQL Interview Questions: 3 Tech Screening Exercises (For Data Analysts)

Over the last 6 years I’ve been part of many job interviews – on both sides of the table. The most fun, but also the most feared, part…

coding in data science and analytics

How to connect Google Data Studio to PostgreSQL

Connecting Google Data Studio to your PostgreSQL database is easier than you would think. I will walk you through the whole process step by step. By the end…

coding in data science and analytics

How to Import Data into SQL Tables

Following the previous article about creating data tables in SQL, now we want to load data into our freshly created SQL table. In this article, I’ll show you…

coding in data science and analytics

How to Create a Table in SQL

Working with SQL for data analysis sometimes requires creating new tables. Do you want to store the output of your SQL queries? Do you need to pull new…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep5

Combining tables is a key component of data analysis. And SQL is really good at it! Of course each case is different, but I’ve run into analytical tasks too…

coding in data science and analytics

SQL for Data Analysis – Tutorial for Beginners – ep2

This is the second episode of my SQL for Data Analysis (for beginners) series, and today I’ll show you every tiny little detail of the SQL WHERE clause….