Tag: SQL best practice

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

SQL for Data Analysis – Tutorial for Beginners – ep4

You have already learned a lot about the basics of SQL for data analysis. I figured now would be a nice time to have an episode focusing only…