Congratulations! We’ve learned six commands commonly used to manage data stored in a relational database and how to set constraints on such data. What can we generalize so far?
SQL is a programming language designed to manipulate and manage data stored in relational databases.
- A relational database is a database that organizes information into one or more tables.
- A table is a collection of data organized into rows and columns.
A statement is a string of characters that the database recognizes as a valid command.
CREATE TABLEcreates a new table.
INSERT INTOadds a new row to a table.
SELECTqueries data from a table.
ALTER TABLEchanges an existing table.
UPDATEedits a row in a table.
DELETE FROMdeletes rows from a table.
Constraints add information about how a column can be used.
In this lesson, we have learned SQL statements that create, edit, and delete data. In the upcoming lessons, we will learn how to use SQL to retrieve information from a database!