SQL (Structured Query Language) is used to work with relational databases, which store information in multiple separate tables that are related to each other in a predetermined structure. For example, many businesses have databases of customers with connected tables for names and order numbers.

How does SQL work with tables?

SQL (Structured Query Language) provides a syntax for creating tables of data, reading data out of tables, updating existing tables with new data, and deleting data from tables (CRUD). And you can also use it to filter, sort, and calculate (e.g., averages, sums, etc.) data.

What kind of jobs work with SQL tables?

Most developers and engineers that spend a lot of time working with data use SQL. This includes Data Scientists, Analysts, Engineers, and Administrators, as well as Back-End and Full-Stack Developers.

What else should I study if I am learning how to use SQL?

If you’re learning SQL to work with data, you might also want to consider picking up Python or R. These languages will allow you to analyze your data for valuable patterns and trends and visualize your findings with graphs, charts, and reports that are easy to understand.

Course

How to Transform Tables with SQL

Practice more SQL in this course that covers how to manipulate and transform data.

This course includes

17,964 learners enrolled

This course includes

Skill level
Intermediate
Time to complete
Average based on combined completion rates — individual pacing in lessons, projects, and quizzes may vary

2 hours
Prerequisites
1 course

We suggest you complete the following courses before you get started with How to Transform Tables with SQL:
Learn SQL

About this course

This course lets you get more sophisticated with what you can do with data. Even if you are not doing data analysis yourself, understanding what is possible is essential in today’s data-driven world.

Built in partnership with

Syllabus

4 lessons

Certificate of completion available with Plus or Pro
Earn a certificate of completion and showcase your accomplishment on your resume or LinkedIn.

The platform

Hands-on learning

Animated GIF of an AI provided error explanation within Codecademy's learning environment

An AI-generated hint within the instructions of a Codecademy project

Animated GIF of Codecademy's Job Readiness Checker tool generating a compatibility report for a senior software engineer role

Animated GIF of building a phone screen interview using Codecademy's Interview Simulator

A fill-in-the-blank JavaScript question in a Codecademy assessment

Explore features

Earn a certificate of completion

Show your network you've done the work by earning a certificate of completion for each course or path you finish.

Show proofReceive a certificate that demonstrates you've completed a course or path.
Build a collectionThe more courses and paths you complete, the more certificates you collect.
Share with your networkEasily add certificates of completion to your LinkedIn profile to share your accomplishments.