SQL

Relational database tongue

SQL (usually pronounced "sequel," sometimes as separate letters) is a programming language for managing and querying databases.

It handles tasks like retrieving records, inserting data, and defining table structures: Write an SQL query to pull all customers from Ohio.

SQL underlies most relational databases and remains essential knowledge for developers and data analysts.

database

tables

Flat-topped furniture pieces

fields · schema · relational · indexing · normalization · constraints · transactions · integrity · entities · attributes

variants

MySQL

Relational database management system

  • OracleProphetic shrine or speaker
  • ANSIAmerican technical standards organization
  • dialectRegional language variety

compatibility · migration · trigger · view · function · cursor

analytics

dashboard

Vehicle control panel

  • reportingConveying documented information
  • ETLSource-to-destination data process
  • metricsStandards for assessment

KPI · aggregation · pivot · rollup · cube · partitioning · trends · forecasting · data-mining · segmentation

syntax

statement

Expressed claim or fact

operator · semicolon · parentheses · quotes · case-insensitive · whitespace · comments · identifier · literal · parameter

query

subquery

Embedded database request

  • aliasAdopted false name
  • wildcardUnpredictable factor in play
  • AVGComputer protection brand

filtering · sorting

Categories
Opposites
programming paradigm

SQLC

Third alphabet letter

Python · COBOL · Java · step-by-step instructions · JavaScript

data model

SQLNoSQL

Schema-free database systems

Cassandra

data structure

SQLraw text

Unprocessed string data

natural language · spreadsheets

Phrases
Family

sequel, sequential

Familiarity
Top 500,000
Profile
Used worldwide · Timeless · Abstract · Rated G