SQL

record (aka row)

A ____________ is each individual horizontal entry that exists in a table.

column

A ______________ is a vertical entity in a table that contains all information associated with a specific field in a table.

semicolon

A __________________ is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

SELECT column1, column2, ... FROM table_name WHERE condition1 OR condition2 OR condition3 ...;

OR Syntax

fields

Every table is broken up into smaller entities called ______________; which is a column in a table that is designed to maintain specific information about every record in the table.

SELECT column1, column2, ... FROM table_name WHERE NOT condition;

NOT Syntax

SELECT DISTINCT column1, column2, ... FROM table_name;

Syntax for SELECT DISTINCT

SELECT column1, column2, ... FROM table_name WHERE condition;

Syntax for WHERE when using SELECT

SELECT COUNT (DISTINCT column_name) FROM table_name;

Syntax for returning the actual count of different/distinct values

SELECT * FROM table_name;

Syntax to select all records in a table?

SELECT column1, column2, ... FROM table_name;

Syntax to select specific records in a table?

relational database management system

What does RDBMS stand for?

Structured Query Language (SQL)

What does SQL stand for?

Standard language that lets you access and manipulate databases

What is SQL?

SELECT column1, column2, ... FROM table_name WHERE condition1 AND condition2 AND condition3 ...;

AND Syntax

No

Are SQL keywords case sensitive?

= Equal <> Not Equal > Greater than < Less than >= Greater than or equal <= Less than or equal

Basic Operators in the WHERE clause:

table

The data in RDBMS is stored in database objects called ______________; which is a collection of related data entries and it consists of columns and rows.

result-set

The data returned from a SQL Statement is stored in a result table, called the __________________.

WHERE

This clause is used to filter records and extracts only those records that fulfill a specified condition.

SELECT DISTINCT

This statement is used to return only distinct (different) values

SELECT

This statement is used to select data from a database.

NOT

Typically using in conjunction with the WHERE clause, the _________ operator displays a record if the condition(s) is NOT TRUE.

AND

Typically using in conjunction with the WHERE clause, the ___________ operator displays a record if all the conditions separated by "AND" are TRUE.

OR

Typically using in conjunction with the WHERE clause, the ___________ operator displays a record if all the conditions separated by "OR" are TRUE.