Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

8 Cards in this Set

  • Front
  • Back
Structured Query Language. SQL is used to communicate with a database. it is the standard language for relational database management systems.
SQL operations
update data on a database, or retrieve data from a database. The standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database.
Table Basics
A relational database system contains one or more objects called tables. Tables are comprised of columns and rows. Columns contain the column name, data type, and any other attributes for the column. Rows contain the records or data for the columns.
The select statement is used to query the database and retrieve selected data that match the criteria that you specify.
select format
select "column1"
from "tablename"
[where "condition"];
[] = optional
You can select as many column names that you'd like, or you can use a "*" to select all columns.
(optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword where.

Conditional selections used in the where clause:

= Equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
<> Not equal to
LIKE *See note below
allows you to select only rows that are "like" what you specify. "%" is used as a wild card to match any possible character. For example:
select first, last, city
from empinfo
where first LIKE 'Er%';
(where last LIKE '%s';)