7 SQL Functionalities You Should Definitely Know

 By Medium - 2021-03-19

Description

SQL is an important skill for many data scientists. SQL (Structured Query Language) is a language that is very flexible and reads a lot like regular English. It allows for easy access to even the…

Summary

  • Getting better at SQL will save you time and frustration SQL is an important skill for many data scientists.
  • Aggregation functions There are lots of really useful functions that you can perform in queries.
  • Subqueries can be used within pretty much any of the clauses (including SELECT, FROM, WHERE, etc.).
  • The main query is selecting all of the columns for entries that have departments matching at least one of the department names in the list returned by the subquery.

 

Topics

  1. Backend (0.14)
  2. NLP (0.11)
  3. Database (0.08)

Similar Articles

Python and MySQL Database: A Practical Introduction

By realpython - 2021-01-22

In this tutorial, you'll learn how to connect your Python application with a MySQL database. You'll design a movie rating system and perform some common queries on it. You'll also see best practices a ...

QuickGraph#17 The English WordNet in Neo4j (part 2)

By Jesús Barrasa - 2021-02-05

In this second post on WordNet on Neo4j I will be focusing on querying and analysing the graph that we created in the previous post. I'll leave for a third one more advanced analysis and integrations ...

Introduction to Python SQL Libraries

By realpython - 2020-12-28

In this step-by-step tutorial, you'll learn how to connect to different database management systems by using various Python SQL libraries. You'll interact with SQLite, MySQL, and PostgreSQL databases ...

Creating beautiful maps with Python

By Medium - 2021-01-31

I always liked city maps and a few weeks ago I decided to build my own artistic versions of it. After googling a little bit I discovered this incredible tutorial written by Frank Ceballos. It is a…

A Complete Guide to Flexbox

By CSS-Tricks - 2020-12-03

Our comprehensive guide to CSS flexbox layout. This complete guide explains everything about flexbox, focusing on all the different possible properties for the parent element (the flex container) and ...