SQL
SQL, Structured Query Language, is a programming language designed to manage data stored in these relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and it helps maintain the integrity of databases, regardless of size.
We live in a data-informed world, and there are many businesses that store their information inside large, relational databases. This makes SQL a great skill not only for data scientists and engineers, but for anyone wanting to be data-literate.
SQL Concepts
- About SQL
- Aggregate Functions
- Commands
- Comments
- Constraints
- Data Types
- Date Formats
- Dates
- Indexes
- Joins
- Loops
- Math Functions
- Operators
- Optimizing Queries
- Performance Tuning
- PRIMARY KEYS
- Procedures
- SQL Errors
- SQL Subqueries
- String Functions
- Wildcards
- Window Functions
SQL contributors
BrandonDusch29 contributions- Jens.G.R.16 contributions
Sriparno0811 contributions- StevenSwiniarski10 contributions
JeremyBarbosa9 contributions
itispragativerma65608500808 contributions- MamtaWardhani7 contributions
nikolaspoczekaj7 contributions
Victoria-DR5 contributions
CaupolicanDiaz5 contributions
KyraThompson3 contributions
THE-Spellchecker3 contributions
juliaAB3 contributions
stuartmosquera2 contributions
NikhilRaikwar182 contributions
kazumi_kerr2 contributions- rclarkeweb2 contributions
haroon26atcc1 contribution- ThegenJackson1 contribution
- andersooi1 contribution
tukesh_1 contribution
DaMull1 contribution
jubalclary1 contribution- Fedoteh1 contribution
cha_zz1 contribution
the_black_knight01 contribution- arisdelaCruz14136188571 contribution
- andyguo02281 contribution
DevanshBhargava031 contribution
sharkipelago1 contribution- Kenny_Coppinger1 contribution
cslylla1 contribution
regantewksbury1 contribution- core72078777091 contribution
Contribute to Docs
- Learn more about how to get involved.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
- Learn to analyze data with SQL and prepare for technical interviews.
- Includes 9 Courses
- With Certificate
- Beginner Friendly.17 hours
- In this SQL course, you'll learn how to manage large datasets and analyze real data using the standard data management language.
- Beginner Friendly.5 hours