All the data you need.

Tag: PostgreSQL

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... The post SQL current date — How to get the current date, time, month or year in postgreSQL? appeared first on Data36.
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.... The post SQL TRUNCATE TABLE and DROP TABLE (tutorial) appeared first on Data36.
Cloud Data Science 7
Welcome to Cloud Data Science 7. Announcements around an exciting new open-source deep learning library, a new data challenge and more. News Microsoft Releases DeepSpeed for Training very large ModelsDeepSpeed … The post Cloud Data Science 7 appeared first on Data Science 101.
SQL Interview Questions on the Tech Screening (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... The post SQL Interview Questions on the Tech Screening (For Data Analysts) appeared first on Data36.
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... The post How to connect Google Data Studio to PostgreSQL appeared first on Data36.
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... The post How to Import Data into SQL Tables appeared first on Data36.
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... The post How to Create a Table in SQL appeared first on Data36.