technically logo

Learn

Company Breakdowns
What technical products actually do and why the companies that make them are valuable
Knowledge Bases
In-depth, networked guides to learning specific concepts
Posts Archive
All Technically posts on software concepts since the dawn of time
Terms Universe
The dictionary of software terms you've always wanted

Explore knowledge bases

AI, it's not that ComplicatedAnalyzing Software CompaniesBuilding Software ProductsWorking with Data Teams
Loading...

Meet Technically

Technically exists to help you get better at your job by becoming more technically literate.

Learn more →

Solutions for Teams

For GTM Teams
Sell more software to developers by becoming technically fluent.
For Finance Professionals
Helping both buy-side and sell-side firms ask better technical questions.
General Team Inquiries
Volume discounts on Technically knowledge bases.
Loading...
Pricing
Sign In
← Back to Universe

SQL

databasesintermediate

SQL is how you talk to relational databases. It's a programming language (although some would debate this) that lets you read, write, and update data, but also more, like add users, create functions, and other fun database admin tasks. Popular relational databases like PostgreSQL and MySQL unsurprisingly run on SQL.

A typical SQL statement might look like this:

SELECT 
first_name,
last_name,
address,
last_order_date
FROM users
WHERE signup_date > '2019-01-01'

SQL is pretty human readable – even if you don’t know it, you can guess what we’re doing here – and it’s a really useful thing for everyone to know, even if you’re not en engineer.

Read the full post ↗

SQL for the rest of us

If you’re not a data scientist but you have questions, you want to know SQL.

Read in the Knowledge Base →

Mentioned in

Why do developers choose different types of databases?

An intro to how companies like Elastic, MongoDB, Snowflake, Confluent and AWS compete.

Category Breakdowndatabases
What's a Data Migration?

Data migration is about transferring information (data) from one place to another.

Appliedanalytics
The Excel User's Guide to Databases: Migrations

Why your feature is held up by a migration and why this is actually good.

Applieddatabases
What’s a data science notebook?

Data Science Notebooks help data teams explore data with code.

Appliedanalytics

Related terms

Blockchain

Database

GraphQL

Metadata

Migration

Multi-tenant

Support
Sponsorships
Twitter
Linkedin
Privacy + ToS