SQL - Learn Data Science with Travis

Travis chat

Let’s Talk SQL

Analytics Vidhya

According to an IADSS article* SQL is the second most common skill listed in data science job postings — only python is more common. This makes SQL a core skill for any data scientist, data analyst…

About SQL

Codecademy

SQL stands for S tructured Q uery L anguage, and is the programming language implemented by a database management system (DBMS) used for managing and querying data held in a relational database. SQL h...

SQL BASICS

Analytics Vidhya

Structured Query Language (SQL) is one of the essential languages used by data scientists. It is designed to manage and query data in relational databases like MySQL and PostgreSQL. It’s also one of…

SQL Riddles to Test Your Wits

Towards Data Science

Timestamps, dependent filters, and misbehaving left joins Continue reading on Towards Data Science

SQL queries

Towards Data Science

I don’t use SQL very often and every time I need it, I find myself googling for the syntax of even the most basic operations. To help myself out, I have put together a cheat sheet of useful queries…

First steps to SQL!

Analytics Vidhya

When we think about the amount of data we are storing and using, it looks like SQL is going to be around for a long time. Let’s assume that we have a database on a server. This server can be on a…

Introduction to SQL

Renan Moura – Software Engineering

It doesn’t matter if you are a frontend, backend, or a full stack developer, knowing SQL is a must have skill. What is SQL and why you should learn it SQL stands for Structured Query Language. It is p...

SQL in Data Science

Towards Data Science

This post will serve as a tutorial for querying data with SQL (Structured Query Language). For the purposes of this tutorial, I will be using the SQLite3 library, which provides a relational database…...

SQL for Pythonistas

Python in Plain English

… in Data Engineering in a nutshell Continue reading on Python in Plain English

What is SQL?

Python in Plain English

What is SQL? SQL ( Structured Query Language ) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream p...

SQL Fundamentals I

Level Up Coding

SQL stands for Structured Query Language. In some applications, it is also known as DSL, or Domain Specific Language. SQL is used to manage and manipulate data stored in a relational database manageme...

SQL for beginners

Towards Data Science

For the last five weeks, I have been publishing SQL lessons on Medium. Several of my mates expressed an interest in learning data science while social distancing, so I thought it would be fun to help…...