Intro to Structured Query Language (SQL)

Written by abseejp | Published 2021/08/17
Tech Story Tags: sql | data | data-science | database | machine-learning | programming | coding | software-development

TLDR Structured Query Language (SQL) is one of the most common programming languages that enables one to store, retrieve, manipulate and organize data in relational databases such as MySQL, Oracle Database, and Microsoft SQL Server. In the example query, "selects all columns from tables a and b, and joins both tables anywhere there's a match on the sk_applicant and hellofresh_week field. A NULL value is returned for non-match keys." The example query uses a "FULL OUTER JOIN" to retrieve all the data retrieved with another table.via the TL;DR App

no story

Written by abseejp | Data Scientist and Technical Content Writer
Published by HackerNoon on 2021/08/17