SQL: Managing Tables
Learn how to manage tables in SQL.
We'll cover the following
There’s a standard language for writing commands and queries for relational databases. It’s called Structured Query Language (SQL). With SQL we can compose complex commands that filter data and process on the database management system-side. SQL is standard among all the relational database management systems, so we can learn it once, and it will be helpful for a long time.
SQL is a rich language with many nuances, so it’s impossible to learn it entirely in one lesson. This current lesson offers an overview of the most common features SQL provides. For specific, practical problems, it’s better to read the documentation for the database management system. Although SQL is a standard language, each RDBMS implements it differently and provides different data types and functions.
We’ll use a theater managing application as an example again. In particular, we’ll work with two tables, plays
and performances
.
Get hands-on with 1400+ tech skills courses.