SQL

  1. A container (usually a file or set of files) to store organized data.
    Database
  2. A structured list of data of a specific type.
    Table
  3. Information about database and table layout and properties.
    Schema
  4. A single field in a table. All tables are made up of one or more of these.
    Column
  5. A type of allowed data. Every table column has an associated one that restricts (or allows) specific data in that column.
    Datatype
  6. A record in a table.
    Row
  7. A column (or set of columns) whose values uniquely identify every row in a table.
    Primary Key
  8. A reserved word that is part of the SQL language. Never name a table or column using one of these.
    Keyword
  9. If you were to attempt to retrieve an individual column (prod_name) from a table (Products), how would this statement be written?
    • SELECT prod_name
    • FROM Products;
  10. If you were to attempt to retrieve multiple columns (prod_id, prod_name, prod_price) from a table (Products), how would this statement be written?
    • SELECT prod_id, prod_name, prod_price
    • FROM Products;
  11. If you were to attempt to retrieve all columns from a table (Products), how would this statement be written?
    • SELECT *
    • FROM Products;
  12. If you were to attempt to retrieve a set of unique values from a column (vend_id) within a table (Products), how would this statement be written?
    • SELECT DISTINCT vend_id
    • FROM Products;
Author
Anonymous
ID
322104
Card Set
SQL
Description
SQL
Updated