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

The vibe coder’s guide to real coding

Things you should know as a vibe coder that will make your app actually work / not die.

Foundationalai
The Vercel update post: t̶h̶e̶ f̶r̶o̶n̶t̶e̶n̶d̶ c̶l̶o̶u̶d̶ the AI cloud

How Vercel went from deploying apps to redefining how we build them.

Company Breakdownai
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

Related terms

Blockchain

Database

GraphQL

Metadata

Migration

Multi-tenant

Support
Sponsorships
Twitter
Linkedin
Privacy + ToS