Tag: sql query tool

coding in data science and analytics

SQL current date — How to get the current date, time, month or year in 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…

coding in data science and analytics

SQL TRUNCATE TABLE and DROP TABLE (tutorial)

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….

coding in data science and analytics

How to install SQL Workbench for postgreSQL

In my previous SQL for data analysis tutorial, I briefly mentioned that I prefer SQL Workbench over pgadmin4 for SQL querying. Today I will show you how you can install it…