Hey, I'm Tomi Mester. This is my data blog, where I give you a sneak peek into online data analysts' best practices. You will find articles and videos about data analysis, AB-testing, research, data science and more…Tag: postgresql
Working with current dates and times in data science projects is quite common. In this episode of my SQL tutorial series I’ll show you the best functions that…
In this episode of the SQL tutorial series you’ll learn two simple but important commands that you’ll use frequently when working in SQL: TRUNCATE TABLE and DROP TABLE….
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…
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…
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…
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…
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…
Combining tables is a key component in data science and analytics. And SQL is really good at it! Of course each case is different, but I run into…
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….