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: sql for data analysis
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….
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…
Today I’ll show you some more advanced SQL moves! Okay, I’d rather put them into the intermediate category. They are not beginner things — but it’s also for…
SQL (Structured Query Language) is a must if you want to be a Data Analyst or a Data Scientist. I have worked with many online businesses in the…