Congratulations! You've learned six commands commonly used to manage data stored in a relational database. 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 TABLE creates a new table.
    • INSERT INTO adds a new row to a table.
    • SELECT queries data from a table.
    • UPDATE edits a row in a table.
    • ALTER TABLE changes an existing table.
    • DELETE FROM deletes rows from a table.
Report a Bug
If you see a bug or any other issue with this page, please report it here.